Win navicat directly exported SQL script import Linux mysql error problem

In the last few days in the project to the win on the database to Ubuntu, so the first thing is to export the SQL script from the win Navicat directly, and then into the Ubuntu import will report errors, skip the error continues to cause the database table missing.

Cross-platform error actions are as follows:

If all is win under the words, the above operation is possible, import and export are not errors, but to Linux under the time, there will be SQL error, the first thought is because of the database version problem, in Ubuntu installed several versions, finally stopped in the latest version of 8.0.3. Later asked colleagues know: Navicat exported SQL has been navicat changed.

Open SQL file discovery manually,

At the bottom of the list are things like cursors, but when we write SQL, we know that generally saved SQL is a collection of built-in statements and INSERT statements.

So we looked at Navicat's other methods of exporting SQL, and got the method one: backup first, then extract the SQL

Seemingly can be extracted directly, in short, the SQL script extracted from here is able to import Linux success and no errors. (There is little MySQL version problem)

Method Two: Export directly using the command line

-uroot-p Database name > Xxx.sql

After entering the password, the SQL is automatically exported to the bin directory, which can be used to import Linux after it is found.

To import Linux, you can use Navicat, refer to my other post http://www.cnblogs.com/hellxz/p/7638238.html

Win navicat directly exported SQL script import Linux mysql error problem