Where is the LIST of MySQL databases stored on the hard drive?

Started by DeveloperMcD, May 05, 2016, 04:27:59 AM

Previous topic - Next topic

DeveloperMcD

When I click on "MySQL Manager" (under SQL Services) and view the
"List of MySQL databases and users that have access to database"

Where does this list of databases come from? I know where the individual MySQL databases are stored (/var/lib/mysql). But there has to be a database somewhere on the hard drive, maintained by CentOS Web Panel, of what databases are on the system.

Can anyone help me?




Sandeep


DeveloperMcD

So in theory, if I restored all databases in /var/lib/mysql to another server, not only would the MySQL databases move over but the very LISTING database (used by CWP to show what MySQL databases you have on the server) would move over as well?

Because I tried this and it didn't work.


DeveloperMcD

Well, how would I go about it?

What database am I not including in my copy process?

Sandeep

fresh install is necessary. Or copy and move the whole server.

DeveloperMcD

That's what I'm trying to do. Copy an entire server's config over to another, different machine (overwriting everything on that machine)

I start by installing CWP and the plug-ins I'm using, then I copy all the config/content over. I'm almost there!
CWP's Mysql listing of available DBs still doesn't show anything -- though the DBs are all there..


Jae

interesting threat, in case panel fail to start, manual recover database is very important w/o mysql dump backup.
Acording to this lnk, http://www.webhostingtalk.com/showthread.php?t=670578 we only need to copy whole folder manually, and set permision..

if you can move mysql by this way, pls share with us..