Hi all,

I've got "Database error" after migration process.

Restoring database metro_forumdb......
/usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'metro_forumdb'; database exists'
ERROR 1064 (42000) at line 33: 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 'mping data for table `access`
LOCK TABLES `access` WRITE' at line 1
...........
ERROR 1072 (42000) at line 740: Key column 'bloguser-- Sending SELECT query...
-- Retrieving rows...
id' doesn't exist in table
ERROR 1146 (42S02) at line 769: Table 'metro_forumdb.blog_comment' doesn't exist
ERROR 1146 (42S02) at line 770: Table 'metro_forumdb.blog_comment' doesn't exist
ERROR 1146 (42S02) at line 774: Table 'metro_forumdb.blog_comment' doesn't exist
ERROR 1064 (42000) at line 811: 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 'va
rchar(255) NOT NULL default '',
`deletedbyuserid` int(10) unsigned NOT NULL' at line 37
ERROR 1146 (42S02) at line 867: Table 'metro_forumdb.blog_entry' doesn't exist
ERROR 1146 (42S02) at line 868: Table 'metro_forumdb.blog_entry' doesn't exist
ERROR 1146 (42S02) at line 869: Table 'metro_forumdb.blog_entry' doesn't exist
ERROR 1146 (42S02) at line 873: Table 'metro_forumdb.blog_entry' doesn't exist
ERROR 1064 (42000) at line 1117: 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 'N
OT NULL,
`vbulletinbuddies` tinyint(3) unsigned NOT NULL default '0',
`sty' at line 17
ERROR 1146 (42S02) at line 1150: Table 'metro_forumdb.blog_settings' doesn't exist
ERROR 1146 (42S02) at line 1151: Table 'metro_forumdb.blog_settings' doesn't exist
ERROR 1146 (42S02) at line 1152: Table 'metro_forumdb.blog_settings' doesn't exist
ERROR 1146 (42S02) at line 1154: Table 'metro_forumdb.blog_settings' doesn't exist
ERROR 1064 (42000) at line 1162: 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 'uns
igned NOT NULL default '0',
`rating` tinyint(3) unsigned NOT NULL default ' at line 16
ERROR 1146 (42S02) at line 1197: Table 'metro_forumdb.blog_stats' doesn't exist
ERROR 1146 (42S02) at line 1198: Table 'metro_forumdb.blog_stats' doesn't exist
ERROR 1146 (42S02) at line 1199: Table 'metro_forumdb.blog_stats' doesn't exist
ERROR 1146 (42S02) at line 1203: Table 'metro_forumdb.blog_stats' doesn't exist
ERROR 1115 (42000) at line 1259: Unknown character set: 'latin'
ERROR 1146 (42S02) at line 1284: Table 'metro_forumdb.calendar' doesn't exist
ERROR 1146 (42S02) at line 1285: Table 'metro_forumdb.calendar' doesn't exist
ERROR 1146 (42S02) at line 1286: Table 'metro_forumdb.calendar' doesn't exist
ERROR 1146 (42S02) at line 1290: Table 'metro_forumdb.calendar' doesn't exist
ERROR 1072 (42000) at line 1612: Key column 'v-- Sending SELECT query...
-- Retrieving rows...
isible' doesn't exist in table
ERROR 1146 (42S02) at line 1641: Table 'metro_forumdb.event' doesn't exist
ERROR 1146 (42S02) at line 1642: Table 'metro_forumdb.event' doesn't exist
ERROR 1146 (42S02) at line 1643: Table 'metro_forumdb.event' doesn't exist
ERROR 1146 (42S02) at line 1647: Table 'metro_forumdb.event' doesn't exist
...........
ERROR 1064 (42000) at line 2268: 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 'NUL
L default '0.00000',
`vbp_candenyaccesscost` decimal(30,5) NOT NULL defaul' at line 39
ERROR 1146 (42S02) at line 2330: Table 'metro_forumdb.forum' doesn't exist
ERROR 1146 (42S02) at line 2331: Table 'metro_forumdb.forum' doesn't exist
ERROR 1146 (42S02) at line 2332: Table 'metro_forumdb.forum' doesn't exist
ERROR 1146 (42S02) at line 2336: Table 'metro_forumdb.forum' doesn't exist
ERROR 1059 (42000) at line 2622: Identifier name 'phrasegroup_siradrianbl-- Sending SELECT query...
-- Retrieving rows...
og_acp' is too long
ERROR 1146 (42S02) at line 2703: Table 'metro_forumdb.language' doesn't exist
ERROR 1146 (42S02) at line 2704: Table 'metro_forumdb.language' doesn't exist
ERROR 1146 (42S02) at line 2705: Table 'metro_forumdb.language' doesn't exist
ERROR 1146 (42S02) at line 2709: Table 'metro_forumdb.language' doesn't exist
...........
...........
...........
...........
ERROR 1064 (42000) at line 3927: 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 'N
ULL default '0',
PRIMARY KEY (`rssfeedid`),
KEY `lastrun` (`lastrun`)
) E' at line 18
ERROR 1146 (42S02) at line 3955: Table 'metro_forumdb.rssfeed' doesn't exist
ERROR 1146 (42S02) at line 3956: Table 'metro_forumdb.rssfeed' doesn't exist
ERROR 1146 (42S02) at line 3960: Table 'metro_forumdb.rssfeed' doesn't exist
ERROR 1072 (42000) at line 3996: Key column 'searchid-- Sending SELECT query...
-- Retrieving rows...
' doesn't exist in table
ERROR 1146 (42S02) at line 4026: Table 'metro_forumdb.search' doesn't exist
ERROR 1146 (42S02) at line 4027: Table 'metro_forumdb.search' doesn't exist
ERROR 1146 (42S02) at line 4028: Table 'metro_forumdb.search' doesn't exist
ERROR 1146 (42S02) at line 4030: Table 'metro_forumdb.search' doesn't exist
...........
ERROR 1064 (42000) at line 4668: 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 'uns
igned NOT NULL default '0',
`notes` varchar(250) NOT NULL default '',
`v' at line 18
ERROR 1146 (42S02) at line 4713: Table 'metro_forumdb.thread' doesn't exist
ERROR 1146 (42S02) at line 4714: Table 'metro_forumdb.thread' doesn't exist
ERROR 1146 (42S02) at line 4715: Table 'metro_forumdb.thread' doesn't exist
ERROR 1146 (42S02) at line 4719: Table 'metro_forumdb.thread' doesn't exist
ERROR 1153 (08S01) at line 5506: Got a packet bigger than 'max_allowed_packet' bytes
Done

Really need advice in this case.
Thanks in advance.

Where are you migrating from and where are you migrating to?

Umm, why are you trying to recreate a table that already exists apparently? Try deleting the table entirely and re-trying the script and see if that helps any because the database seems to be the problem by looking at what you gave me.

Where are you migrating from and where are you migrating to?

I was migrate it at same machine, only for HDD swap to a bigger one.