Ok, I have restored the database, but when I try to make a post or change something on my vbulletin, I get this errror:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO rsforumpost
    (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
    (1, 1, 'taelmx', 1, '', 'What.....this isn\'t the right thread....I swear this is a database problem.', 0, 1, 1485, 128, 1158646509, '75.5.41.167', 0);

MySQL Error  : Duplicate entry '0' for key 1
Error Number : 1062
Date         : Monday, September 18th 2006 @ 11:15:09 PM
Script       : http://www.rs-anime.com/forum/newreply.php
Referrer     : http://www.rs-anime.com/forum/showthread.php?t=128
IP Address   : 75.5.41.167
Username     : taelmx
Classname    : vb_database

Database error in Subdreamer

Invalid SQL: INSERT INTO rs_main_p7_chatterbox (categoryid, username, comment)
                VALUES (1, 'taelmx', 'Well, its not very reliable.') 
Error: Duplicate entry '0' for key 1 
Error number: 1062 
Date: Tuesday 19th of September 2006 06:06:39 AM
File: http://www.rs-anime.com/index.php

Perhaps the index (or key) has been changed from the original or intended one. What fields are in "key 1"? If there is a unique index (or key) with one field like userid, or another combination of fields that is not guaranteed to be unique, that might cause you to see what you are seeing.

Well, I think what you are saying is right, but do you know how the change it to the right one?

phpmyadmin?

Ok, I figured out what the problem was. When I exported it in phpmyadmin from the old server, godaddy said that "AUTO_INCREMENT" couldn't be included in the export. However, doing so made my forums and everything else spit out an error.


Is there a way to export it and import it with AUTO_INCREMENT from MySQL 4.1 to MySQL 4.0? I think Godaddy might have just been saying "no".