MySQL database backup and restore

MySQL Database backup

1. Use the mysqldump command to back up:
   Command line:

2. >

   --Use the root user to back up the person table under the test database;

3. Copy the entire database directory directly:
   Copy the database files from MySQL directly. This is the simplest and fastest method.

4. Quick Backup using the Mysqlhotcopy tool:
   Command line:

   [[Email protected] ~] # mysqlhotcopy [option] dbname1 dbname2 backupdir/

MySQL database data restore:

1. To restore using the mysqldump command:
   Command line:
   

   MySQL < C:\backup.sql

2. To restore a backup of a direct copy directory:

MySQL database backup and restore