Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Europe
    Posts
    54

    cpanel backup load question...

    I'm having problems with cpanel causing excessive load during backups. Sometimes the server even crashes. I am currently using FTP backups to a remote server, I am wondering if using incremental backups to a spare drive would solve this. Does the incremental backup use less load and backup mysql databases successfully?

    The problem maybe a >7gig mysql database, does anyone else have a database this size and a good method of backing it up without causing high loads?

  2. #2
    You should try to run OPTIOMIZE TABLE at first, but during this command running server will be not accessable.
    At the second I should recommend to install slave MySQL server on the another machine and configure mysql database replication.
    You need not backup anymore. It is the best solution for big mysql databases

Related Posts from theWHIR.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •