Mysql executes SQL text files

Batch text files are often used to back up or restore databases and saved as SQL text files. The methods for restoring data on Windows and Linux platforms are as follows:

1: Window, cmd command execution, enter the MySql installation directory such as D: cd Program Files \ MySQL Server 5.5 \ bin, press enter and mysql-uroot-p123456 test <E: test. SQL

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

<E: test. SQL: Execution Text File> E: test. SQL: Generate text file