Restoring mysql through phpmyadmin

[p0ng0]

Well, I appear to be getting there slowly. Having got my forums up with the mysql database I created I have tried to restore the old forums by way of the .sql text file backup.

I don not have SSH access to my host server so I copied and pasted the .sql file into the query window in phpmyadmin. All the queries were executed correctly and this pleased me greatly :)

However, what have the queries done? Well they appear to add tables to the database they were executed on. In this case that db is called username_gx . BEFORE the .sql file was run, the tables were laid down the left hand pane and were the usual collection of:

access
adminhelp
administrator
adminlog
adminmessage

AFTER the file was run, these were joined by another set of basically the same tables but prefixed by gx_ :

gx_access
gx_adminhelp
gx_administrator
gx_adminlog
gx_adminmessage

So.. I'm reasonably convinced that my old info is restored within the database, but vb admincp shows no sign of it :s

Can anyone advise as to how I should proceed? I'd really like the forums back as they were.

My fingers are crossed:confused: Thanks guys.

[RagnarokDensetsu]

Open your config.php file and change the Table Prefix to "gx_"

Then, once it's confirmed to work, delete all the tables without a prefix.

[p0ng0]

It's that simple? wow cool I'll have to try that, thanks very much :D

[p0ng0]

Database error!

The GamesXposed database has encountered a problem.

Please try the following:
Load the page again by clicking the Refresh (http://www.gxforever.com/#) button in your web browser.
Open the www.gxforever.com (http://www.gxforever.com/) home page, then try to open another page.
Click the Back (http://javascript%3Cb%3E%3C/b%3E:history.back%281%29) button to try another link.The www.gxforever.com (http://www.gxforever.com) forum technical staff have been notified of the error, though you may contact them (thisispongo@yahoo.co.uk) if the problem persists.
We apologise for any inconvenience.Thought it was too good to be true lol... I edited the config.php to add the table prefix gx_ . I didn't delete the other tables yet. Any ideas? Should I change the config back again before taking further action? :(

**EDIT I tried changing the prefix to 'gx' without the underscore - made no difference.....

DOUBLE EDIT - here's the error as output to email...


Database error in vBulletin :

Invalid SQL:

SELECT *
FROM gxdatastore
WHERE title IN
('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' userstats','birthdaycache','maxloggedin','iconcach e','eventcache','mailqueue');

MySQL Error : Table 'papatubb_gx.gxdatastore' doesn't exist
Error Number : 1146
Date : Monday, November 13th 2006 @ 03:30:44 AM
Script : http://www.gxforever.com/
Referrer :
IP Address : 81.130.192.30
Username :
Classname : vb_database

[p0ng0]

Looking further into this I am now deleting all the un-prefixed tables from the db and then I will remove the prefix from the imported tables and the config.php file.

No idea what else to do but I figure I can always start from scratch if this doesn't work :s

[RagnarokDensetsu]

If you haven't done so yet- make a backup of your database before you delete everything.

That sounds logical to me anyway, if it doesn't work you might want to try writing a support ticket.

[p0ng0]

New forum mate, there is nothing in the db I deleted.

I opened a ticket though and it has been suggested to me that I copy all the vb files to the server again, overwriting the files already there, and run the upgrade script. I've been asked to leave my restored tables in place for that procedure so I'm going to try that tonight and see what happens.

Once I get my forum restored I'll be happy - I'm quite familiar with acp... it's just this restoration that is killing me :s

Thanks for your help dude..