i was trying to import my database to frihost and i cant seem to. It says an error has occurred. I never had this problem with another webhost, I just upload my sql file and done. Is this because frishost is using a lower version or maybe a higher version than what my database was created from. sorry newbie here.
Did you create a database and use the right log-in details?
And if that's not your problem, try uploading the database in chunks.
i did. wait.. when i created my db, i was still using frihost.net but i delted that annd now using a uni.cc account. so do i have to delete the created db and create a new one?
i was trying to import the whole sql file like what i used to do, not paste it.
can somebody tell me what i did wrong:
# Table structure of table `wp_categories`
CREATE TABLE `wp_categories` (
`cat_ID` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`cat_name` varchar( 55 ) NOT NULL default '',
`category_nicename` varchar( 200 ) NOT NULL default '',
`category_description` longtext NOT NULL ,
`category_parent` bigint( 20 ) NOT NULL default '0',
`category_count` bigint( 20 ) NOT NULL default '0',
PRIMARY KEY ( `cat_ID` ) ,
KEY `category_nicename` ( `category_nicename` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1
MySQL said: Documentation
#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 'DEFAULT CHARSET=latin1' at line 14