Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Can't import a database

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
5 posts • Page 1 of 1
iltrapper
Posts: 4
Joined: Mon Jan 23, 2017 10:48 pm

Can't import a database
  • Quote

Post by iltrapper » Mon Jan 23, 2017 10:53 pm

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?
Top

mehargags
Support team
Posts: 1096
Joined: Sat Sep 06, 2014 9:58 pm
Contact:
Contact mehargags
Website Skype

Os: Debian 8x
Web: apache + nginx
Re: Can't import a database
  • Quote

Post by mehargags » Tue Jan 24, 2017 7:42 am

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

iltrapper
Posts: 4
Joined: Mon Jan 23, 2017 10:48 pm

Re: Can't import a database
  • Quote

Post by iltrapper » Tue Jan 24, 2017 9:58 am

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?
Top

mehargags
Support team
Posts: 1096
Joined: Sat Sep 06, 2014 9:58 pm
Contact:
Contact mehargags
Website Skype

Os: Debian 8x
Web: apache + nginx
Re: Can't import a database
  • Quote

Post by mehargags » Tue Jan 24, 2017 10:54 am

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
Top

iltrapper
Posts: 4
Joined: Mon Jan 23, 2017 10:48 pm

Re: Can't import a database
  • Quote

Post by iltrapper » Tue Jan 24, 2017 11:07 am

Yes, that's what I did.
I'll send you a screenshot of the PhpMyAdmin page. Thank you!
Top


Post Reply
  • Print view

5 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

cron

Login  •  Register

I forgot my password