ABHIONLINUX
Site useful for linux administration and web hosting

Showing posts with label mysqldump. Show all posts
Showing posts with label mysqldump. Show all posts

2009/10/01

How to take mysql backup and restore

To take the backup
---------------
mysqldump database > databasebackup.sql

To restore the mysql backup
---------------------------
mysql database < databasebackup.sql

To unzip database.sql.gz
------------------------
gunzip database.sql.gz