Re: MySQL Backup, final script !!!

I use an db abstraction class. You have to replace this by yours. Of course you got a "Fatal error: Call to a member function on a non-object" because such an object dosen't exist in your script. First you have to connect to a database using mysql_connect() and using mysql_query and mysql_fetch_row. Armand Nabil wrote:

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); } ?> /////