Find the answer to your Linux question:
Results 1 to 3 of 3
Hi, I had a mysql server crashed. The admin gave me a compressed file of /var/lib/mysql. How can i restore the data in it into MySQL?...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie raghaven.kumar's Avatar
    Join Date
    Mar 2008
    Location
    Bangalore, India
    Posts
    209

    Exclamation [SOLVED] Mysql crash !


    Hi, I had a mysql server crashed. The admin gave me a compressed file of /var/lib/mysql.

    How can i restore the data in it into MySQL?

  2. #2
    Just Joined!
    Join Date
    May 2006
    Posts
    43
    As far as I know, you only need to stop the mysql server, uncompress the data file into /var/lib/mysql and restart the server.

  3. #3
    Linux Newbie raghaven.kumar's Avatar
    Join Date
    Mar 2008
    Location
    Bangalore, India
    Posts
    209

    Thumbs up

    thanks for the reply man
    but i created a database with same name copied the content from tar to
    the local folder /var/lib/mysql/<dbname>.
    Restarted mysql.

    It works fine now.

  4. $spacer_open
    $spacer_close

Posting Permissions

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