mysqldump -u root -p -h <db-host> --opt <db-name> -d --single-transaction | sed 's/ AUTO_INCREMENT=[0-9]*\b//' > <filename>.sql
使用 if not exists
sed -i 's/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g'
mysqldump -u root -p -h <db-host> --opt <db-name> -d --single-transaction | sed 's/ AUTO_INCREMENT=[0-9]*\b//' > <filename>.sql
使用 if not exists
sed -i 's/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g'
转载于:https://www.cnblogs.com/getong/p/5132996.html