You have only to modify it to your environement It works with mysql >= 3.23.52
// Get all table names of the database
//
$sql = '
SHOW TABLES
FROM
test_db
; $db->query($sql);
while($row = $db->fetchRow( 'DB_GETMODE_NUM'))
{
$sql = '
BACKUP TABLE
'.$row[0].'
TO
"/db_backup"
'; $db->query($sql);
}
Armand
Nabil wrote:
I have been searching inside the mailing lists regarding the a PHP code that dump all or a selected databases from MySQL ... and haven't managed to get a script like PhpMyAdmin does... please any ready script or idea ...
<?php exec("mysqldump -u root -ppassword -A > backup.sql"); ?> //Because it didn't work with me (on windows by example).
All what I am thinking to do is a script that retrieved the database names then retrieve the tables names, then fields names and dump the data in an schema like mysqldump does....
any suggestions??
Cheers... Nabil
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
