MySQL????????????????е????б?
???????????? ???????[ 2016/3/24 10:48:59 ] ????????????? MySQL
????Mysql??????????????????????????????????????????????Mysql?????????????????????????????????
????????1?????????
???????????????
???????????????????????????????
????mysqldump -h localhost -uroot -p123456 -d database > dump.sql
????????????????????????????????
????mysqldump -h localhost -uroot -p123456 -d database table > dump.sql
???????????????????
?????????????????????
????mysqldump -h localhost -uroot -p123456 -t database > dump.sql
??????????????+????
????????????????????????
????mysqldump -h localhost -uroot -p123456 database > dump.sql
????????????????????????
????mysqldump -h localhost -uroot -p123456 database table > dump.sql
????????2????????????б??SQL
????mysql -N -s information_schema -e "SELECT CONCAT('TRUNCATE TABLE '??TABLE_NAME??';') FROM TABLES WHERE TABLE_SCHEMA='eab12'"
?????????????£?
????TRUNCATE TABLE AUTHGROUPBINDINGS;
????TRUNCATE TABLE AUTHGROUPS;
????TRUNCATE TABLE AUTHUSERS;
????TRUNCATE TABLE CORPBADCUSTOMINFO;
????TRUNCATE TABLE CORPSMSBLACKLISYInfo;
????TRUNCATE TABLE CORPSMSFILTERINFO;
????TRUNCATE TABLE CORPSMSINFO;
????TRUNCATE TABLE EABASEREGINFOS;
????TRUNCATE TABLE EACORPBLOB;
????TRUNCATE TABLE EACORPINFO;
????....
????....
?????????????????
????mysql -N -s information_schema -e "SELECT CONCAT('TRUNCATE TABLE '??TABLE_NAME??';') FROM TABLES WHERE TABLE_SCHEMA='eab12'" | mysql eab12
?????????eab12?????е???
????????????????????????????????????????-f
????mysql -N -s information_schema -e "SELECT CONCAT('TRUNCATE TABLE '??TABLE_NAME??';') FROM TABLES WHERE TABLE_SCHEMA='eab12'" | mysql -f eab12
????????м??Σ???????????
??????????Mysql?????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11