That's about right, But then again I saw mine compress within say 20 seconds for a 130 Meg DB.. I could have timed it wrong though. :D :)

Even better :)

Top Hack, Installed with no probs at all.

One question though, Can I rename or change one of the phps so that I can also run a backup once a week and ftp my database? I have the cron set to run at midnight at present and dont want to FTP everynight.

Thanks

XraY

If I were just you, I would turn FTP off, and wait till I create the AdminCP based control panel that will allow various things to be done individually by the administrator regarding the backup script.

Other then that, just change your cron to backup once a week.. OR 1 more thing you could do.

-------------------

create a copy of cronbackup so that you have:

cronbackup.php
cronbackup2.php

create a copy of mysqlbackupconfig so that you have

mysqlbackupconfig.php
mysqlbackupconfig2.php

change cronbackup2.php to include mysqlbackupconfig2.php instead of mysqlbackupconfig.php

change mysqlbackupconfig.php, and turn FTP off
make sure mysqlbackupconfig2.php has FTP on

add the crontask as such:

cronbackup.php is daily, it will not use ftp
cronbackup2.php is weekly, it will use ftp

-------------------

Hope I didnt make that all to be too complicated

Hi

Is there a way to encrypt the backup files so I can store my files safely on public servers knowing that no one can read them but me.

Or I could make a deal with someone to send me his backups and I send him min!

Thanks

Well this is not really a great idea, do to the problems with PHP and big files and the way block encyptions work.

1. I "Could" code in shell support for using ZIP's encryption, tar/gz and I believe bz also do not support encryption.

2. Use MCRYPT to encrpyt a backup archive into a solid mass of encryption, then it would be up to you to Decrypt using another PHP script or I could create one.

3. BEST Option. Set your backup directory to something, below your public_html directory, that way it can not be accessed via url by traditional means.

I have aproblem that I cannot solve..
I put the rights passwords and login name etc but it gives me the following message...

Invalid SQL: LOCK TABLES `access` READ, `adminhelp` READ, `administrator` READ, `adminlog` READ, `adminutil` READ, `announcement` READ, `attachment` READ, `attachmenttype` READ, `attachmentviews` READ, `avatar` READ, `bbcode` READ, `calendar` READ, `calendarcustomfield` READ, `calendarmoderator` READ, `calendarpermission` READ, `cpsession` READ, `cron` READ, `cronlog` READ, `customavatar` READ, `customprofilepic` READ, `datastore` READ, `deletionlog` READ, `editlog` READ, `event` READ, `faq` READ, `forum` READ, `forumpermission` READ, `gamechallenges` READ, `gamenews` READ, `games` READ, `gamesessions` READ, `holiday` READ, `icon` READ, `imagecategory` READ, `imagecategorypermission` READ, `language` READ, `mailqueue` READ, `moderation` READ, `moderator` READ, `moderatorlog` READ, `passwordhistory` READ, `phrase` READ, `phrasetype` READ, `pm` READ, `pmreceipt` READ, `pmtext` READ, `poll` READ, `pollvote` READ, `post` READ, `post_parsed` READ, `posthash` READ, `postindex` READ, `profilefield` READ, `ranks` READ, `regimage` READ, `reminder` READ, `reputation` READ, `reputationlevel` READ, `search` READ, `session` READ, `setting` READ, `settinggroup` READ, `smilie` READ, `stats` READ, `strikes` READ, `style` READ, `subscribeevent` READ, `subscribeforum` READ, `subscribethread` READ, `subscription` READ, `subscriptionlog` READ, `template` READ, `thread` READ, `threadrate` READ, `threadviews` READ, `upgradelog` READ, `user` READ, `useractivation` READ, `userban` READ, `userfield` READ, `usergroup` READ, `usergroupleader` READ, `usergrouprequest` READ, `usernote` READ, `userpromotion` READ, `usertextfield` READ, `usertitle` READ, `word` READ;
mysql error: Access denied for user: 'o0oo0X@localhost' to database 'o0oo0X'

How can i solve it?

Set

$backup['LOCK'] = 0;
$backup['LOCKTABLES'] = 0;

You most likely dont have the necessary permissions.

Also, make sure to read the configuration, there are lots of options to chose, and I have them explained; in detail.

Thanks 4 answering, I guess I wont backup the locked tables if I set them to 0 right?
So my backup won´t be complete..
Tell me if Iám wrong.

Is there any way to have it backup other databases as well?