Migration Problems

[RHarbison]

I'm having trouble migrating to a new server.

Here's what I've done so far.

1) Upgraded my existing forum to the most recent version of VB (3.8.2)

2) Did a fresh install of 3.8.2 on the new server, tested it, works fine.

3) Did a data dump from the old server using mysql.

4) Emptied the new database, and then imported the dump using mysql.

Note that the database name on the new server is not the same as it was on the old server, nor do I have the option to make it the same. (It appends a domain prefix)

When I tried to access VB, I got a database error.

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM vbdatastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','la nguagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','maxl oggedin','acpstats','mailqueue','pluginlistadmin');

MySQL Error : Table 'gardenfo_garforum.vbdatastore' doesn't exist
Error Number : 1146

What am I doing wrong?

[Steve Machol]

There is no table named 'vbdatastore' in the restored db. Did you check? Do you have the correct table prefix in config.php?

[RHarbison]

There is no table named 'vbdatastore' in the restored db. Did you check? Do you have the correct table prefix in config.php?

Well sure, I've got the prefix set to VB, just like it is on the other forum I run on this server... Oh, wait, maybe I'd better check and be sure I set them both up the same way? D'oh!

As usual, thanks for the quick reply (On a Sunday night, and a holiday no less!) and the right answer.

[Steve Machol]

No problem.