Page 1 of 2

HELP! i can't restore my forums database!!!!

Posted: Sun Mar 21, 2004 9:45 pm
by MHobbit
8O Yesterday my FTP Client crashed and deleted my phpBB 2.0.7 forums. Since I saw that the new version 2.0.7a came out, I just downloaded it, uploaded it onto my site, and installed it. Then, I went to the admin panel and tried to restore my old forums database (version 2.0.7). It did not work. Is it supposed to work? Or isn't it? Please help me.

Posted: Sun Mar 21, 2004 10:05 pm
by wuddk
Calm down mate ;)

How large is your backup? you have to split it up in 1MB pieces :)

Posted: Sun Mar 21, 2004 10:17 pm
by A_Jelly_Doughnut
wuddk wrote: you have to split it up in 1MB pieces :)
Tutorial: www.phpbb.com/kb/article.php?article_id=59

Posted: Sun Mar 21, 2004 10:26 pm
by MHobbit
wuddk wrote: Calm down mate ;)

How large is your backup? you have to split it up in 1MB pieces :)


Whew... ok, im calm now. :D Thanks. Oh yeah, is it ok if I restore a 2.0.7 database into a 2.0.7a forums?

my backup is 731KB, not too bad.

Posted: Sun Mar 21, 2004 10:28 pm
by wuddk
Couldn't better ;)

Posted: Sun Mar 21, 2004 10:31 pm
by A_Jelly_Doughnut
Since it is only 731K, what error do you get exactly?

Posted: Sun Mar 21, 2004 10:35 pm
by Seijin_Dinger
question, would just running the sql file with php My Admin work too?

Posted: Sun Mar 21, 2004 10:37 pm
by A_Jelly_Doughnut
Seijin_Dinger: Yes.

Posted: Sun Mar 21, 2004 11:30 pm
by MHobbit
A_Jelly_Doughnut wrote: Since it is only 731K, what error do you get exactly?


Well, it's practically an error... I restore it using the built-in function... but after a while, it goes to a blank white page, with "copyright phpBB 2004..." at the top, with nothing else there. I leave it at that page for 10 minutes, and it just stays there. So, I click on the Forum Index link from the Admin Panel, and is stayed the same as when I just installed it.
I'm going to get a screenshot of it now...
here it is (sorry if its a bit too big):
http://www.imageshack.us/img2/6834/screenshot.jpg


btw, how exactly would you just run the SQL file in myPHPadmin work?

Posted: Sun Mar 21, 2004 11:56 pm
by A_Jelly_Doughnut
MennoniteHobbit wrote: btw, how exactly would you just run the SQL file in myPHPadmin work?
Sometimes phpBB does that...never figured the reason out for myself :(

Anyway, www.phpbb.com/kb/article.php?article_id=59

Posted: Sun Mar 21, 2004 11:59 pm
by Seijin_Dinger
For the phpMyAdmin there is a Section called "SQL"

It has 2 Areas:

Run SQL query/queries on database AHS :
followed by a Text Area

and

Or Location of the textfile :
with an upload field

hit browse and find your backed up database (I dont compress so it for me would be a .sql file)
Select the file and then hit Go

how backing up works is it writes the contents of the PHPBB Database Tables into a SQL Query so that when you restore, it runs that Query automaticaly

This does the same thing but it just doesnt do it through the message board itself

Posted: Mon Mar 22, 2004 12:50 am
by MHobbit
I did that, and at first I thought everything was back, the name of the forums, the index, forums, everything. Then, I noticed that none of the registered users were there, I was the only one, all the smilies were gone, the posts claimed they were there, but i couldn't see it, and so on... I tried restoring it with the built-in function again, but same prob occurs: the white screen of blankness!!!!! :p hehehe

so, still i can't backup my forums. The posts are "still there" but are not visible...

p.s. I'm calm... :p but not for long :)

Posted: Mon Mar 22, 2004 2:32 am
by MHobbit
oh, i guess i have to use the support form template, sorry if you needed this before!

URL: http://members.lycos.co.uk/amnhobbit/phpBB2
Template(s) used: subSilver
Any and all MODs: none
Do you use a port of phpBB: what's a port?
Version of phpBB: 2.0.7a
Version of PHP: ~4.1
Which database server and version: MySQL 3.23
Host: Lycos UK
Did someone install this for you/who: I did, no one else
Is this an upgrade/from what to what: no upgrade
Is this a conversion/from what to what: no onversion
Have you searched for your problem: yes
If so, what terms did you try: restore database
State the nature of your problem: restoration of previous backupped database
Do you have a test account for us: no, but i can if you need one

Posted: Mon Mar 22, 2004 2:54 am
by drspy00
MennoniteHobbit wrote: I did that, and at first I thought everything was back, the name of the forums, the index, forums, everything. Then, I noticed that none of the registered users were there, I was the only one, all the smilies were gone, the posts claimed they were there, but i couldn't see it, and so on... I tried restoring it with the built-in function again, but same prob occurs: the white screen of blankness!!!!! :p hehehe

so, still i can't backup my forums. The posts are "still there" but are not visible...

p.s. I'm calm... :p but not for long :)


This happens to me every time I try and backup the database into a new forum also.

Posted: Mon Mar 22, 2004 5:16 am
by Seijin_Dinger
could you possibly only have backed up the structure and not the structure and data?