3
Ok, so I exported the SQL from my existing mySQL db, created a new mySQL db, and copied the SQL into the new DB...
Any idea why I got this error??
---------------------
Error
SQL-query :
DATABASE barbarybeats_com_ - _xoops -2092running ON localhost CREATE TABLE `xoops_avatar` (
`avatar_id` mediumint( 8 ) unsigned NOT NULL AUTO_INCREMENT ,
`avatar_file` varchar( 30 ) NOT NULL default '',
`avatar_name` varchar( 100 ) NOT NULL default '',
`avatar_mimetype` varchar( 30 ) NOT NULL default '',
`avatar_created` int( 10 ) NOT NULL default '0',
`avatar_display` tinyint( 1 ) unsigned NOT NULL default '0',
`avatar_weight` smallint( 5 ) unsigned NOT NULL default '0',
`avatar_type` char( 1 ) NOT NULL default '',
PRIMARY KEY ( `avatar_id` ) ,
KEY `avatar_type` ( `avatar_type` , `avatar_display` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL said:
#1064 - You have an error in your SQL syntax near 'Database barbarybeats_com_-_xoops-2092 running on localhost
CREATE TABLE `xoo' at line 1
---------------------