By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,567 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,567 IT Pros & Developers. It's quick & easy.

php program to backup/restore mysql database?

P: n/a
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.

Aug 1 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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)
Aug 1 '07 #2

P: n/a
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
Aug 1 '07 #3

P: n/a
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.)
Aug 1 '07 #4

P: n/a
NC
On Aug 1, 9:53 am, "Bootstrap Bill" <ad...@NOSPAMfabsboards.com>
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

Aug 1 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.