Export a MySQL Database to SQLite Database

by

There’s a fantastic Linux shell script on Github that converts Mysql to an Sqlite3 file. You need both mysqldump and sqlite3 installed on your server. Works great.

More Related Contents:

  1. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  2. What’s the best way to migrate a Django DB from SQLite to MySQL?
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. MyISAM versus InnoDB [closed]
  5. Compare two MySQL databases [closed]
  6. How should I resolve –secure-file-priv in MySQL?
  7. What does character set and collation mean exactly?
  8. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  9. Storing image in database directly or as base64 data?
  10. Implementation of Levenshtein distance for mysql/fuzzy search?
  11. Does MySQL ignore null values on unique constraints?
  12. What’s the difference between MyISAM and InnoDB? [duplicate]
  13. SQLite – ORDER BY RAND()
  14. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  15. In SQL, is it OK for two tables to refer to each other?
  16. Error renaming a column in MySQL
  17. Mysql database sync between two databases
  18. How to increase MySQL connections(max_connections)?
  19. MySql views performance [closed]
  20. Remove special characters from a database field
  21. Using reserved words in column names
  22. What is the difference between SQL and MySQL? [closed]
  23. mysql Failed to read auto-increment value from storage engine
  24. How to Get True Size of MySQL Database?
  25. Put MySQL database under version control?
  26. What are the max number of allowable parameters per database provider type?
  27. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  28. MySQL: Computed Column
  29. How do I make a MySQL database run completely in memory?
  30. How to recover just deleted rows in mysql?

Leave a Comment