Home / server / Questions / 574436
In Process
RayofCommand
Asked: 2014-02-11 04:02:36 +0800 CST

How to find a database location on server using phpmyadmin?

  • 772

I am pretty new to managing servers, right now I have trouble to find the location of our database. I see the DB in phpmyadmin, is there a way to find the real location using phpmyadmin ?

Running ubuntu 12.04 server

mysql

1 Answers

  1. First, get rid of phpMyAdmin. It's just a giant security hole, and doesn't even have a very pretty interface. You'll find that almost no professional DBAs or system administrators will go anywhere near it. It's not even really necessary, since the basics of SQL aren't hard to pick up.

    Second, the database files themselves are in MySQL's datadir, so just check that in /etc/my.cnf or ask MySQL where it is.

    SHOW VARIABLES LIKE 'datadir';
    • 4