Difficulties importing database

Lobsterkins · - Joined: 03 Oct 2003 Posts: 16

Hey all,

I've been running my server for ages now and all has been working well. However, tonight I finally correctly configured phpMyAdmin (prior to tonight I had PHP and MySQL both working great - in fact I was running a forum on my website http://www.altamontunion.com - however tonight I was instructed to uninstall/reinstall MySQL/phpMyAdmin to get phpMyAdmin to work).

So, with PHP, MySQL, and phpMyAdmin all working like a charm, I decided to go into phpMyAdmin and import my forum database, which I had backed up earlier this night. The forum I'm using is phpBB. Anywho, I'll create my database, then under the SQL tab I'll select my database .sql file and click "go". I'll wait and wait and wait, then it'll just give me "The page cannot be displayed - HTTP 500 Internal Server Error"!! The .sql file is only 805 kb. I honestly can't figure out what's going on... please help me if you can.

Thank you in advance. :)

olly86 · - Joined: 25 Apr 2003 Posts: 993 Location: Wiltshire, UK

If you backed the database up directly from phpBB then you can use the Restore Database option
_________________
Olly

iNaNimAtE · Posted: Sat Mar 27, 2004 7:59 pm Post subject:

And if you did a raw backup (copied all the files from the "data" directory) just turn off mySQL and replace them.
_________________
Bienvenidos!

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

I am the one who backed up this persons database , how
do I retore it using the .sql file that was downloaded , please
help my friend out , please reply as soon as possible. :(

olly86 · - Joined: 25 Apr 2003 Posts: 993 Location: Wiltshire, UK

under general admin

screen dump of phpBB 2.0.6 admin
_________________
Olly

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Lobsterkins problem has been solved , I checked the forum
and its now up and running , thank you so much for the tip.

Yet another successfull mission getting
phpMyAdmin working with MySQL. 8)

-------------------------------------------------------------------------------------

Having Problems with MySQL and phpMyAdmin ?
be sure to add me to your MSN Messenger and
I will help you and I will also fix your problem.

iNaNimAtE · Posted: Sun Mar 28, 2004 5:56 am Post subject:

You need to open a business (and start charging people!)... just kidding...

Anyway, I'll also help you if TRUSTPunk can't (or you like me better... hehe... :D Just Kidding TRUST).

Pitch an email over to iNaNimAtE<at>cfxnetworks.com
_________________
Bienvenidos!

Lobsterkins · - Joined: 03 Oct 2003 Posts: 16

The forum is indeed back up and running... however, I used the phpMyAdmin "SQL" feature this morning and, unlike the night before, it worked this time.

Weird. :wink:

TRUSTAbyss · - Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA

Well at least I got your phpMyAdmin and stuff working
I hope you like it so far , you will find many uses in
PHP Programming now , be sure to check out

Larry Ullman's PHP Programming
books at your local Barns & Noble

-------------------------------------------------------------------------------------

For the Making money part , im thinking about it !

iNaNimAtE · Posted: Sun Mar 28, 2004 7:13 pm Post subject:

And let me just make a suggestion: When you back up your phpBB database, check the "Gzip compress file." It has worked better for me when I do that; it might be the same for you.
_________________
Bienvenidos!