Mysql备忘

 

备份数据库:mysqldump -h localhost -u root -p password --default-character-set=utf8 dbname > d:\backup.sql
还原数据库:mysql -h localhost -u root -p password --default-character-set=utf8 dbname < d:\backup.sql