{"id":211,"date":"2018-05-23T17:05:17","date_gmt":"2018-05-23T17:05:17","guid":{"rendered":"http:\/\/rat32.com\/rat32\/?p=211"},"modified":"2018-05-23T17:05:17","modified_gmt":"2018-05-23T17:05:17","slug":"how-to-convert-mysql-database-to-sqlite-database","status":"publish","type":"post","link":"https:\/\/rat32.com\/rat32\/2018\/05\/23\/how-to-convert-mysql-database-to-sqlite-database\/","title":{"rendered":"How to convert Mysql Database to SQLite database?"},"content":{"rendered":"<p>I have found a simple way to convert the Mysql Database into SQLite database. Following are the steps:<\/p>\n<ol>\n<li>Open PhpMyadmin on your browser. (eg. http:\/\/localhost:8888\/phpmyadmin)<\/li>\n<li>Select database and click on Export.<\/li>\n<li>Make sure SQL is selected as format and click go.<\/li>\n<li>Make a copy of the mysqlcode and store in a file db.txt.<\/li>\n<li>Download DB Browser for SQLite from <a href=\"http:\/\/sqlitebrowser.org\/\">sqlitebrowser.org<\/a> .<\/li>\n<li>Create new Database and create table.<\/li>\n<li>Navigate to Execute SQL tab and copy the insert statements and execute the sql or import the insert statements from file db.txt and execute the code<\/li>\n<li>Finally, the SQLite database is ready.<\/li>\n<\/ol>\n<p>If you have a simplier method to do this please do write in our comments section. Thanks.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>I have found a simple way to convert the Mysql Database into SQLite database. Following are the steps: Open PhpMyadmin on your browser. (eg. http:\/\/localhost:8888\/phpmyadmin) Select database and click on Export. Make sure SQL&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[141,94,140],"class_list":["post-211","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-conversion","tag-mysql","tag-sqlite"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/posts\/211"}],"collection":[{"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/comments?post=211"}],"version-history":[{"count":1,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/posts\/211\/revisions"}],"predecessor-version":[{"id":212,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/posts\/211\/revisions\/212"}],"wp:attachment":[{"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/media?parent=211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/categories?post=211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rat32.com\/rat32\/wp-json\/wp\/v2\/tags?post=211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}