Re: mysql dump using php

Just use exec or backticks to call the mysqldump command mysqldump -uuser -ppassword database_name > file_to_dump_to.sql There are additional flags for structure/data only, etc. Then, use a header to redirect to the .sql file and send it to the user. One thing to watch out for is the 30 second time limit on PHP scripts... ---John Holmes... ----- Original Message ----- From: "Steve Buehler" <steve@vespro.com> To: "PHP" <php-general@lists.php.net>; "mysql" <mysql@lists.mysql.com> Sent: Monday, September 16, 2002 3:39 PM Subject: [PHP] mysql dump using php > PhpMyAdmin does a really nice dump of a database. Does anybody have a php > script that I can easily put into a php page so that I can have somebody > get the dump of the database without them using phpmyadmin. I would like > to be able to actually have two of these pages. One to give them the > structure, the other to give them the data. > > Thank You > Steve Buehler > > php mysql query > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > ow3 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >