Ah, okay, here's your issue. You don't actually have permission to create the database as non-root user through PHPMyAdmin. Create your DB in CPanel, then select that DB in PHPMyAdmin. It should let you import into that DB. If and only if that doesn't work, there's a command line way to do it. The server admin most likely did it via the command line, because WHM won't even let him use PHPMyAdmin as root to do it.
About the creation of the DATABASE: yes, I knew. For this I created them and ADD the user I created there, too.
Maybe the problem is in "select the DB in PhpMyAdmin.
Let me try.
Maybe the problem is in "select the DB in PhpMyAdmin.
Let me try.
If that doesn't work, then you may need to remove the create statement from the SQL file. DH is assuming, stupidly, that you want a DB with exactly the same name on your new host. Which is awesome, except DH is the only one who uses that naming structure unless you run your own server. Note: that's a new trick, if that's the case, as I didn't have that issue when I did it.
If it still fails to work, give me a bit and I'll do up a quick migration script that should work to transfer the database. Note, however, that if I do up this script, you'll need shell access to the CPanel server. You may or may not also need to tell DH it's alright to let the CPanel server's IP access your database.
If it still fails to work, give me a bit and I'll do up a quick migration script that should work to transfer the database. Note, however, that if I do up this script, you'll need shell access to the CPanel server. You may or may not also need to tell DH it's alright to let the CPanel server's IP access your database.
Yes, I open the SQL file and 'comment' where there was something with CREATE DATABASE.
After this, things worked fine.
---------
After this, I needed to go to the wp-config.php file and changed the mysql.domain.... to localhost and the user and pass for this new server (cpanel).
---------
NOW, A NEW PROBLEM: move the email data from DreamHost to Cpanel.
I will take a try in that software you post some posts ago.
Thank you for your help. Very helpfull.
After this, things worked fine.
---------
After this, I needed to go to the wp-config.php file and changed the mysql.domain.... to localhost and the user and pass for this new server (cpanel).
---------
NOW, A NEW PROBLEM: move the email data from DreamHost to Cpanel.
I will take a try in that software you post some posts ago.
Thank you for your help. Very helpfull.
I got a EMAIL DATA (something as: contact_domain_com.zip) and upload to the server (inside a specific directory).
After that I asked the support team to unzip and insert in the correct place.
I received his message after his work:
My doubt is:
HOW CAN I DO IT BY MYSELF?
Because DreamHost and Cpanel use Squirrel Mail.
And it looks like the support only UNZIP the file in a specific folder (mail). Sure, as a root member. But I don't know if there is any diference.
Tks!
After that I asked the support team to unzip and insert in the correct place.
I received his message after his work:
My doubt is:
HOW CAN I DO IT BY MYSELF?
Because DreamHost and Cpanel use Squirrel Mail.
And it looks like the support only UNZIP the file in a specific folder (mail). Sure, as a root member. But I don't know if there is any diference.
Tks!
Another "new" problem:
Problems:
1. DATABASE (new domain)
I have just tried to upload the DATABASE data by myself.
I got this error message inside PHPMYADMIN:
"Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 334257105 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/zip_extension.lib.php on line 60"
The compressed database has 32Mb.
The problem now is not because I am trying to CREATE a new database, but about the SIZE of the database. A setup inside the server.
Can I adjust it using WHM ?
Problems:
1. DATABASE (new domain)
I have just tried to upload the DATABASE data by myself.
I got this error message inside PHPMYADMIN:
"Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 334257105 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/zip_extension.lib.php on line 60"
The compressed database has 32Mb.
The problem now is not because I am trying to CREATE a new database, but about the SIZE of the database. A setup inside the server.
Can I adjust it using WHM ?
With regards the first question, you *can* do it, yes. However exactly how you'd do it depends entirely on how many email addresses you have at that domain name. I say that, because CPanel and DreamHost use different directory structures when actually storing your mail. Squirrelmail has nothing to do with how each provider stores your email. As long as it can still access and show you your email, that's all it cares about.
With regards your second question, that's a problem ionside WHM itself that you may or may not be able to fix, depending on your reseller priveleges. You need to increase the max memory limit asigned to CPanel's internal PHP. That may be something you need the server admin to do for you.
With regards your second question, that's a problem ionside WHM itself that you may or may not be able to fix, depending on your reseller priveleges. You need to increase the max memory limit asigned to CPanel's internal PHP. That may be something you need the server admin to do for you.
Hello quanin!
Tks for the reply.
About first question: I think it is easy because you can read the command line he used.
about second (WHM): I could not see any option in my WHM panel.
By the way... after 10 hours I opened a ticket... no reply from support.
Tks!
Tks for the reply.
About first question: I think it is easy because you can read the command line he used.
about second (WHM): I could not see any option in my WHM panel.
By the way... after 10 hours I opened a ticket... no reply from support.
Tks!
First, the only command he used that was pasted here was to check how much diskspace your mail directory was taking. Not what he actually did to copy the mail. As for the second problem, then that's something your server admin will need to do. So yes, support ticket was the right call. Sorry.
EMAIL
I could move it.
I got the .ZIP file from DreamHost ([email protected] com.zip - for example), unzip it and MOVE to the MAIL directory of Cpanel.
It was very easy.
EMAIL problem was solved direct by me.
---
DATABASE migration:
I could not do it.
I needed to upload the zip file for a specific directory and ask support to upgrade it to me.
---
Thank you quanin for all your support.
I could move it.
I got the .ZIP file from DreamHost ([email protected] com.zip - for example), unzip it and MOVE to the MAIL directory of Cpanel.
It was very easy.
EMAIL problem was solved direct by me.
---
DATABASE migration:
I could not do it.
I needed to upload the zip file for a specific directory and ask support to upgrade it to me.
---
Thank you quanin for all your support.
Dragon
did you get the zip file directly from dreamhost or did you use the fetchmail program to get it?
Thanks
John
did you get the zip file directly from dreamhost or did you use the fetchmail program to get it?
Thanks
John
Hello John (@ethical) and others!
I will not open a new thread if I am having the same problem.
First: John, I did not see your last message, for this I did not reply it.
As I used Cpanel in last 12 months and I had a problem with my last provider and lost the email data, I'd like to insert in my actual (new) email data the last one I have.
The doubt is:
The Old backup email data is from Dreamhost (that did not use Cpanel).
Is there a way I can upload the files not as a BACKUP but in a way to be ADDED to my last email data?
Or another way I can ADD my actual (small) email data to the OLD one and then upload it all to each email account.
Thank you!
I will not open a new thread if I am having the same problem.
First: John, I did not see your last message, for this I did not reply it.
As I used Cpanel in last 12 months and I had a problem with my last provider and lost the email data, I'd like to insert in my actual (new) email data the last one I have.
The doubt is:
The Old backup email data is from Dreamhost (that did not use Cpanel).
Is there a way I can upload the files not as a BACKUP but in a way to be ADDED to my last email data?
Or another way I can ADD my actual (small) email data to the OLD one and then upload it all to each email account.
Thank you!
Which control panel was used at your previous host? Was the MailDir format used for emails? If so, the following guide should be helpful in understanding the locations where email data is stored in a cPanel server:
cPanel - Manual Migrations From Unsupported Control Panels
Thank you.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
| A | Best way to migrate dovecot emails to cpanel | Transfers | 1 | |
| M | Transfer cPanel account from one WHM to other | Transfers | 11 | |
| M | Restore Cpanel Backup From Other Server Using SSH | Transfers | 1 | |
| S | Plesk refuse access to cPanel transfer tool | Transfers | 6 | |
| G | Dreamhost to cPanel -- Databases... | Transfers | 5 |