Restore Vbulletin backed up database

[Folken]

I would like to seek assistance on how to restore my Vbulletin database. The database was backed up using the control panel of Vbulletin on a different server.

I did search the forum and downloaded the mysql_utility.php script but i did recieve an error thus could not continue to restore function. I also did try to restore the database using myphpadmin panel but ended up in a cannot display page.

According to Vbullein restore procedure, it requires the user to have a telnet access to the server to backup/restore successfully. UNfortunately, powweb doesnt provide such service which leaves me in a odd position on how to restore my database.

Again, i would like to hear any suggestions on how to restore my vbulletin database.

For the mysql_utility, i recieved the following error:

MYSQL Backup and Restore utility
ERROR 1226 at line 73871: User 'amp3sforum' has exceeded the 'max_questions' resource (current value: 72000)
You had an error restoring your DB.

[HalfaBee]

You have to split your DB into less than 72000 line chunks.

Run this php script to split the file into 70000 line chunks
<? system( 'split -l70000 filename' ); ?>

You will then have X number of files with 70000 queries in each one.
These will be called xaa xab ... xa?

Run these sequentially using mysql_utility, one for each mysql user every hour.

xaa user1
xab user2
xac user3
wait until after the hour passes :00
and do the next 3

I restored a 27MB backup, it took 5 files.

I can see I am going to have to write a script to do this. :)

Good luck

[whzzz28]

Hello HalfaBee.

Just wondering, you wouldnt happen to have made a script for it yet by any chance?
I tried using the PHP script you posted
<? system( 'split -l70000 filename' ); ?>

But i get an error: Parse error: parse error, unexpected T_LNUMBER in \split\split.php on line 2

Now, im a complete noob to PHP so i wouldnt know what it means.

So you wouldnt happen to have a pre-made page you are willing to share :)

If not, any help regarding the error would be nice.

Thanks.

[HalfaBee]

I haven't finished the script yet, if you want to PM me some mysql and ftp info I will have a go at restoring it for you.

I can't see why that little script wouldn't work.
You have to change filename to your sql's filename, but it shouldn't cause a php error.

[whzzz28]

Yeah i did change the filename path to point to the sql file.
I will pm you now.

[Folken]

it seems it not working. i cant access the database in the forum

[HalfaBee]

Can you see the data in phpmyadmin?

Did you use the correct table prefix?

[Folken]

I dont know what tables ur referring to.

All i did was to install the bulletin board and installed the backedup database like you instructed using ur script. (whzzz28 did the restoring and i saw after he said it was all done that nothing can be seen)

[HalfaBee]

If you want to PM me some ftp and mysql usernames/passwords I may be able to get you going.

[Folken]

Sent you the details.

So do u think it is possible to restore the database?

[HalfaBee]

Check your PM's

[HalfaBee]

I split your db into 3 parts and restored them, hopefully it works now.

[Folken]

OMG! it really works! thnx!