Shulou(Shulou.com)05/31 Report--

Editor to share with you how to import sqlite3 data into mysql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The methods are as follows:

Dump sql from a sqlite3 file

Sqlite3 database.sqlite3sqlite3 > .output / path/to/dump.sqlsqlite3 > .dumpsqlite3 > .exit

Syncopated file

When the file is relatively large, it often fails in the middle of the import. At this time, you need to split a new sql file from the failed line.

Awk'{if (NR > = 6240863) print $0 > "dump_part.sql"} 'dump.sql

Mysql parameter modification

[mysqld] max_allowed_packet = 100m

Sql compatibility, symbol replacement

# 1. Delete line # 2 that does not contain INSERT INTO. Replace the table name wrap# 3. Replace hexsed'/ INSERT INTOMPAGUP dump.sql 'dump.sql / "table1" / `table1` /; s / "table2" / `table2` /;

Import to MySQL

# add the force parameter to prevent some problematic sql from blocking the import of mysql-uroot-p-f magnet < dump.sql

Quote

How To Use The SQLite Dump Command

The above is all the contents of the article "how to import data from sqlite3 into mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.