MySQL data migration using MySQLdump command

The advantages of this solution are simplicity and ease of use; the disadvantage is longer downtime. Therefore, it is suitable for situations where the amount of data is not large, or a longer downtime is allowed, and it can be completed within this time frame.

Following are some uses of MySQLdump command:

1. Export the entire database data and table files into a sql file

mysqldump -uroot -proot database1 > database1.sql

2. Import the data of the sql file into mysql instead of mysqldump

mysql -uroot -proot database2 < database1.sql

3. Export the data and structure of a table in the database to a sql file

mysqldump -uroot -proot database1 tablename > table1.sql

4. Import the data of the sql file into mysql instead of mysqldump

mysql -uroot -proot database1 < database1.sql

5. The mysql data migration command backs up the data in the database table whose id is greater than 22. The SQL is as follows

mysqldump -u test -ptest database table --default-character-set=gbk -t --where="id>22" >c:\test.sql

6. Back up the information of students older than 30

mysql> select * from students where Age > 30 into outfile '/tmp/stud.txt'; 
mysql> load data infile '/tmp/stud.txt' into table students;

Summarize

The above is the full content of this article. I hope that the content of this article will have certain reference learning value for your study or work. Thank you for your support of 123WORDPRESS.COM. If you want to learn more about this, please check out the following links