Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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,554
    Likes Received:
    9
    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. Seyed

    Creating Account Requires Apache Restart

    Seyed, May 14, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    77
    cPanelMichael
    May 14, 2018
  2. Mayc

    Hook is not activated when creating an account

    Mayc, Mar 7, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    119
    cPanelMichael
    Mar 7, 2018
  3. keryfan

    SOLVED Problem creating new account with custom ip

    keryfan, Mar 2, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    116
    keryfan
    Mar 3, 2018
  4. Sudhakar Reddy

    Problem creating email account

    Sudhakar Reddy, Dec 4, 2017, in forum: E-mail Discussion
    Replies:
    1
    Views:
    588
    cPanelMichael
    Dec 4, 2017
  5. jerry win

    Creating an email account error

    jerry win, Nov 20, 2017, in forum: E-mail Discussion
    Replies:
    2
    Views:
    1,024
    cPanelMichael
    Nov 21, 2017

Share This Page