Print this pagePrint this page

How to make a backup of my database via command line?


You can make a backup of MySQL database using mysqldump program distributed with MySQL. E.g.:

mysqldump --opt -u User -p Database > VA_Shop_Dump.sql

It should create a file VA_Shop_Dump.sql that will contain the dump of your database. Please read more about dumping MySQL database at mysql.com.