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

This article mainly introduces the method of importing backup files into mysql, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

Backup is needed for data migration and recovery. The export using mysqldump is basically sql data sentences, and you can directly use the mysql command to restore the data.

1. Restore to the specified database

Mysql-hhostname-uusername-ppassword databasename

< backupfile.sql 2、还原压缩的MySQL数据备份文件 gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename 3、直接将备份导入到新的数据库 mysqldump -uusername -ppassword databasename | mysql -host=192.168.1.101 -C databasename 4、使用source导入sql文件 mysql >

Use cmdbmysql > source / data/cmdb_backup.sql above are all the contents of mysql's method of importing backup files. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.