mehnihma

Well-Known Member
Dec 15, 2012
57
1
8
cPanel Access Level
Root Administrator
Hi

I have one problem when trying to restore database with cpanel MySQL backup.
I create backup from CPanel and then I try to restore that backup with no success.

When I was on shared hosting this worked normally.

I choose database to restore and click restore. It uploads database and I get:
In first row:
The database (database) already exists!

After that it continues to execute queries and it stops in the middle of process and doing no changes. just like I have pressed stop in browser.


I have tried it million times and with different browsers and get same thing.

In phpmyadmin it works

Also where can I change upload size of database for phpmyadmin?

Can you help me with this?
 

mehnihma

Well-Known Member
Dec 15, 2012
57
1
8
cPanel Access Level
Root Administrator
When I try to restore through command line it works, but with cpanel it does not works.

I took same test database that I have downloaded from my cpanel and uploaded it to my shared hosting with cpanel and it is working normally.
Database size is around 5 MB.

Same database cannot be uploaded on my cpanel. It stops in the middle and that is it.
 

mehnihma

Well-Known Member
Dec 15, 2012
57
1
8
cPanel Access Level
Root Administrator
Whats the difference between the two items I've highlighted in bold?
Sorry about confusion.

I have server with Cpanel/WHm on which I have this problems.

On one shared hosting that I have and bought before from other hosting company year ago, and they have same version of Cpanel and there I can restore same database with no problems.

On my VPS I have this problem.

Hope this clarifies it.

Thanks
 

mehnihma

Well-Known Member
Dec 15, 2012
57
1
8
cPanel Access Level
Root Administrator
Yes and no.

I want to be able to restore like this through cpanel if possible :)

I both cases:

1. I create backup from my VPS with cpanel MySQL backup
2. I cannot restore that backup mysql to my VPS
3. When I got to other shared hosting and use same backup database and restore it with Cpanel mysql restore, it works.
4. I create backup from other shared hosting I try to restore it to my VPS Cpanel with mysql cpanel restore, not working
5. Same file form step 4 works on other shared hosting


With PHPMyAdmin and ssh it works on my VPS, only Cpanel troubles me

Thanks
 

Infopro

Well-Known Member
May 20, 2003
17,113
507
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter
Yes and no.
I was afraid of this. That was a yes/no question, not both.


If you have an actual account on one server and download a backup of a database, and you have an actual account on another server that you want to upload that database to, it should work. I think. Because its not, I think we're missing a small detail here somewhere.

If your Hosting Provider is of no assistance to you with this, I suggest you open a ticket to cPanel Technical Support. If you do, please post back the ticket ID here in this thread so that I can follow along with it please.

Thanks.