Results 1 to 3 of 3

Thread: [SOLVED] Restoring MySQL databases from data/ files

  1. #1
    Join Date
    May 2008
    Location
    Auckland, New Zealand
    Beans
    69
    Distro
    Ubuntu 8.04 Hardy Heron

    [SOLVED] Restoring MySQL databases from data/ files

    A while ago I backed up some MySQL data by copying all the directories and files in the MySQL data/ directory. I do not know what version of MySQL I was using at the time. It was XAMPP on WinXP that I installed about one year ago.

    I have recently built Ubuntu Server version 8.04 and want to restore these databases.

    What would the best way be to restore my databases? Could there be any problems if my previous version of MySQL differs from my current version?

    Cheers.

  2. #2
    Join Date
    Mar 2006
    Location
    Williams Lake
    Beans
    Hidden!
    Distro
    Ubuntu Development Release

    Re: Restoring MySQL databases from data/ files

    You could copy the databases to /var/lib/mysql then make sure that they read/write permissions and are owned by mysql and mysql group.

    Code:
    sudo chown mysql.mysql *
    and for permission:

    Code:
    sudo chmod 700 *
    Jim

  3. #3
    Join Date
    May 2008
    Location
    Auckland, New Zealand
    Beans
    69
    Distro
    Ubuntu 8.04 Hardy Heron

    Re: Restoring MySQL databases from data/ files

    Worked a treat.
    Thanks.

Bookmarks

Posting Permissions

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