Where is saved the mysql database?

Discussion in 'Server Operation' started by hhhhhh, Sep 5, 2009.

  1. hhhhhh

    hhhhhh New Member

    Hello!

    My server burst like a balloon and I have a backup of the database from the last day :mad: so I need to connect my HDD to other pc and get a copy of all databases.

    The problem is that I can't do it through Phpmyadmin because the Linux don't run so I must search into the server folders.

    I am using an Ubuntu 8.04 server.

    Where is the correct patch to get the databases?

    Thank you
     
  2. falko

    falko Super Moderator Howtoforge Staff

    Normally the databases are stored in the /var/lib/mysql directory.
    If MySQL is running, you can create SQL dumps like this: http://www.howtoforge.com/faq/6_3_en.html (you don't need phpMyAdmin for it.)
     
  3. hhhhhh

    hhhhhh New Member

    Oh! Thank you very much falko!!
     

Share This Page