MYSQL2014. 8. 19. 17:55

/usr/local/mysql/bin/mysqldump --skip-comments --skip-extended-insert --no-data -u root -p -h dev.service.co.kr  project | sed 's/AUTO_INCREMENT=[0-9]* //' > dev.sql

/usr/local/mysql/bin/mysqldump --skip-comments --skip-extended-insert --no-data -u root -p -h db.service.co.kr project  | sed 's/AUTO_INCREMENT=[0-9]* //' > pro.sql

vimdiff dev.sql pro.sql

Posted by 다오나무