Archive | March 2014

You are browsing the site archives by date.

MySQL Different command for Backup and Restore Databases

Backup Database Making backup all databases: mysqldump -u usuario -p –all-databases > dump.sql Making backup only one database: mysqldump -u usuario -p –databases db1 > dump.sql Making backup many databases: mysqldump -u usuario -p –databases db1 db2 db… > dump.sql Making backup using gzip compresson mysqldump -u usuario -p –all-databases | gzip > dump.sql.gz Making […]