- copy from the definitive version of ipmid (on sunset):
mysqldump -h sunset -u root ipmid >sunset_ipmid.sql
- Edit the dump file (sunset_ipmid.sql) and put these lines at the beginning:
SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS=0;
- Put these lines at the end:
SET FOREIGN_KEY_CHECKS = 1; COMMIT; SET AUTOCOMMIT = 1;
- import the amended dumpfile:
mysql -u drs -p -h it023611 ipmid < sunset_ipmid.sql