[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 <

You are viewing proxied material from sdf.org. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.