On 26 Aug 2012, at 11:37am, Νικολέττα Σιώτα <nicolesi...@hotmail.com> wrote:
> I have created a database with several tables in MySQL using the phpMyAdmin > tool > from XAMPP (apache) and I want to connect it with a VB.NET project. I thought > that > using Sqlite would be better for my project since it has a VB.NET feature. I > exported > my database as a .sql file but I can not use it with Sqlite because it shows > me that only > .db or .sqlite files are accepted. I tried to open my file with Sqlite3 but > it showed that > the tables contained errors. I am kind of confused on what needs to be done > to make > this work. > > If someone can answer me, I would be very grateful. Any help is very much > appreciated. > Thank you so much for your time. You will find a MySQL tool which will output your MySQL database as the set of SQL commands which would be needed to make that database. The result will be a text file which includes some 'CREATE TABLE' commands and many 'INSERT' commands, and some other commands. Then you do X. I will come back to X. Then you can use the SQLite shell tool (you can download it from the SQLite web site) to turn this text file into a SQLite database file. You use the '.read' command. Now I write about X. The formats for SQL commands are slightly different between MySQL and SQLite. You are probably going to have to use a text editor to make a minor change or two to the text file. It might word first time, it might not. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
