CharSet Help Pls
Posted by: emre aras
Date: June 08, 2006 03:38AM

sory my english very bad

i have big problem. i change hosting but i cant update my mysql database

pls help me

the eror :

BigDump: Staggered MySQL Dump Importer ver. 0.21b
Processing file: dahaneler.sql

Starting at the line: 1

Error at the line 24: ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Query: CREATE TABLE `vb_access` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `accessmask` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`userid`,`forumid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

MySQL: 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 6

Stopped on error

Start from the beginning (DROP the old tables before restarting)

© 2003-2005 Alexey Ozerov - BigDump Home

Options: ReplyQuote

Written By
CharSet Help Pls
June 08, 2006 03:38AM
June 08, 2006 04:41AM
June 08, 2006 07:53AM
June 20, 2006 12:07AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.