Migration questions

[markjohnson]

Hello everyone,

First of all, thanks to the Cpanel team for an excellent piece of software.

I am a new customer and currently running cpanel on a trial basis, at the end of which I intend to take out a license for a year.

Before that, I would like to know how to migrate accounts from a certain setup to Cpanel.

1) Cpanel backups, how do I migrate them to my Cpanel machine? For instance, I have a backup for a site in a filename 'daily.tar.gz'. When I uploaded it via the restore process, it uploaded the file and untar'ed it in /username directory of /home/username, but nothing at all in /public_html. How can I restore the files in /public_html? How can I extract the mysql database in that archive and restore that?

2) On another server I have the normal setup where all the files are located in /public_html and the databases could easily be dumped and then injected into Cpanel databases, via phpmyadmin. However, the emails are setup as /home/username/mail/ where mail directory contains all the folders, such as inbox, sent-mail, Drafts, samplefolder, etc, which is obviously different to the way Cpanel stores emails. Q: How can I migrate all the emails to Cpanel?

[cPanelDavidG]

Originally Posted by markjohnson

Hello everyone,

First of all, thanks to the Cpanel team for an excellent piece of software.

I am a new customer and currently running cpanel on a trial basis, at the end of which I intend to take out a license for a year.

Before that, I would like to know how to migrate accounts from a certain setup to Cpanel.

1) Cpanel backups, how do I migrate them to my Cpanel machine? For instance, I have a backup for a site in a filename 'daily.tar.gz'. When I uploaded it via the restore process, it uploaded the file and untar'ed it in /username directory of /home/username, but nothing at all in /public_html. How can I restore the files in /public_html? How can I extract the mysql database in that archive and restore that?

I recommend placing the Full Site Backup file in /home/ (not in a user's home directory) or /root/ then going to WHM -> Backups -> Restore a Full Backup/cpmove file. No need to create the user account, untar the file manually etc.

If you already have a user account based off the custom restoration procedures you described, I advise deleting that account if it is not in production use and attempting a restore using the method I described above.

Originally Posted by markjohnson

2) On another server I have the normal setup where all the files are located in /public_html and the databases could easily be dumped and then injected into Cpanel databases, via phpmyadmin. However, the emails are setup as /home/username/mail/ where mail directory contains all the folders, such as inbox, sent-mail, Drafts, samplefolder, etc, which is obviously different to the way Cpanel stores emails. Q: How can I migrate all the emails to Cpanel?

The mail messages, are they stored using the mbox format or the maildir format?

[markjohnson]

I recommend placing the Full Site Backup file in /home/ (not in a user's home directory) or /root/ then going to WHM -> Backups -> Restore a Full Backup/cpmove file. No need to create the user account, untar the file manually etc.

If you already have a user account based off the custom restoration procedures you described, I advise deleting that account if it is not in production use and attempting a restore using the method I described above.

I did just that. Before I clicked on 'restore', I noticed that it has detected daily.tar.gz under /home. It said:

Possible cpmove archives found:
(/home) daily.tar.gz

But when I run restore it says:

Searching /home....
checked 10 files.....
No Restorable archives found!

Searching /home2....
checked 0 files.....
No Restorable archives found!

Searching /home3....
checked 0 files.....
No Restorable archives found!

Searching /root....
checked 7 files.....
No Restorable archives found!

Searching /usr....
checked 18 files.....
No Restorable archives found!

Searching /usr/home....
checked 0 files.....
No Restorable archives found!

Searching /web....
checked 0 files.....
No Restorable archives found!



No archives where found for user tailor!!

tailor is the username I want to create.

The mail messages, are they stored using the mbox format or the maildir format?

mbox.

[cPanelDavidG]

Originally Posted by markjohnson

I did just that. Before I clicked on 'restore', I noticed that it has detected daily.tar.gz under /home. It said:



But when I run restore it says:



tailor is the username I want to create.

You may want to let our technical analysts take a look at that for you (see my signature)

Originally Posted by markjohnson

mbox.

If you convert the mail to maildir format, you could create the email accounts on the cPanel/WHM server then just copy the maildir files over.

[markjohnson]

Thanks, I have submitted a ticket.

If you convert the mail to maildir format, you could create the email accounts on the cPanel/WHM server then just copy the maildir files over.

How do I do that? By clicking on 'Mail Directory Conversion System'?

If so, I have to make sure that all the folders are located in /mail directory?

[markjohnson]

Another question I had:

Where does Cpanel store mysql dbs? in /home/username? Or elsewhere?

i.e. does the quote take into account DB size as well? or just the files?

[Zishan]

Originally Posted by markjohnson

Another question I had:

Where does Cpanel store mysql dbs? in /home/username? Or elsewhere?

i.e. does the quote take into account DB size as well? or just the files?

The databases are stored at the location where mysql stores the databases. cPanel doesn't store the databases elsewhere. Mostly the defautl mysql installation stores the databases at /var/lib/mysql.

Database size is not counted in the user disk space.

[markjohnson]

Right. Is there anyway of including mysql DBs within username allocated quota?

Some users have DBs as big as 300 MBs and over time they would become 600MB

[thewebhosting]

Originally Posted by markjohnson

Right. Is there anyway of including mysql DBs within username allocated quota?

Some users have DBs as big as 300 MBs and over time they would become 600MB

MySQL server has no support for preventing disk from getting filled up. You need to depend upon external configurations. Please refer http://www.cyberciti.biz/tips/linux-...se-quotas.html

[cPanelDavidG]

Originally Posted by markjohnson

Thanks, I have submitted a ticket.



How do I do that? By clicking on 'Mail Directory Conversion System'?

If so, I have to make sure that all the folders are located in /mail directory?

There's a utility called mb2md that you can find in an internet search to do this on your existing server. The utility included in cPanel/WHM is primarily geared for very old cPanel/WHM systems that may still be on the mbox format from years ago.