We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Can't import a database
Can't import a database
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?
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?
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Can't import a database
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.
just get the Wordpress DB exported, you can find the DB name in your wp-config.php file.
Re: Can't import a database
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?
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?
-
- Support team
- Posts: 1096
- Joined: Sat Sep 06, 2014 9:58 pm
- Contact:
- Os: Debian 8x
- Web: apache + nginx
Re: Can't import a database
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
if you still can't figure out
send me PM of your PHPMyAdmin, I'll check for you
Re: Can't import a database
Yes, that's what I did.
I'll send you a screenshot of the PhpMyAdmin page. Thank you!
I'll send you a screenshot of the PhpMyAdmin page. Thank you!