Creating an account backup without the MySQL databases?

Kadence

Member
Nov 25, 2006
24
1
151
I'd like to transfer (backup and restore) a cPanel account and its home folder, but without the MySQL databases (the size of the DB is causing load to go crazy while trying to restore a full cpmove, so I'm trying to restore the DB separately).

Is there a way to backup an account (home folder, crons, etc.) from command line, without the backup including MySQL database(s)?
 

thewebhosting

Well-Known Member
May 9, 2008
1,199
1
68
You can download the full backup from the cPanel at the home directory. Once you complete the download extract the files and move all the folders except the mysql folder and also the mysql.sql file.
 

Kadence

Member
Nov 25, 2006
24
1
151
Thank you. Would this also cause MySQL user privileges creation to be deleted, or would that be preserved?
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
The "mysql.sql" file located in the full account backup contains the user privileges information; if that file is removed from the extracted backup contents then it could not be used during a restore.