如何在PHP中将MySQL数据库文件（.sql）转换为SQLite文件？

Question

I have a MYSQL database dump file in ".sql" format but I have required "SQLite" file, is it possible to convert .sql file into SQLite file using php script or any other way?

I have also tried shell script code but this script create only file with 0 bytes.

Thanks 2 all

Answer 1

Go to phpmyadmin click export database download as sql file.

Download it....

go to your sql lite management software import the .sql file

done...

If you do not have access to PhpMyAdmin, you could use the mysql dump command and use this file to import it into your sqlite database http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html