MySQL implementation of SQL text file

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

When a backup or restore database is often used for batch text file, save as SQL text file, execute method to restore the data in the Window platform and Linux platform.:

1: Window, The CMD command execution, access to the MySql installation directory such as D: CD Program Files\MySQL\MySQL Server 5.5\bin MySQL -uroot -p123456 test, enter and <E:test.sql

2: Linux, mysql -uroot -p123456 test <E:test.sql

<Implementation of E:test.sql for text files > E:test.sql to generate a text file

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download

Posted by Lucia at December 12, 2013 - 10:06 PM