Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to solve the problem of errors in importing sql files into navicat, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

In a project, the database is often divided into the actual application database and the test database. The most direct method is to export the .sql file from the source database and then import it into the local database. For example, there is a project database on the server that now wants to export a copy to the server for testing. You can connect to the server database locally using Navicat for MySQL, but there is always an error in the .sql file exported from the server database and then imported into the local database (as shown in the following figure).

Figure 1: error importing sql file

The specific solutions are as follows:

Step 1 Import the data and structure into the local database

1. Create a local database with the same name as the database.

two。 Select the database in Navicat that connects to the server, and select tools-data transfer in the menu bar, as shown in the following figure.

Figure 2: performing data transfer under the tool

3. In the pop-up data transfer window, the "source" part is the source database you want to export, and the "target" is the local database. Click the bottom left corner to select all, and then click the "start" button.

Figure 3: data transfer window

4. Click OK in the pop-up dialog box.

Figure 4: click OK in the prompt box

5. When the data transfer is complete, click the close button in the lower right corner, as shown in the following figure.

Figure 5: data transfer completion step 2 export .sql from backup and import it into local database

1. Create a new backup on the database in the connected server, select the database you want to back up, click the backup button on the menu bar, and then click New backup. Then select backup file, right-click and select extract SQL, as shown in the following figure.

Figure 6: extracting SQL

two。 Click "start" in the pop-up extraction dialog box, select the location to save the file, and then automatically start extracting the file. When the extraction is complete, click close to close the dialog box.

Figure 7: extract SQL file window

3. In this way, we get the .sql file of the backup dump, and then import the .sql file into the local database, and there is no longer an error, as shown in the following figure.

Figure 8: extracting the SQL file correctly

Thank you for reading this article carefully. I hope it will be helpful for everyone to share how to solve the problem of errors in importing sql files into navicat. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.