备份products_groups数据表为products_groups.bak文件,products_groups.bak存放路径默认为mysql安装时的路径的相应数据库的下面
select * into outfile 'products_groups.bak' from products_groups;
恢复备份的数据
load data infile 'products_groups.bak' into table products_groups;
备份products_groups数据表为products_groups.bak文件,products_groups.bak存放路径默认为mysql安装时的路径的相应数据库的下面
select * into outfile 'products_groups.bak' from products_groups;
恢复备份的数据
load data infile 'products_groups.bak' into table products_groups;
转载于:https://my.oschina.net/u/943048/blog/109025