Error in MySql

[Cm Himen]

3 things....

1) I'm back to creating ot's again so if these questions are nabby ones im sorry but i followed the MYSQL_HELP file in the folder.

2) http://heanet.dl.sourceforge.net/sourceforge/xampp/xampp-win32-1.6.4-installer.exe

is not working... i have xampp already downloaded (1.6.6) which will lead to my third question...

3) I get an error trying to import the s3db file I will post it (Most of it for you)

Error
There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:

That is what it said at the top and at least 5 posts of numbers so i wont go on with that, and at the bottom it says...

#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 'SQLite format 3' at line 1

How ever i just noticed there was an x by this line...

DELETE FROM "house_lists" WHERE "house_id" = OLD."id";
END�*)�triggerondelete_tilestiles�CREATE TRIGGER "ondelete_tiles"
BEFORE DELETE
ON "tiles"
FOR EACH ROW
BEGIN
DELETE FROM "tile_items" WHERE "tile_id" = OLD."id";
END

the x is by the word begin in the end. it is red maybe meaning the error???

 

[Decent60]

The problem is that SQLite and MySQL run off of two different variables and slightly different format (besides the ending). As you can see when you throw it into these forms, you get these "�*)�" marks which doesn't exist in SQL version.

You could try what is listed here:
http://www.sqlite.org/cvstrac/wiki?p=ConverterTools

Or you can try this:
http://www.planetteamspeak.com/component/option,com_docman/task,doc_details/gid,31/Itemid,70/
(Note they haven't tested this though)

Those are about the only things I could find that were free.

 

[Jonern]

You said you were trying to import the s3db file to MySQL. That wont work The s3db file is the for SQLite.

Solution: Try to import forgottenserver.sql instead.