[ SDF Public Access UNIX System .. Est. 1987 ]

join welcome faq status members projects store tour gopher abuse dialup dsl minecraft social
tilde nihongo europa webmail gallery usermap teach irc tutorials software telnet ssh

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


©1987-2065 SDF Public Access UNIX System, Inc. 501(c)(7)
(this page was generated using ksh, sed and awk)