Shenzi1985 Posted December 19, 2011 Share Posted December 19, 2011 i need to convert a database from sqlite to mysql but not sure how to do it. anyhelp appreciated Quote Link to comment Share on other sites More sharing options...
gizmola Posted December 19, 2011 Share Posted December 19, 2011 Number one google result: http://www.maxkpage.com/blog/free-sqlite-to-mysql-converter-super-easy/ Quote Link to comment Share on other sites More sharing options...
Shenzi1985 Posted December 19, 2011 Author Share Posted December 19, 2011 tried that i seem to get some error which i cant figure out why. #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 '"attribute_values__movie_info"' at line 1 any ideas? Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted December 19, 2011 Share Posted December 19, 2011 Echo and post the entire query string. The error is pretty much meaningless without it. Quote Link to comment Share on other sites More sharing options...
Shenzi1985 Posted December 20, 2011 Author Share Posted December 20, 2011 forgot to mark as solved. done it the easy way rolled back to a previous version of php,yadmin that allows to import csv files/ excel files into database much easier Quote Link to comment Share on other sites More sharing options...
rohitnanda Posted January 5, 2012 Share Posted January 5, 2012 if you have to convert a database from sqlite to mysql... so you can use the convertor.. Here is a list of converters: http://www.sqlite.org/cvstrac/wiki?p=ConverterTools Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.