The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Creating an account backup without the MySQL databases?

Discussion in 'General Discussion' started by Kadence, Oct 17, 2009.

  1. Kadence

    Kadence Member

    Joined:
    Nov 25, 2006
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    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)?
     
    #1 Kadence, Oct 17, 2009
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    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.
     
    #2 thewebhosting, Oct 18, 2009
  3. Kadence

    Kadence Member

    Joined:
    Nov 25, 2006
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    151
    Thank you. Would this also cause MySQL user privileges creation to be deleted, or would that be preserved?
     
    #3 Kadence, Oct 19, 2009
  4. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,557
    Likes Received:
    8
    Trophy Points:
    168
    Location:
    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.
     
    #4 cPanelDon, Oct 19, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - Creating account backup
  1. Leslie de Groot

    SOLVED ERR_SSL_PROTOCOL_ERROR after creating new account

    Leslie de Groot, Jul 25, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    109
    Leslie de Groot
    Jul 27, 2017
  2. Havri

    Creating and terminating user account taking too long

    Havri, May 23, 2017, in forum: General Discussion
    Replies:
    8
    Views:
    267
    Havri
    May 30, 2017
  3. Walidos

    Adding new domain with WHM/Creating new cPanel account

    Walidos, May 15, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    4
    Views:
    326
    verdon
    May 15, 2017
  4. dvdmcswn

    Creating Email Accounts For Wordpress Multisite Mapped Domains

    dvdmcswn, May 9, 2017, in forum: E-mail Discussions
    Replies:
    6
    Views:
    198
    dvdmcswn
    May 9, 2017
  5. alansplash

    SOLVED Fatal Errors Creating New User Accounts

    alansplash, May 3, 2017, in forum: General Discussion
    Replies:
    8
    Views:
    302
    cPanelMichael
    May 5, 2017

Share This Page