thanks a lot for your response but i got

Fatal error: Call to a member function on a non-object in
c:\inetpub\wwwroot\dump.php on line 3
not that mysql is 3.23.53

my script is :
/////
<?php
$sql = 'SHOW TABLES FROM chat';
$db->query($sql);
while ($row  = $db -> fetchRow ('DB_GETMODE_NUM') )
{
$sql = ' BACKUP TABLE '.$row[0].' TO "/db_backup" ';
$db->query($sql);
}
?>
/////




"Armand Turpel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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
> >
> >
> >
> >
> >
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to