MySQL DB Error

[X-Sector]

My forum being hacked, I have a MySQL Database back up and l did restored it via cpanel..

Everything got backed up but when l view my forum.. i got this error :

There seems to have been a slight problem with the Xelation Forums database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

[assassingod]

View the source of that page to see the error. It's very unlikely it is being hacked.

[X-Sector]

It said :

mysql error: Table 'x-sector_vbforums.session' doesn't exist

mysql error number: 1146

Date: Sunday 15th of February 2004 09:19:01 PM
Script: http://www.x-sector.net/forums/
Referer:
IP Address: **.***.***
-->

[assassingod]

Have you done anything recently that may have caused this? It seems your session table has bee deleted.

[AN-net]

i would assume your missing your session table>_>see if its there and has the the prefix "x-sector_vbforums" in front of it

[X-Sector]

hm..

I didn't not deleted it, I just backed it up.. thats al..

[assassingod]

Do you use a table prefix?

[X-Sector]

what do you mean by that?

[assassingod]

There's an option in config.php to use a table prefix, so basically tables in the database such as user and session will have a prefix on them. If you do use one, maybe that might be causing the error.

What else did you do?

[X-Sector]

I looked at my phpmyadmin.. there is no session/user tables in the database..

Awhile ago.. before my forum hacked, I just backed up my forum.. and now.. when my forum got hacked and l tried to restored it.. it has an error.

Hmm.. how do l fix the errors using by table prefix ?

[assassingod]

I looked at my phpmyadmin.. there is no session/user tables in the database..

Awhile ago.. before my forum hacked, I just backed up my forum.. and now.. when my forum got hacked and l tried to restored it.. it has an error.

Hmm.. how do l fix the errors using by table prefix ?
Table prefixes wont help out, I was just wondering since that could cause the problem. Reupload your backup

[X-Sector]

I did reuploaded the back up a lots of times, still got the same error..

[AN-net]

hmmm.... if you have an sql file of your vb db you could manually insert the tables back in with an sql query.

[X-Sector]

Do you mean.. copy the session/user tables and run them in the phpmyadmin ?

[AN-net]

well if you had a .sql file of your db it would contain all the tables and their seperate datas in sql queries, so bascially all you do is copy and paste the sql query for your user and session tables and run them in phpmyadmin's query window;)

[X-Sector]

Thanks for the help..

How did it happened? why did there is no session/user tables ... in the database? just wondering.

[AN-net]

hmm not sure, probably since it was a backup done by cpanel while it was reuploading it skipped over it or it was never backed up in the first place or an error occured when reinserting those tables and it just continued on reuploading , not inserting those 2 tables. i would also go over to vbulletin.com and find the full list of tables your susposed to have(wana make sure your not missing any others)

[X-Sector]

Is there any other way to back up the MySQL database execpt via cpanel?

[AN-net]

yes, via admincp in vbulletin. import & maintenance->backup database
;)

[X-Sector]

Cool, thanks!

[X-Sector]

Oh.. I did what AN-Net said, but i cant restore the database via cpanel cuz the database is too big..

how do l restore the database without the cpanel. thnx

[Andreas]

Do you have shell access?

If so: Upload the file, mysql -uusername -ppassword database < sqlfile.sql

[X-Sector]

Whats shell access? and how to use it?

[Andreas]

You don't have shell access - if you had it you would know for sure.
Sorry, seems you're out of luck.
You could only ask your webhost to give you shell access

[X-Sector]

I dunno, where do you use it? or is it like what a telnet did?

[Andreas]

You can access a shell through telnet, although it is very insecure.
I'd rather use SSH2 if possible.

[X-Sector]

how do you use it? and how do you get it connect to your server.