Database Backup

[Cruisecar]

I have a huge MySQL Database, with many tables, and data within.

Currently I backup the Database by running a dump from phpMyAdmin. I need to know the php code needed to do so automaticly (I will program it so it does so every 12 hours). I've made my own script that can backup individual tables, but need a way of backing up the whole database in one go.

I cannot use any of the methods mentioned on this site [url=http://www.php-mysql-tutorial.com/perform-mysql-backup-php.php]http://www.php-mysql-tutorial.com/perform-mysql-backup-php.php[/url], due to security features on my host.

Any help would be appreciated,

Thankyou.

[Daniel0]

If you can do one table, then just do this: [code]$query = mysql_query("SHOW TABLES FROM db_name_here");
while($table = mysql_fetch_row($query))
{
$table = $table[0];
// do your stuff here
}[/code]

[Cruisecar]

You are a genious! That is exactly what is was looking for.

Thankyou.