Help restoring phpbb2 database thats over 2mb

[eruditeoaf]

This must be a common question on this forum but I have spent hours searching for the solution not helped by phpbb.com being down.

I am trying to restore a PHPBB2 2.0.21 database onto a new location of PHPBB2 2.0.22.
I have the forum working now but im getting Error 500 - Internal server error when I try to restore the backup I made from the old forum.

The database as a text file is 5Mb and 0.5mb as a Gzip is this to big? Would a fast internet connection help? I'm on ADSL with 288kbps upload speed but have access to faster.

Any suggestions on the cleanest simplest way to import my old database from my forum into the new one?

Would opening a query window with the SQL database help if I knew what to enter?

Any help much appreciated.

[sanshay]

the problem is that you'r data not work correct on the new version of phpbb.
because the different tables and insert rows from the upgrade.

so what you have to do is reinstall the old version, 2.0.21 upload that database and see evrything works correct.
after that, you can upgrade to 2.0.22. and that just working fine.

if you'r data is to big for importing , You can split you'r tables in 3 or 4 files.
its easy to edit whit word/pad MFC or dreamweaver. or any ohter php editor.
and upload it trough phpMydadmin in administer of you'r OPC msql management. and import from there. or ad manuelly (copy and past) the tables whit the insert rows.
only do this if you know what you'r doing. !!! if not ask some support.

greetings

[Croc Hunter]

0.5Mb is not a problem. I don't think the tables changed between 2.0.21 and 2.0.22 but could be wrong. I figure you're trying to import from the phpBB admin panel? If you can login to phpmyadmin and try this:

To restore a database using http://www.powweb.com/utils/mysql_login.bml login and click the tiny litte "SQL" image you see top left. A pop-up window appears. Click the "Import Files" tab. Locate your backup file and away she goes.