php program to backup/restore mysql database?

I'm looking for a PHP program to backup and restore a mysql database.

I'm using Godaddy to host a forum. Their mysql control panel will only
restore a database of two megabytes or less. My database is over 13
megabytes in size.

re: php program to backup/restore mysql database?

On Wed, 01 Aug 2007 16:53:03 +0000, Bootstrap Bill wrote:
The MySQL client software includes mysqldump which will backup and restore
any MySQL database.

(Hope no one minds me answering a MySQL question in this group)

re: php program to backup/restore mysql database?

On Wed, 01 Aug 2007 19:11:07 +0200, Ivan Marsh <annoyed@you.nowwrote:
Well, he asks for a PHP-script, which is on-topic, you give a MySQL
answer, which is also valid (pointing out other things are better for some
purposes then PHP is) :P . Would the OP ask _how_ to use mysqldump it gets
offtopic...

I doubt Godaddy give him access to mysqldump BTW, so quite probably the
solution will be PHP.

I'm sure there are 'out of the box' scripts around which do what the OP
wants. Don't know them though.
--
Rik Wasmus

re: php program to backup/restore mysql database?

On Wed, 01 Aug 2007 19:25:51 +0200, Rik wrote:
I use a PHP script that runs mysqldump in the background.
I assumed Godaddy was a PHP script he was using for backup... I'm take it
that's a host service?
Could take a look at this:
http://www.fluffycat.com/SQL/MySQL-D...ckup-With-PHP/ (Assumes you
can write a file to the host system.)

re: php program to backup/restore mysql database?

On Aug 1, 9:53 am, "Bootstrap Bill" <ad...@NOSPAMfabsboards.com>
wrote:Pure PHP is not likely to help you. The reason you are having issues
is that the size of browser-based upload on your server is low (but if
it were higher, you could be facing timeout issues instead). So what
you need is a desktop database management program with HTTP tunneling
functionality. Here are a few links to products that have this
functionality:

http://www.webyog.com/en/sqlyog_tunneling.php
http://sqlmanager.net/products/mysql/manager/
http://www.navicat.com/feature.html

Each of these products includes a PHP script that you place on your
server. After you do that, you can manage your remote database from
your desktop.

Cheers,
NC