Results 1 to 6 of 6
Thread: ibdata1 - need help transfer.
-
05-02-2007, 08:06 PM #1Ottomatic backup specialist
- Join Date
- Aug 2006
- Location
- Canada
- Posts
- 763
ibdata1 - need help transfer.
Hello,
How do I transfer my ibdata1 from /var/lib/mysql?
I tried rsyncing and SCPing but it always gets corrupted.
Thanks,
Otto█ Otto Yiu
█ Rsync Palace ● Providing offsite backups since 2007.
█ Backomatic ● Hassle-free Automated cPanel/WHM, DirectAdmin, FTP, and MySQL backups.
-
05-02-2007, 08:49 PM #2Web Hosting Master
- Join Date
- Nov 2005
- Location
- Minneapolis, MN
- Posts
- 1,648
The MySQL server needs to be shutdown if you want to copy those files directly.
Eric Spaeth
Enterprise Network Engineer :: Hosting Hobbyist :: Master of Procrastination
"The really cool thing about facts is they remain true regardless of who states them."
-
05-02-2007, 08:52 PM #3Disabled
- Join Date
- Aug 2002
- Posts
- 308
Manual "Moving an InnoDB Database to Another Machine":
http://dev.mysql.com/doc/refman/5.1/en/moving.html
-
05-02-2007, 08:55 PM #4Ottomatic backup specialist
- Join Date
- Aug 2006
- Location
- Canada
- Posts
- 763
spaethco: Did that, I even copied it to a new directory first and then rsynced it.
█ Otto Yiu
█ Rsync Palace ● Providing offsite backups since 2007.
█ Backomatic ● Hassle-free Automated cPanel/WHM, DirectAdmin, FTP, and MySQL backups.
-
05-03-2007, 06:12 AM #5Web Hosting Guru
- Join Date
- Nov 2005
- Location
- Palma de Mallorca, Spain
- Posts
- 263
Have you checked your mysqld is not being automatically restarted by something like SIM, during the rsync?
-
05-03-2007, 06:33 AM #6Newbie
- Join Date
- Apr 2007
- Posts
- 18
Killall mysqld process and then try to copy the data. I think it should work