Re: Script to export MySQL structure & data
| From: | Brent Baisley | Date: | Fri, 31 Jan 2003 22:00:46 +0000 |
| Subject: | Re: Script to export MySQL structure & data | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-133829@lists.php.net to get a copy of this message | ||
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