Backup system: I'm sick of this help
 

Guys My forum post database is freezes every 15 20 days. Optimize - repair database do their job but suddenly some day it stops and I have to use the backup to bring everything back. I'm looking for a backup software for centos 4.6. with cpanel. Cpanel has a backup system but
I would like to take a backup at 6:00am. cpanel doesn't have the timing any ideas... I'm tallking about 2gb database 100000 users 1.1 gb post database thanks..

instead of paying for a software, i would suggest to evaluate a new host with a better service...

Him dedicated server own by me.. There is no host..I don't want to pay for software. I just don't know linux. There should be a way to backup we just don't know..

We had a single dedicated server for years, with a database that is over 4 gigs in size (2.5 gig post table), and there was never any problem. If you're having problems, I suggest that it isa processor/memory issue which should be rectified. Ensure that your dedicated server has at least 2 Gigs of RAM, preferrably 4 Gigs; look into making sure that your processor is multi-core or dual-unit. Such a configuration can comfortably hold up to 1500 concurrent users, provided your MySQL is configured properly, without any serious risk of error.

You should also ensure that your PHP, MySQL, and Apache versions are up to date. Unfortunately, if you're not an experienced Linux administrator, these can be daunting tasks. Get a Linux administrator - even if it's just on a per-instance, or per-contract basis - to upgrade your OS, Apache, PHP, and MySQL. These can all serve as bottle-necks and error-producers.

Eventually, there will come a time when no matter how much you optimize your system, you will need to expand to have multiple servers to handle a single forum. Usually, a 2-forum system supports up to 3,000 concurrent connections fairly comfortably, but it all depends on the server architecture and configuration. Many admins prefer having 3-4 servers on any forum that has more than 2,000 concurrent connections at peak, and understandably, because at that point, the principal load is no longer on MySQL, but on httpd.

kaelon. you said 2-3 servers. how this think works example: I would like to setup a mysql server to my home with cable internet. Why: Can I have double copy of my database like this ??
I don't care it can run from the main server what i care is i have the same database in my house server so I can fix it up easily and install back to server...and backup 4 times a day :)

How this 2-3 server thing works can you give me overview please thank you for your smart comments.