TA貢獻1804條經(jīng)驗 獲得超7個贊
RENAME TABLE old_db.table TO new_db.table;
mysql -u username -ppassword old_db -sNe 'show tables' | while read table; \ do mysql -u username -ppassword -sNe "rename table old_db.$table to new_db.$table"; done
for table in `mysql -u root -ppassword -s -N -e "use old_db;show tables from old_db;"`; do mysql -u root -ppassword -s -N -e "use old_db;rename table old_db.$table to new_db.$table;"; done;
-p
-u username -ppassword
Trigger in wrong schema
mysqldump old_db | mysql new_db
mysqldump -R old_db | mysql new_db
TA貢獻1872條經(jīng)驗 獲得超4個贊
mysqldump -u username -p -v olddatabase > olddbdump.sql mysqladmin -u username -p create newdatabase mysql -u username -p newdatabase < olddbdump.sql
mysqladmin -u username -p create newdatabase mysqldump -u username -v olddatabase -p | mysql -u username -p -D newdatabase
TA貢獻1799條經(jīng)驗 獲得超6個贊
舉報