Windows Convert

[xTremoxx]

Hi i'm using Real Project 0.8, but a have one poblem, my server is sqlite, and have so much accounts and players created, i need converted this for mysql, for correct depot bug, and create one website, one friend say for me download SQLiteManager, buy i don't understand who use this script.. please have another program for use? please help, i need so much help ! thanks for attention.


Sorry my bad english ;/

 

[Ceejzor]

I don't think there is a way your going to get to keep all of the character's atleast I dont think so.. I could be wrong.

 

[xTremoxx]

Yes, have the possibility, because my friend say for i downloads SQLiteManager, but i not understand who to use.

 

[EvulMastah]

SQLite ----> MySql

   1. Download sqlite3.exe on http://www.sqlite.org
   2. Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
      sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
   3. Adapt the dump to get it compatible for MySQL
        - Replace " (double-quotes) with ` (grave accent)
        - Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
        - Replace "autoincrement" with "auto_increment"
   4. The dump is ready to get imported in a MySQL server

also: http://www.maxkpage.com/blog/free-sqlite-to-mysql-converter-super-easy/

 

[xTremoxx]

SQLite ----> MySql

   1. Download sqlite3.exe on http://www.sqlite.org
   2. Export the SQLite database with sqlite3.exe and command parameter ".dump" (Nate, ".export" doesn't exist!), an example :
      sqlite3 mySQLiteDataBase .dump .quit >> myDumpSQLite
   3. Adapt the dump to get it compatible for MySQL
        - Replace " (double-quotes) with ` (grave accent)
        - Remove "BEGIN TRANSACTION;" "COMMIT;", and lines related to "sqlite_sequence"
        - Replace "autoincrement" with "auto_increment"
   4. The dump is ready to get imported in a MySQL server

also: Free SQLite to MySql Converter - Super Easy!

I go try it, tks so much :*

 

[xTremoxx]

Rudolf, i converter with sucess, but when i go to import in phpmyadmin; this script:

CREATE TABLE 'accounts' (
    'id' INTEGER PRIMARY KEY NOT NULL,
    'password' VARCHAR(255) NOT NULL,
    'type' INTEGER NOT NULL DEFAULT 1,
    'premdays' INTEGER NOT NULL DEFAULT 0,
    'lastday' INTEGER NOT NULL DEFAULT 0,
    'key' VARCHAR(20) NOT NULL DEFAULT '0',
    'email' VARCHAR(255) NOT NULL DEFAULT '',
    'blocked' BOOLEAN NOT NULL DEFAULT 0,
    'warnings' INTEGER NOT NULL DEFAULT 0,
    'group_id' INTEGER NOT NULL DEFAULT 1,
    FOREIGN KEY ('group_id') REFERENCES 'groups' ('id')
);

Phpmyadmin say this error:

#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 ''accounts' ( 'id' INTEGER PRIMARY KEY NOT NULL, 'password' VARCHAR(255' at line 1

What's wrong ?

I don't have only this part to import (account), i have many more, but I'm testing with only this part.

Tks for attetion.



*************** EDIT *********************

ALL WORKING, TKS SO MUCH, I DONT REPLACE " TO `, I REPLACE " TO ', HAHAHAHA TKS

 

[EvulMastah]

yw.