Data migration and recovery require backup. The data exported using mysqldump are basically SQL data sentences, and the data can be restored directly using the mysql command.
1. Restore to the specified database
mysql -hhostname -uusername -ppassword databasename < backupfile.sql
2. Restore the compressed MySQL data backup file
gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename
3. Directly import the backup into the new database
mysqldump -uusername -ppassword databasename | mysql -host=192.168.1.101 -C databasename
4. Use source to import the sql file
mysql > use cmdb mysql > source /data/cmdb_backup.sql
Summary
These simple commands are basically used when re-migrating. If it is an online database, you must also consider the lock table, binlog, etc., step by step.
The above is the detailed content of How to import backup files in mysql. For more information, please follow other related articles on the PHP Chinese website!