Results 1 to 2 of 2

Thread: How to Copy a MySQL account / databse

  1. #1
    Join Date
    Oct 2004
    Location
    Rio de Janeiro - Brasil
    Posts
    183

    How to Copy a MySQL account / databse

    hello,

    we have a crashed server, some services are not running, like mysql

    last backup that we have for a account, does not have the mysql files (probably mysql was already not running)

    we can found the account files at /var/lib/mysql on the crashed server

    can someone point us in how to move this to a new server?

    thanks in advance!
    WebHostingTalk now in portuguese -> www.webhostingtalk.com.br venha se juntar a nossa comunidade sobre hospedagem web

  2. #2
    Join Date
    Apr 2005
    Location
    GMT +7.00
    Posts
    11,023
    Hello,

    The whole /var/lib/mysql directory can be easily transfered between mysql servers of the same version.

    If you copy /var/lib/mysql it might or not help to run MySQL. The things might be worse if InnoDB tables are crashed, or you've got other files missing or corrupted. So to restore all the tables you might still need to have backups.
    With regards, Alex.

    Professional Server Management for web hosting companies and individuals
    Hourly Support, Disaster Recovery, Server Hardening, Monthly Subscription
    Directadmin installation and optimization

    Click here if you need a Linux Admin

Posting Permissions

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