[04] HOW DO I BACKUP OR RESTORE MY MYSQL DATABASE?
To backup your MySQL database:
------------------------------
From any SDF system type:
$ mysqldump -h ol -u $LOGNAME -p $LOGNAME > backup_file_name.sql
Note: ol is the short name for the MySQL host system, ol.freeshell.org
To restore your database from a dump file:
------------------------------------------
From any SDF system type:
$ mysql -h ol -u $LOGNAME -p $LOGNAME < backup_file_name.sql
Important Notes: Backup and Restore differ in the following ways -
To backup a MySQL database use the mysqldump command and the
output redirector >
To restore a MySQL database use the mysql command and the
input redirector <
back