Re: MySQL Backup, final script !!!

Hi, 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