RE: [PHP-DB] Exporting database
| From: | John W. Holmes | Date: | Sun, 08 Dec 2002 17:09:06 +0000 |
| Subject: | RE: [PHP-DB] Exporting database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23904@lists.php.net to get a copy of this message | ||
> Can someone tell me where can I find a function or class
> for export MySQL database (structure & data ) into text file ?
From the system prompt:
path/to/mysql/bin/mysqldump -uuser -ppassword database_name >
filename.sql
will dump the entire database to an SQL file.
mysqldump --help
For more info. If you need to do this from within PHP, use an exec()
call.
---John Holmes...