Skip to main content
added 250 characters in body
Source Link

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.

Export the data from table to a file using

Select into outfile from mysql ...

And after exporting use the file to import data into your mysqlite server using

Load data local infile.....

Export the data from table to a file using

 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.

Source Link

Export the data from table to a file using

Select into outfile from mysql ...

And after exporting use the file to import data into your mysqlite server using

Load data local infile.....