How to restore my phpbb database files?

**intelli** · 8 July, 2009, 08:16 AM

Hi there,

I have done this kinda things earlier when I changed my server to a new one.
Again, I'm in a similar situation. I tried to upload the backup file by entering phpmyadmin and then issuing the import command. But as always it returns some error. Ahh, I don't use import function for the same reason - earlier i used - some utility to restore - if i remember it correctly- it was a php file and i had to upload it to my server - I had to enter db details, destination sql file details etc in that php file - and things went fine that time - i was able to restore a big sql dump file. But I just don't remember that things name - also this time the file is just 3.5 mb in size ---- I have the file in my server - so i think there would be some way to store it to the right place from the server itself - i mean is there any need to download to my pc again ? anyways its in the server only - there is a need to just do some importing - actually its a .sql file - and some sql commands have to be run - thats all.

Anyone pls come up with some ideas....

**Shenron** · 8 July, 2009, 08:36 AM

This is what you're looking for:

BigDump: The Staggered MySQL Dump Importer

I wonder when the hell phpmyadmin will start handling imports properly...

**Charles** · 8 July, 2009, 08:44 AM

Originally Posted by Shenron

I wonder when the hell phpmyadmin will start handling imports properly...

I've never had any problems with doing so... It's all in how/where you export your database.

**intelli** · 8 July, 2009, 08:45 AM

Yup, that is what I was looking for.
Thanks Shenron. You deserve a "thanks"

**Shenron** · 8 July, 2009, 08:57 AM

Originally Posted by Charles

I've never had any problems with doing so... It's all in how/where you export your database.

Not quite Charles, I've had many problems in the past and I always try to properly export the database, also, even though phpmyadmin announces it can handle 50Mb files, I always find a hard time restoring files with more than 10Mb.

**Charles** · 8 July, 2009, 09:53 AM

Originally Posted by Shenron

Not quite Charles, I've had many problems in the past and I always try to properly export the database, also, even though phpmyadmin announces it can handle 50Mb files, I always find a hard time restoring files with more than 10Mb.

I managed to import a 150MB article database about half a year ago. Fluke?

**TopDogger** · 8 July, 2009, 17:34 PM

I have never had a problem moving large SQL files.

3.5mb is not very large. I wonder if you are running into the compatibility issue with different versions of MySQL.

Are you using an old version of MySQL on one of the servers? If remember correctly, some of the file parameters changed around version 4.1.

I once had a problem restoring an old SQL file and I had to manually change some of the parameters in the SQL file to get past the errors. The errors were coming from some of the MySQL parameters tagged on to the end of the CREATE TABLE command.