Results 1 to 6 of 6
  1. #1
    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.

  2. #2
    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."

  3. #3
    Manual "Moving an InnoDB Database to Another Machine":
    http://dev.mysql.com/doc/refman/5.1/en/moving.html

  4. #4
    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.

  5. #5
    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?

  6. #6
    Killall mysqld process and then try to copy the data. I think it should work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •