Export the data from table to a file using
Select into outfile from mysql ...
SELECT * INTO OUTFILE '/path/to/file.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM DEPT And after exporting use the file to import data into your mysqlite server using
Load data local infile..... Check this link MySQL - LOAD DATA INFILE.