mysql数据库备份与还原命令_MySQL导出导入数据命令

mysql 数据库备份与还原命令

1>导出某个数据库表结构

mysqldump –uroot –ppassword –d dbname > /home/test/dbfiles/dbtables.sql

mysqldump –uroot –ppassword –d dbname tablename1>/home/test/dbfiles/dbtable.sql

mysqldump –uroot –ppassword –d dbname tablename1 tablename2>/home/test/dbfiles/dbtable.sql

mysqldump –uroot –ppassword dbname>/home/test/dbfiles/db.sql

mysql –uroot –ppassword dbname tablename1>/home/test/dbfiles/dbtable1.sql

mysql –uroot –ppassword dbname tablename1 tablename2>/home/test/dbfiles/dbtables.sql

mysql  -u root –p password dbname < /home/test/dbfiles/db.sql

Mysql>/home/test/dbfiles/db.sql;

【注意】还原备份命令是mysql不是mysqldump

mysql

https://www.leftso.com/article/6.html