Re: Dumping Tables from MySQL
| From: | Chris Hayes | Date: | Tue, 14 Jan 2003 17:36:32 +0000 |
| Subject: | Re: Dumping Tables from MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-131588@lists.php.net to get a copy of this message | ||
At 17:50 14-1-03, you wrote:
I am having trouble writing a script to dump the data from tables in MYSQL.
Can anyone provide help on how to use the mysqldump command within PHP
(4.2).
Many thanks
Don
Have a look at my wonderful script :) to use mysqldump to get yourself an email attachment of a complete database dump.
It's a very helpful script, if you put it on debug mode it checks all sorts of things about mysqldump, like the accessability, it finds the path (on unix/linux) and it gives helpful comment.
All support text is inside the file. http://www.hieris.info/over/backup/backup.php.txt
Pick out what you need. I would like to get a copy of what you do with it.
In case it turns out you do not have access to mysqldump i have made a hack on PHPmyAdmin to make it email the database as an atachment at a mouseclick.
Chris Hayes