BitBonsai Labs Mauricio Wolff's geekness

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

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment


No trackbacks yet.