Re: MySQL Backup, final script !!!
| From: | Nabil | Date: | Thu, 26 Jun 2003 12:42:55 +0000 |
| Subject: | Re: MySQL Backup, final script !!! | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28900@lists.php.net to get a copy of this message | ||
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" <armand@a-tu.net> wrote in message
news:3EFAE3FA.6070400@a-tu.net...
> 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
> >
> >
> >
> >
> >
>
>