FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


phpmyadmin question





vm_yap
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.

ty.
SpellcasterDX
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.
vm_yap
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.
vm_yap
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
mathiaus
Just remove all occurrences of the below from your code.
Quote:
DEFAULT CHARSET = latin1
Related topics
I Have a question . Is it the server support Chinese?
Salut tous !
Question before requesting free hosting
question abt posts/mth
Kinda dumb question regarding DNS
PHP, MySQL...
phpMyAdmin
A question
UT2004 U like the game? Do u have any question post here.
PHP question
phpMyAdmin
phpmyadmin question...
dumb nu-b question on phpmyadmin
How to access phpMyAdmin from outside cPanel
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.