restoring database in phpbb3 - please help

[Cojba]

Well, I have a backup file from 19.01. and I'm trying to restore the forum.

But when I try to do that, after about 10s I'm getting this error in browser:

The website encountered an error while retrieving

http://onelinkwarez.info/adm/inde.....

It may be down for maintenance or configured incorrectly.

The file is in sql.gz format, and is 35.4MB big. Is it maybe problem in kloxo ? cuz my ftp is not working currently, so I can't unzip it(kloxo doesn't unzip big files)

It retrieve users and the first category(without content, just name), after that give me error.

Can someone help ?

Cojba Reviewed by Cojba on 26th Jan 2011. restoring database in phpbb3 - please help Well, I have a backup file from 19.01. and I'm trying to restore the forum. But when I try to do that, after about 10s I'm getting this error in browser: The website encountered an error while retrieving http://onelinkwarez.info/adm/inde..... It may be down for maintenance or configured incorrectly. The file is in sql.gz format, and is 35.4MB big. Is it maybe problem in kloxo ? :S cuz my ftp is not working currently, so I can't unzip it(kloxo doesn't unzip big files) It retrieve Rating: 5

[deAthbLisS]

use ssh to dump your database to mysql.
or use mysqldumper to dump the sql.

[Cojba]

can that be done with phpmyadmin ?

phpmyadmin : (Max: 8,192 KiB)

and I can't access to my server with putty...

[Cojba]

tnx deathbliss very much! mysqldumper helped a lot! But now I have another problem, can someone help ? I've restored the database, but I can't see posts..

I can see, forums, subforums, description, members and permissions are also back, if you take a look, you can also see number of topics, for example

Movies
Watch and share your favorite movies. 6962 but I can't see posts



and also:
Cojba
Total posts:1 | Search user’s posts
(0.00% of all posts / 1.00 posts per day) Most active forum:XxX Videos
(4435 Posts / 443500.00% of your posts). Why this missleading ?

[Lock Down]

Using programs like mysqldumper are great but they will quit on large files. SO you have to restart them from where they quit.

TRy restoring the posts only using mysqldumper. Or you can edit the backup file and copy and save the posts only part to try and restore by itself.

It is much better to use the mysql from the ssh login. SImple and never fails.

[Cojba]

fixed fixed fixed..... ) tryed about 4-5 times, until I finally succeed. thread can be closed now...