php program to backup/restore mysql database?

[Bootstrap Bill]

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.

[Ivan Marsh]

On Wed, 01 Aug 2007 16:53:03 +0000, Bootstrap Bill wrote:

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.

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)

[Rik]

On Wed, 01 Aug 2007 19:11:07 +0200, Ivan Marsh <an*****@you.nowwrote:

On Wed, 01 Aug 2007 16:53:03 +0000, Bootstrap Bill wrote:

>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.

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)

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

[Ivan Marsh]

On Wed, 01 Aug 2007 19:25:51 +0200, Rik wrote:

On Wed, 01 Aug 2007 19:11:07 +0200, Ivan Marsh <an*****@you.nowwrote:

>On Wed, 01 Aug 2007 16:53:03 +0000, Bootstrap Bill wrote:

>>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.

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)

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 use a PHP script that runs mysqldump in the background.

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

I assumed Godaddy was a PHP script he was using for backup... I'm take it
that's a host service?

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

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.)

[NC]

On Aug 1, 9:53 am, "Bootstrap Bill" <[e-mail]>
wrote:

>
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.

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