Restoring MySQL database

Geoff Bryant · 12-27-04, 11:26 PM

Further to the message I posted earlier about being unable to upload images, I have now lost my caption and category information database, though the image files already uploaded are still intact.

I have an up-to-date backup but I cannot get it to restore properly from the MySQL admin or by using the recently posted retore utility. The process simply times out. Admittedly it's a fairly large file, (8MB) but should that be a problem?

Once again I've already posted to the helpdesk and with luck the restoration can be done by Powweb, though so far no reply.

Any helpful suggestions would be appreciated as this is tunring into a first-rate disaster. I don't relish the thought of manually reloading 4700 image captions.

devinemke · 12-29-04, 10:31 AM

your database schema is too large to import all in one chunk. you have 2 choices:

1. split your schema into smaller chunk and restore in pieces

2. use your own php.ini to overide the default powweb php.ini limits. specifically:
max_execution_time
max_input_time
post_max_size
upload_max_filesize
mysql.connect_timeout

option #2 is easier. you can read about custom php.ini here:
http://support.powweb.com/index.php?...QL&topic_id=57

Arun · 12-31-04, 09:41 AM

One easiest option still exists with phpMyAdmin.... but don't know if it is enabled in the POWWEB phpMyAdmin installation......

The mentioned option actually let you upload your sql files thru FTP to a particular directrory on your server then execute it with your phpMyAdmin ......

devinemke ,
Do u have a clue if it can be enabled here in POWWEB. I suppose it is not present currently.

12-27-04, 11:26 PM	#1
Geoff Bryant Join Date: Aug 2004 Location: Christchurch, New Zealand Posts: 173 Reputation: 42	Restoring MySQL database Further to the message I posted earlier about being unable to upload images, I have now lost my caption and category information database, though the image files already uploaded are still intact. I have an up-to-date backup but I cannot get it to restore properly from the MySQL admin or by using the recently posted retore utility. The process simply times out. Admittedly it's a fairly large file, (8MB) but should that be a problem? Once again I've already posted to the helpdesk and with luck the restoration can be done by Powweb, though so far no reply. Any helpful suggestions would be appreciated as this is tunring into a first-rate disaster. I don't relish the thought of manually reloading 4700 image captions.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

12-29-04, 10:31 AM	#2
devinemke broken tv Join Date: Dec 2001 Location: NYC Posts: 268 Reputation: 13	your database schema is too large to import all in one chunk. you have 2 choices: 1. split your schema into smaller chunk and restore in pieces 2. use your own php.ini to overide the default powweb php.ini limits. specifically: max_execution_time max_input_time post_max_size upload_max_filesize mysql.connect_timeout option #2 is easier. you can read about custom php.ini here: http://support.powweb.com/index.php?...QL&topic_id=57

12-31-04, 09:41 AM	#3
Arun Join Date: Nov 2004 Location: Kerala, India Posts: 208 Reputation: 9	One easiest option still exists with phpMyAdmin.... but don't know if it is enabled in the POWWEB phpMyAdmin installation...... The mentioned option actually let you upload your sql files thru FTP to a particular directrory on your server then execute it with your phpMyAdmin ...... devinemke , Do u have a clue if it can be enabled here in POWWEB. I suppose it is not present currently.