mySQL - database backup commands - MySQL Snipplr Social Repository

Revision: 14586

at October 11, 2009 13:09 by stiobhart

Updated Code

-- dump mySQL database to file:
VAR=$(date +Ã¢ï¿½ï¿½%y-%m-%dÃ¢ï¿½ï¿½); mysqldump -v -uUSERNAME -pPASSWORD -hlocalhost DATABASENAME > /BACKUPDIR/$VAR-DATABASENAME.sql ;

-- dump mySQL database to file and then move it:
VAR=$(date +Ã¢ï¿½ï¿½%y-%m-%dÃ¢ï¿½ï¿½); mysqldump -v -uUSERNAME -pPASSWORD -hlocalhost DATABASENAME > /BACKUPDIR/$VAR-DATABASENAME.sql ; mv /BACKUPDIR/DATABASENAME.sql  /OTHERBACKUPDIR/$VAR-DATABASENAME.sql ;

Revision: 14585

at June 7, 2009 11:23 by stiobhart

Initial Code

-- dump mySQL database to file:
VAR=$(date +â€œ%y-%m-%dâ€œ); mysqldump -v -uUSERNAME -pPASSWORD -hlocalhost FORUMNAME > /BACKUPDIR/$VAR-FORUMNAME.sql ;

-- dump mySQL database to file and then move it:
VAR=$(date +â€œ%y-%m-%dâ€œ); mysqldump -v -uUSERNAME -pPASSWORD -hlocalhost FORUMNAME > /BACKUPDIR/$VAR-FORUMNAME.sql ; mv /BACKUPDIR/FORUMNAME.sql  /OTHERBACKUPDIR/$VAR-FORUMNAME.sql ;

Initial URL

Initial Description

CLI commands for backing up mySQL database

Initial Title

mySQL - database backup commands

Initial Tags

mysql, database, command, backup

Initial Language

MySQL

Choose a language for easy browsing: