SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    The Hiding One lynlimz's Avatar
    Join Date
    Jul 2000
    Location
    Singapore
    Posts
    2,103
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Backing Up/Retrieving Data from Down-ed MySQL

    Hi,

    My site's MySQL is not running. Connections cannot be made and I'm not sure whats the problem. Now, I need to get the data from the databases. I tried mysqldump but upon asking for password, just stalls there.

    Is there a method to retrieve the data while mysql is not running? I can't start mysql btw.

    I have SSH access to the server. I can't reboot as its hosted in another country. My host isn't responding too.

    Any guidance is greatly appreciated. Thanks.
    "Imagination is more important than knowledge. Knowledge is limited. Imagination encircles the world."
    -- Albert Einstein

  2. #2
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    find the directory where the mysql data files are stored. i don't know where on linux there are usually stored, but if you do a search for *.frm, you should be able to find them. you can them drop the folder that corresponds to the database in question in to the data directory of another mysql installation. ince you do that, make sure to run a REPAIR on the tables.

    innodb is a little different, so if you need those instructions, let me know.

    if the mysql server is on another server, you're at the mercy of your host.


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
  •