Page 1 of 1

Can't import a database

Posted: Mon Jan 23, 2017 10:53 pm
by iltrapper
Hi everybody, I'm quite new to all of this, but I'm trying hard to understand how to use this control panel to move my websites from shared hosting to a VPS.

I want to copy paste the mysql database of one of my wordpress sites, but I keep seeing this message:

#1007 - Can't create database 'admin_namedb'; database exists

I also see these messages on one of the pages.

Configuration of pmadb… not OK
General relation features Disabled
Create a database named 'phpmyadmin' and setup the phpMyAdmin configuration storage there.
Connection for controluser as defined in your configuration failed.


Could you please help me understand what's going on, and how could I solve this problem?

Re: Can't import a database

Posted: Tue Jan 24, 2017 7:42 am
by mehargags
you are not importing your Wordpress DB, instead you are importing a dump of phpmyadmin. May be on your previous host you have phpmyadmin installed individually for your site.

just get the Wordpress DB exported, you can find the DB name in your wp-config.php file.

Re: Can't import a database

Posted: Tue Jan 24, 2017 9:58 am
by iltrapper
Hi mehargags, and thank you.

I found the DB name on wp-config, but now where do I find the actual database?
What I tried to do yesterday was exporting the database using PhPMyAdmin from the old hosting, selecting all the tables. Should I do something different?
The version of PhPMyAdmin I have available in the old hosting is different from the one I find in the new one.

Another question: a dump is a full replica of the database and of the software phpmyadmin?

Re: Can't import a database

Posted: Tue Jan 24, 2017 10:54 am
by mehargags
in your PHPMyAdmin left panel, just "select" the DB name which is there on WP-Config and select "Export"
if you still can't figure out

send me PM of your PHPMyAdmin, I'll check for you

Re: Can't import a database

Posted: Tue Jan 24, 2017 11:07 am
by iltrapper
Yes, that's what I did.
I'll send you a screenshot of the PhpMyAdmin page. Thank you!