Difference between revisions of "Mysql backing up and restoring a database"
From Teknologisk videncenter
m (New page: == Backing up a mysql database == Following example will backup a database called wikidb to a file /home/backup/wikidbbackup02152009-13:34.dump <source lang="bash"> mysqldump -u USERNAME ...) |
(No difference)
|
Revision as of 09:23, 19 February 2009
Backing up a mysql database
Following example will backup a database called wikidb to a file /home/backup/wikidbbackup02152009-13:34.dump
mysqldump -u USERNAME -pPASSWORD --default-character-set=latin1 wikidb -c > /home/backup/wikidbbackup`date +%d%m%Y-%H:%M`.dump
Restore a mysql database
If the database do not exist in mysql, first create an empty database
MISSING
mysql -u USERNAME -pPASSWORD wikidb < /home/backup/wikidbbackup02152009-13:34.dump