sqlite

mysql to sqlite notes

Posted in sqlite
511
4:33 am, August 3, 2023
 

mysql to sqlite notes

<p>&nbsp;</p>
<p>### MySQL to SQLite converter<br />https://pypi.org/project/mysql-to-sqlite3/<br />https://github.com/dumblob/mysql2sqlite<br />https://stackoverflow.com/questions/3890518/convert-mysql-to-sqlite</p>
<p>``<br />pip install mysql-to-sqlite3<br />sudo apt install mysql-to-sqlite3<br />mysql2sqlite --help</p>
<p>https://github.com/techouse/mysql-to-sqlite3</p>
<p>mysqldump --skip-extended-insert --compact aion &gt; aionmysql.sql<br />&nbsp; &nbsp; ./mysql2sqlite aionmysql.sql | sqlite3 aion.db<br />`</p>
<p>Converts MySQL dump to SQLite3 compatible dump (including MySQL KEY xxxxx statements from the CREATE block).</p>
<p>## [](https://github.com/dumblob/mysql2sqlite#usage)Usage<br />https://github.com/dumblob/mysql2sqlite</p>
<p>[[mysql2sqlite]] file</p>
<ol>
<li>Dump MySQL DB<br />&nbsp; &nbsp;&nbsp;<br />&nbsp; &nbsp; `<br />&nbsp; &nbsp; mysqldump --skip-extended-insert --compact [options]... DBname &gt; dumpmysql.sql<br />&nbsp; &nbsp; # or<br />&nbsp; &nbsp; #mysqldump --no-data -u root -pmyPassword [options]... DBname &gt; dumpmysql.sql<br />&nbsp; &nbsp; `<br />&nbsp; &nbsp;&nbsp;<br />2. Convert the dump to SQLite3 DB<br />&nbsp; &nbsp;&nbsp;<br />&nbsp; &nbsp; `<br />&nbsp; &nbsp; ./mysql2sqlite dumpmysql.sql | sqlite3 mysqlite3.db<br />&nbsp; &nbsp; ``</li>
</ol>
<p>Confirmed working creating a dump from mysql and into sqlite. Yay.</p>
<p><img src="https://i.imgur.com/YGLgwWn.png" /></p>
<p>working commands:</p>
<p>sudo mysqldump --skip-extended-insert --compact aion &gt; aionmysql.sql<br />./mysql2sqlite aion_mysql.sql | sqlite3 aion.db</p>

Posted in sqlite
511
4:33 am, August 3, 2023

View Statistics
This Week
102
This Month
538
This Year
589

No Items Found.

Add Comment
Type in a Nick Name here
 
Other Items in sqlite
load a random item from sqlite table SQLite - load a game from games, that has not been processed - AI mysql to sqlite notes function to delete older sqlite records when the limit is reached count total results from distinct sqlite
Related Search Terms
sqlite Stack 11
sqlite Creating 13
sqlite state 12
sqlite work 8
sqlite http 21
sqlite Project 10
sqlite password 12
sqlite Notes 31
sqlite into 11
sqlite options 16
sqlite name 17
sqlite install 16
sqlite notes 33
sqlite dat 11
sqlite git 15
sqlite working 11
sqlite block 14
sqlite questions 12
sqlite MySQL 42
sqlite overflow 10
sqlite help 11
sqlite root 14
sqlite Mysql 40
sqlite https 13
sqlite Options 15
sqlite Block 11
sqlite Questions 10
sqlite tech 13
sqlite Working 9
sqlite MySQL to SQLite converter 11
sqlite convert 13
sqlite Tech 10
sqlite create 10
sqlite file 11
sqlite Mysql To Sqlite Notes 27
sqlite mysql to sqlite notes 26
sqlite Sql 54
sqlite mysql to sqlite converter 9
sqlite Git 7
sqlite project 13
sqlite mysql to sqlite 23
sqlite Convert 12
sqlite flow 11
sqlite creating 12
sqlite Sqlite 45
sqlite SQLite 53
sqlite mysql 45
sqlite all 12
sqlite Install 13
sqlite the 13
sqlite stack 14
sqlite from 20
sqlite sqlite 50
sqlite sql 59
Other Categories in Code
alpine js apps c css factorio font awesome images linux quick modals sqlite site bugs site updates slick slider sliders testing windows apps ai animation apache api apps asp bat blocking bootstrap bootstrap templates charts cookies core css css filters css grid css tips design elements docker domains emoji fancybox fonts foundation framework gimp git html icons ideas image formatting images javascript javascript functions jquery js linux mac minecraft misc modal modals mysql nginx node php php errors php function php functions php simple html dom pi400 proxmox python react regex sections simple_html_dom simplepie php site bugs site documentation slick slick slider sql sqlite ssh sublime svg svg css templates test tools video virtual box vscode vue webdev windows windows 11 windows commands wordpress youtube
Search Code
Search Code by entering your search text above.
Welcome

This is my test area for webdev. I keep a collection of code here, mostly for my reference. Also if i find a good link, i usually add it here and then forget about it. more...

You could also follow me on twitter. I have a couple of youtube channels if you want to see some video related content. RuneScape 3, Minecraft and also a coding channel here Web Dev.

If you found something useful or like my work, you can buy me a coffee here. Mmm Coffee. ☕

❤️👩‍💻🎮

🪦 2000 - 16 Oct 2022 - Boots
Random Quote
You want to be the best, you MUST put the long yards in! Nothing comes easy in life so stop wishing and start DOING! So many people would rather bitch and moan than help themselves. Dont be one of those negative drainers, start today, make a small change and keep going forwards with this attitude!
Unknown
Latest News
## 🚀 AI Giants Hit Bullseye: Anthropic & OpenAI Achieve Product-Market Fit Anthropic and OpenAI have reached a significant milestone, finding product-market fit with their AI technologies, which means their products effectively meet the needs of their customers, driving growth and adoption. This achievement showcases the practical value of their innovations, enabling businesses and individuals to leverage AI for enhanced productivity and efficiency. With this alignment of product and market needs, these companies are poised to transform industries and shape the future of technology.