I knew the mysqldump method. I'm using it frequently. My problem is that I'm writing this script for a client and I do not have shell access to his host. Or should I run mysqldump from PHP? I want a general solution which could be re-usable an all hosts wheter I can access mysqldump or not.
So, a script or ideeas from somebody who already did this would be really appreciated. Otherwise I have no other alternative than mining the phpMyAdmin sourcecode. Brent Baisley wrote:
I'm pretty sure you're looking in the wrong place. The command you are looking for is mysqldump and it is part of the mysql command set. With the right parameters it will create a file that can be used to restore your entire database to a working state.
I'm not sure how PHPAdmin does it. I use a shell script and cron to run the command nightly and then ftp the file to another machine. Cheap and easy backup.
On Friday, January 31, 2003, at 04:36 PM, Janos Rusiczki wrote:
I'm looking for a premade PHP script / class or a tutorial on how to export the structure and data of a few given MySQL tables as seen in phpMyAdmin.
-- Brent Baisley Systems Architect Landover Associates, Inc. Search & Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
