A few questions about forums ...

[will7]

OK, I have a few questions about forums and am calling on the Namepros community

Now, previously, I had a small forum that people from school just used for a laugh and things. Now, recently, an admin got over powerful and deleted all the boards and stuff :lol: Luckily, I have a backup of the database before he did it but don't have a clue how to restore it - I don't think I can use the PHPBB restore function because the file is like, 6MB and you can't upload databases larger than 2MB (?) So, that's my first question.

Second question, are there any other free software programs that would allow me to restore all the users, posts etc from my old PHPBB forum using the SQL database I have backed up?

And, thirdly, if I paid for a forum system (IPB, vBulletin etc) would I be able to restore all the users, posts etc from my old PHPBB forum using the SQL database that I have backed up?

Thanks, really want to get this sorted, hehe, we had a laugh on the forums :lol: If you need any more information, then I'll do my best ...

Any help is appreciated,

Will.

 

[Host47]

Will first of all how was the backup made, was it a host backup or was it done through phpbb, if it was phpbb you'll have to restore it manually through phpmyadmin several tables ar a time depending on the size of the data, if your new host has shell access you can also restore it that way...I'll quite hapilly restore your phpbb database manually for some NP$...

As for your second question, my 1st answer pretty much answers it.

Thirdly if you go for IPB or vBulletin they come with convertors that will convert the phpbb data into whicever forums you go with, I have used both IPB and vbulletin from phpbb...

If I can help at all contact me on msn [email protected] the info helps m8.

 

[Jim_]

I'm going to assume that it is a standard SQL dump and that it is too big to import due to server restrictions on post size or execution time.

If you have ssh access, you could upload the sql dump and use this command:
mysql -u USER -p DBNAME < dump.sql

If you don't have ssh access, ask your host to run that command for you.

If neither of those options seems good, this might be of some help: http://drupal.org/node/43024

 

[will7]

Thanks guys, I love NP :lol:

ReaperUK - I've sent you a PM
Jim_ - Thanks for the tutorial, it may be useful ...

Any more help and advice is appreciated

 

[xtremeoff-road]

Well if you have a standard sql dump, then you can restore the db without any problems, however, you will need the same version of PHPBB uploaded to the server that you had previously. As mentioned, to restore your backup, you will need to SSH the following command:

mysql -u (username) -p (db name) < /loc/of/dump/file.sql

That will then restore the db.

Once that is completed, yes vBulletin does have a converter that will allow you to convert over to vBulletin. You will not need the PHPBB files, only the db restored.

Hope that helps, please feel free to let me know if you have further questions

 

[weblord]

also to add on it if your .sql file is bigger than the allowed file size, just login to ssh
and type this:
mysql --max_allowed_packet=6M
that is if you have never installed the bigdump from Jim_'s suggestion.

 

[khuldun]

well, when doing it the ssh way, what is the exact location of the dump file? does it have to be u0ploaded on the server or can it be picked from the PC?

 

[weblord]

well, when doing it the ssh way, what is the exact location of the dump file? does it have to be u0ploaded on the server or can it be picked from the PC?

upload it first to your server it depends on where you upload it, usually you cd to your home directory to where your domain is
cd /home/username/public_html/
that's fine upload via ftp and do a dump like what Jim_ said.

 

[Dudesy]

Heres the answer to question 3- Yes.