Re: [PHP-DB] MySQL backup software
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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL backup software
Does anyone know a free MySQL backup program to schedule regular backups?
Re: [PHP-DB] MySQL backup software
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 Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Sigh. I like to think it's just the Linux people who want to be on the leading edge so bad they walk right off the precipice. (Craig E. Groeschel) */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL backup software
You were on the right track with mysqldump. Windows doesn't have a direct cron equivalent - but it does have the ability to schedule tasks. Write a short batch file or equivalent (you should be able to whip one together in no time with a little googling) and schedule it to run. I doubt you'll find a tool that does exactly what you want that's any more advanced or configurable - there's just no need. That said - who knows, people make all kinds of software to fill what others perceive as unneeded. Cheers, - Martin Norland, Database / Web Developer, International Outreach 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 PROTECTED] Subject: [PHP-DB] MySQL backup software Does anyone know a free MySQL backup program to schedule regular backups? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySql backup
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 Computers/Internet Service Grants, NM 87020 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySql backup
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.. I see what you want... ;) Yes. Stopping MySQL will allow you to back up or copy the data directories. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL Backup, final script !!!
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
Re: [PHP-DB] 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] 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);
}
?
/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Backup, final script !!!
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 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);
}
?
/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
