SQL Backup Commands – Magento

These are the most simple ways to backup your database, and to used your backed up database using command line (I tend to use Putty)

Advertisements

Simple database backup
mysqldump -u {yoursiteusername} –p{password} {yoursitedatabasename} > dbdump.sql

Simple database update
mysql -u {yoursiteusername} -p{password} {yoursitedatabasename} < dbdump.sql

Tags:

Comments are closed

Latest Comments

No comments to show.