In DIRE Need of Help, please!

Discussion in 'MySQL' started by GH Fever, Feb 12, 2009.

0
  1. #1
    Hey everyone,

    Okay this is kind of confusing to explain, but here it goes -

    I currently run a big brother forum via vBulletin and a MySQL Database. Due to the increase in members and posts, the forum started to get laggy. I called my host and they said I'd need to upgrade FROM shared hosting, TO a Virtual Dedicated Server.

    So. I did. I backed up the Wiki SQL, Wordpress SQL and vBulletin SQL. When I setup hosting through the VDS, I started with the restore on the Wordpress. That worked fine. Wiki was next, restored the SQL, that worked fine. The vBulletin finally, and we'd be all set! But of course, not.

    For some reason I get error after error when I try to upload a backup of the SQL Server for the vBulletin Forum, even though I'm doing the exact same thing I did for the other two. Can ANYONE think of any reason it would be doing this?!

    Thanks so much!

    - Danny
     
    GH Fever, Feb 12, 2009 IP
  2. GH Fever

    GH Fever Peon

    Messages:
    432
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Also, this is one of the errors I was receiving -

    ErrorSQL query: 
/*!40000 ALTER TABLE `attachment` ENABLE KEYS */;


MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE `attachmentpermission` (
  `attachmentpermissionid` int(10) uns' at line 4
    Code (markup):
    Now it's gone to this -

    SQL query: 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--
-- Database: `bbfans2`
--
CREATE DATABASE `bbfans2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


MySQL said: #1007 - Can't create database 'bbfans2'; database exists
    Code (markup):
     
    GH Fever, Feb 12, 2009 IP
  3. dman_2007

    dman_2007 Peon

    Messages:
    1,259
    Likes Received:
    62
    Best Answers:
    0
    Trophy Points:
    0
    #3
    The new error is because you you've already created the bbfans2 database while trying to restore the forum database. Can't say why you're getting first error message though, what tool did you use to dump your database?
     
    dman_2007, Feb 12, 2009 IP
  4. supportresort

    supportresort Member

    Messages:
    28
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    48
    #4
    Is the version of MySQL running on your VDS the same as was available for your shared hosting account?

    To remove the second error your options would be:

    * Drop the bbfans2 database and try to restore from scratch again;

    * Comment out the CREATE DATABASE line and attempt to restore the remainder of the database. One issue here however is that if a partial restoration has been completed then you can probably expect other errors to appear (e.g. failure due to a CREATE TABLE command when that table has already been created).
     
    supportresort, Feb 12, 2009 IP
  5. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #5
    It sounds like a version mismatch and possibly a collation mismatch as well. The other though with the first error, is that the actual dump file was in a non-standard encoding and some characters were read incorrectly trying to import it.

    I would dump the vbulletin database as "supportresort" suggested and try from the beginning. Also take a look at the line that contained the first error. There may be something obviously wrong with it.
     
    jestep, Feb 13, 2009 IP