home changes contents help options

Edit history

Edit: -1 of 1
Time: 2007-01-28 00:24:00
Note: /domains/culverden/wiki/MySQLBackup/edit 
changed:
-
1. copy from the definitive version of ipmid (on sunset):: 

 mysqldump -h sunset -u root ipmid >sunset_ipmid.sql



2. Edit the dump file (sunset_ipmid.sql) and put these lines at the beginning::

 SET AUTOCOMMIT = 0;
 SET FOREIGN_KEY_CHECKS=0;


3. Put these lines at the end::

 SET FOREIGN_KEY_CHECKS = 1;
 COMMIT;
 SET AUTOCOMMIT = 1;


4. import the amended dumpfile::

  mysql -u drs -p -h it023611 ipmid < sunset_ipmid.sql