Backup & restore MySQL, not using mysqldump

[Jerry T]

How can I backup and restore a MySQL DB WITHOUT USING

EXEC()
MYSQL
MYSQLDUMP

??

If I try running exec() and mysqldump, I get Fork warning errors ..

Win 2000Server
IIS5
Latest PHP & MySQL

Thanks

[Nikolai Chuvakhin]

Jerry T <Jerry@ nothanks.com> wrote in message
news:<rdshjvclp5nviod94hgpev9il8e93nutaf@4ax.com>. ..

>
> How can I backup and restore a MySQL DB WITHOUT USING
>
> EXEC()
> MYSQL
> MYSQLDUMP

Read up on BACKUP and RESTORE queries:

[url]http://www.mysql.com/doc/en/BACKUP_TABLE.html[/url]
[url]http://www.mysql.com/doc/en/RESTORE_TABLE.html[/url]

Cheers,
NC

[Mike]

One big pain in some cases is trying to restore a MySQL dump on a server where you don't have shell access and don't have phpMyAdmin installed. The easiest way I found to handle this was using PHP. Check out the following article on how to restore a MySQL dump file using PHP:

[url]http://www.swhistlesoft.com/blog/33-restoring-mysql-dump-with-php[/url]