I have a mysql *.sql file. It has been exported via phpmyadmin.
I need to do the following tasks:
- Import it into mysql.(via sql code)
- Import it into sqlite.(via sql code)
How can I do them?
Asked
Active
Viewed 42 times
0
PersianGulf
- 2,546
- 5
- 41
- 62
-
1Assuming that there's no mysql-specific things that sqlite will error over: https://www.sqlite.org/cli.html – Shawn Mar 11 '19 at 04:23
-
Have you read about MySQL's [LOAD DATA INFILE](https://dev.mysql.com/doc/refman/8.0/en/load-data.html) statement? – Bill Karwin Mar 11 '19 at 05:00
-
1For SQLite, see https://stackoverflow.com/questions/1045910/how-to-import-load-a-sql-or-csv-file-into-sqlite – Bill Karwin Mar 11 '19 at 05:02
-
@BillKarwin `LOAD DATA` only works for txt file. – PersianGulf Mar 11 '19 at 06:07
-
Totally right, my mistake. – Bill Karwin Mar 11 '19 at 06:32