Control Web Panel

WebPanel => MySQL => Topic started by: DeveloperMcD on May 05, 2016, 04:27:59 AM

Title: Where is the LIST of MySQL databases stored on the hard drive?
Post by: DeveloperMcD on May 05, 2016, 04:27:59 AM

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?

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: DeveloperMcD on May 08, 2016, 04:13:18 PM

Does no one know the answer to this?

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: Sandeep on May 08, 2016, 08:58:25 PM

Login to phpmyadmin as mysql root user.

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: DeveloperMcD on May 09, 2016, 09:29:17 PM

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.

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: Sandeep on May 09, 2016, 09:48:34 PM

this will not work ..

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: DeveloperMcD on May 10, 2016, 01:52:38 AM

Well, how would I go about it?

What database am I not including in my copy process?

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: Sandeep on May 10, 2016, 05:59:01 AM

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

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: DeveloperMcD on May 11, 2016, 03:59:54 AM

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..

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: Sandeep on May 11, 2016, 05:12:32 PM

server config ?

try to export with OS

Title: Re: Where is the LIST of MySQL databases stored on the hard drive?
Post by: Jae on May 12, 2016, 09:29:04 AM

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..