Backups and restore WebServer's MySQL DBs.
You have an Ftp account for your files but what about you DB ?

PhpMyAdmin can export DB contents but this is a manual way to do. Moreover, Your DB are too big to be restored with phpMyAdmin in less than 30" (Server sql session for a querry). in fact querrys are almost long to run with this method. INSERT querries writes the full table contents in one querry (this is the problem). This explain the sql timeout can be reached at a volume limit.

We seached a solution to resolve followin points :
- Automatic and schedduled backups,
- Get record by record INSERTs,
- be able to import datas before sql timeout.

Backups

DB_Backup, THE script

DBBackup is a php script by wolf (wolf at restkultur dot ch) that just fit our skills to sheddule backups :
Quote:

Download
http://www.hotscripts.com/Detailed/27576.html

Installation and configuration
unzip .tar.gz file,
Copy def_config.inc.php into config.inc.php and open it.
Feed blank configuration vars (servers, DBs, Users, passes and all other parameters)
Upload db_backup on your web
In your navigator, test script :
http://your.domain.com/db_backup/db_backup.php

Automatisation

If you acces you server's cron jobs (ie in cPanel), you are able to scheddule a task to run the script periodically.

Details for this installation are avalable in INSTALL file.

Our Advice

Phenomenal ! This script is independant, it include all its ressources.
gzipped format, joined with mail support enable to regulary get on your desktop a copy of your DBs.
Generated SQLs uses record by record INSERTs. Then import timeout limit shouldn't be reached anymore. File is directly usable in phpMyAdmin (with gzip activated).
A Xoops independant script that should complete you web site setup.

Restore

BigDump, le script

This time, we thanks Alexey Ozerov (alexey at ozerov dot de) for this script that import big SQL dump files on hard limited sessions servers. Script Valid with IE 6.0 SP1, mozilla 1.x and Netscape 4.8.

Download

http://www.hotscripts.com/Detailed/20922.html

Installation and configuration

One unique script. Modify setup vars ( DB connextion and gzip file URL) and upload it on your server.

Use

This is a manual operation (We don't restore Dbs every days).
Post gziped sql Dump at devoted URL and run the script.

Our advice

Simple, ths script is the excellent DB_Backup complement. No moer sql files cut to fit phpMyAdmin sessions that a so boring (and dagerous) as your DBs bocomes too big.

Happy backups


Note :
This news is friendly provided by romu from
French Xoops Team : http://www.frxoops.org
Themes xoops team : http://www.xoops-themes.org and themes.xoops.org