Re: [PHP] MySQL backup

2004-05-14 Thread Dynamix
Try http://freshmeat.net/projects/phpmysqlbackupro/ Regards, Hatem - Original Message - From: "Matthew Oatham" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 7:30 PM Subject: [PHP] MySQL backup Hi, I am using MySQL database accessed via myphp admin - there

Re: [PHP] MySQL backup

2004-05-13 Thread John W. Holmes
From: "Matthew Oatham" <[EMAIL PROTECTED]> > > > I am using MySQL database accessed via myphp admin - > > > there is an export option which allows me to export the structure > > > and data to an sql file but this is a manual procedure is there > > > anyway to automate this via myphp admin i.e. usin

Re: [PHP] MySQL backup

2004-05-13 Thread John Nichel
Matthew Oatham wrote: Mmmm my provider doesn't give me access to this area ! To what area? mysqldump, or cron? -- John C. Nichel KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] MySQL backup

2004-05-13 Thread John Nichel
Matthew Oatham wrote: Hi, I am using MySQL database accessed via myphp admin - there is an export option which allows me to export the structure and data to an sql file but this is a manual procedure is there anyway to automate this via myphp admin i.e. using a cron job? Thanks Use a cron and cal

Re: [PHP] MySQL backup

2004-05-13 Thread Matthew Oatham
Mmmm my provider doesn't give me access to this area ! - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "Matthew Oatham" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 6:40 PM Subject: Re: [PHP] MySQ

Re: [PHP] MySQL backup

2004-05-13 Thread John W. Holmes
From: "Matthew Oatham" <[EMAIL PROTECTED]> > I am using MySQL database accessed via myphp admin - > there is an export option which allows me to export the structure > and data to an sql file but this is a manual procedure is there > anyway to automate this via myphp admin i.e. using a cron job?

Re: [PHP] Mysql backup

2003-11-28 Thread Binay
Hi Rory, - Original Message - From: "Rory McKinley" <[EMAIL PROTECTED]> To: "Binay" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, November 28, 2003 7:30 PM Subject: Re: [PHP] Mysql backup > Binay > > If the tables for both vers

Re: [PHP] Mysql backup

2003-11-28 Thread Rory McKinley
Binay If the tables for both versions are MYISAM the steps are as follows: 1. Stop mysql on both systems. 2. Copy the contents of the 3.23.37 data folder to the 3.23.58 data folder using your OS tools (cp, file management tools, Windows explorer etc) 3. Start mysql on both systems. HTH Rory O

RE: [PHP] mysql backup solution

2003-06-06 Thread Luis Lebron
This is what I use http://members.lycos.co.uk/wipe_out/automysqlbackup/ -Original Message- From: John Kaspar [mailto:[EMAIL PROTECTED] Sent: Friday, April 25, 2003 3:48 PM To: [EMAIL PROTECTED] Subject: [PHP] mysql backup solution I've got a large mysql database (~400 megs) on a host tha

Re: [PHP] MySQL Backup and Restore

2002-07-24 Thread Martin Clifford
where that's the only access they provide. It's very much a pain in the butt... ---John Holmes... - Original Message - From: "Justin French" <[EMAIL PROTECTED]> To: "Peter" <[EMAIL PROTECTED]>; "kip" <[EMAIL PROTECTED]>; <[EMAIL PR

RE: [PHP] MySQL Backup and Restore

2002-07-24 Thread Andrew Chase
I encountered that same timeout problem once, and I wound up just installing my own copy of PhpMyAdmin in an .htaccess protected directory on the server, and extending the time limit there. It only took about 10 minutes to set up, and as an added bonus it was a more recent version of PhpMyAdmin t

Re: [PHP] MySQL Backup and Restore

2002-07-24 Thread 1LT John W. Holmes
utt... ---John Holmes... - Original Message - From: "Justin French" <[EMAIL PROTECTED]> To: "Peter" <[EMAIL PROTECTED]>; "kip" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 11:29 PM Subject: Re: [PHP] MySQL Backu

Re: [PHP] MySQL Backup and Restore

2002-07-23 Thread Justin French
Can highly recommend doing it (and a whole lot more) with phpMyAdmin (http://phpMyAdmin.net) Justin French on 24/07/02 1:04 PM, Peter ([EMAIL PROTECTED]) wrote: > grab ur self a copy of myphpadmin or use mysqldump or just simply make a > copy of the data dir or grab ur self a copy of mysql_

RE: [PHP] MySQL Backup and Restore

2002-07-23 Thread John Holmes
base and use this: mysql -uuser -ppassword database_name < filename.sql ---John Holmes... > -Original Message- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 11:04 PM > To: kip; [EMAIL PROTECTED] > Subject: RE: [PHP] MySQL Backup and Restore &

RE: [PHP] MySQL Backup and Restore

2002-07-23 Thread Peter
grab ur self a copy of myphpadmin or use mysqldump or just simply make a copy of the data dir or grab ur self a copy of mysql_front > -Original Message- > From: kip [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 24 July 2002 12:58 PM > To: [EMAIL PROTECTED] > Subject: [PHP] MySQL Backup a

Re: [PHP] mysql backup function in php?

2002-02-04 Thread Miles Thompson
Take that a little further and extract the code from phpMyAdmin for use in your own project. Miles At 08:36 AM 2/4/2002 -0800, Mike Maltese wrote: >Use PHPMyAdmin. You can dump to a CSV file or it can output all of the >INSERT statements to rebuild a table. > > >- Original Message - >Fro

Re: [PHP] mysql backup function in php?

2002-02-04 Thread Mike Maltese
Use PHPMyAdmin. You can dump to a CSV file or it can output all of the INSERT statements to rebuild a table. - Original Message - From: "Wilbert Enserink" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 8:22 AM Subject: [PHP] mysql backup function in php? >

Re: [PHP] mysql backup

2001-03-22 Thread Henrik Hansen
"McShen" <[EMAIL PROTECTED]> wrote: > hi > > how do i back up a mysql DB table? Can you please write me the code? i would just stop the database server and dump the table to a file with mysqldump, just run it from the command line for example: /path/to/mysqldump -h host -p password -u usern

RE: [PHP] mysql backup

2001-03-21 Thread Peter Houchin
-Original Message- From: McShen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 1:42 PM To: [EMAIL PROTECTED] Subject: [PHP] mysql backup hi how do i back up a mysql DB table? Can you please write me the code? Thanks. --__