Re: [PHP-DB] MySQL backup software

2004-10-28 Thread Leo G. Divinagracia III
Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? mysql has the ADMINISTRATOR, well at least for win32... does timed backups. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] MySQL backup software

2004-10-27 Thread Luis Morales
Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? Hi Mathew, i made an litle script to do that. mysqlbk.pl Desc: This script made and mysql rotative backup fron sunday to sunday

RE: [PHP-DB] MySQL backup software

2004-10-27 Thread Norland, Martin
ch x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -Original Message- From: Perry, Matthew (Fire Marshal's Office) [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 8:58 AM To: [EMAIL PROT

Re: [PHP-DB] MySQL backup software

2004-10-27 Thread Jason Wong
On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office) wrote: > Does anyone know a free MySQL backup program to schedule regular backups? www.mysql.com google > mysql mailing list -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Inte

[PHP-DB] MySQL backup software

2004-10-27 Thread Perry, Matthew (Fire Marshal's Office)
Does anyone know a free MySQL backup program to schedule regular backups?

Re: [PHP-DB] MySql backup

2003-11-25 Thread John W. Holmes
Robin Kopetzky wrote: Question - if I stop MySql using WinMySqladmin on NT4.0, will I be able to completely backup the data directory or do I need to do something else? This is a commercial application that I need to backup, so it's mighty darned important. I don't think PHP can stop MySQL... oh..

[PHP-DB] MySql backup

2003-11-25 Thread Robin Kopetzky
Question - if I stop MySql using WinMySqladmin on NT4.0, will I be able to completely backup the data directory or do I need to do something else? This is a commercial application that I need to backup, so it's mighty darned important. Any help is appreciated. Robin 'Sparky' Kopetzky Black Mesa C

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Nabil
thnks, i will give it a shot "Armand Turpel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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 you

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Armand Turpel
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

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Nabil
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 : / query($sql); while ($row = $db -> fetchRow ('DB_GETMODE_NUM') ) { $sql = ' BACKUP TABLE '.$row[0].' TO "/db_back

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Armand Turpel
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')) {

[PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Nabil
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 ... backup.sql"); ?> //Because it didn't work with me (on windows by example).