24Mar/090
mySQL Backup e Restore
Backup
Método 1
mysqldump -u root -h mysqserver -p --result-file=dbname_dbtable.sql dbname dbtable
Método 2
mysql>mysqldump -u root -p dbname > dbname_dbtable.sql
Restaurar
mysql -u root -h mysqserver -p dbname < dbname_dbtable.sql