Mysql backing up and restoring a database

From Teknologisk videncenter
Revision as of 05:58, 13 March 2009 by Heth (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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 

 mysqladmin -u USERNAME -pPASSWORD create DATABASE

Restore the database from a mysqldump file 

mysql -u USERNAME -pPASSWORD wikidb < /home/backup/wikidbbackup02152009-13:34.dump
Retrieved from "http://mars.merhot.dk/w/index.php?title=Mysql_backing_up_and_restoring_a_database&oldid=2648"