I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded several tools that claimed it could handle the job, they all failed to create a sqlite db from sql provided. Any recommendations?
EverWebby
1
Light Poster
phpstan
0
Newbie Poster
Have you tried using mysqldump at the database level? The output should have the complete create and insert statements for SQLite. If the syntax is different recursive changes to the output using your favorite editor should make this relatively painless.
Please post a reply and flag as "solved" if this works.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.