DreamHost to cPanel - Specially e-mail data - HELP

quanin

Well-Known Member
Aug 18, 2011
127
7
68
cPanel Access Level
Root Administrator
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.
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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.
 

quanin

Well-Known Member
Aug 18, 2011
127
7
68
cPanel Access Level
Root Administrator
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.
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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.

:)
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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:

I have copied the mails from the zip backup which you have provided, Please have a check.

[[email protected] mail]# du -sch domain.com/
2.1G domain.com/
2.1G total
[[email protected] mail]# pwd
/home/user/mail

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!
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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 ?
 

quanin

Well-Known Member
Aug 18, 2011
127
7
68
cPanel Access Level
Root Administrator
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.
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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!
 

quanin

Well-Known Member
Aug 18, 2011
127
7
68
cPanel Access Level
Root Administrator
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.
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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.
 

ethical

Well-Known Member
Apr 7, 2009
97
8
58
Dragon

did you get the zip file directly from dreamhost or did you use the fetchmail program to get it?

Thanks

John


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.
 

DragonDF

Well-Known Member
Dec 16, 2012
45
0
6
cPanel Access Level
Reseller Owner
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!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,250
463
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.
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.