当前位置: 代码迷 >> 综合 >> mysql备份数据库的命令
  详细解决方案

mysql备份数据库的命令

热度:31   发布时间:2024-01-15 05:47:12.0

 

上干货:

备份库:(注意这里直接备份是默认加了锁的,生产环境这样会有事故的啊)

Mysqldump -u root -p --tab=/backup sales

恢复操作:

方法一: shell$ mysql -u root -p sales < /backup/orders.sql

   Shell$mysqlimport -u root -p --local sales /backup/orders.txt

方法二: mysql> use sales

  Mysql>source /backup/orders.sql

  Mysql>load data local infile ‘/backup/orders.txt’ into table orders

 

扩展:

which mysqldump command argument is used to dump only data from the userdata table.

--no-create-info to skip writing CREATE TABLE statements

不产生锁的方式,备份单张表格,employees库里的表departments:

mysqldump -uroot -p employees  departments --single-transaction --master-data=2    > /tmp/departments3.sql

 

===============End,=================

  相关解决方案