备份数据,在mysql的bin目录
1、备份表:mysqldump -p mobileerp resource > mobileerp_resource.txt;
2、备份库:mysqldump -p mobileerp > resource.txt;
3、数据导入文件:select xxx,xxx into outfile "路径" from access_log_history where ....
总是用了忘,每次都要再查,记录一下,嘿嘿,见笑了
1、备份表:mysqldump -p mobileerp resource > mobileerp_resource.txt;
2、备份库:mysqldump -p mobileerp > resource.txt;
3、数据导入文件:select xxx,xxx into outfile "路径" from access_log_history where ....
总是用了忘,每次都要再查,记录一下,嘿嘿,见笑了