Posted by Ivan Marsh on 08/01/07 17:55

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

> On Wed, 01 Aug 2007 19:11:07 +0200, Ivan Marsh <annoyed@you.now> wrote:
>> 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-Database-Backup-With-PHP/ (Assumes you
can write a file to the host system.)

[Back to original message]