如何从PHPMyAdmin导出MySQL数据库并将其导入SQLite? [英] How do I export a MySQL database from PHPMyAdmin and import it to SQLite?
问题描述
我想从PHPMyAdmin(或MySQl Workbench)中导出数据库并将其导入到SQLite数据库中,这样我就可以进行本地编辑和测试而不会破坏实时版本.我对SQL非常陌生,因此所有导出选项等在这一点上对我来说都很密集.我尝试通过命令
I would like to export a database from PHPMyAdmin (or MySQl Workbench) and import it to a SQLite database so that I can do local editing and testing without screwing up the live version. I am very new to SQL, so all of the export options, etc, are rather dense to me at this point. I have tried using the default export settings PHPMyAdmin with the command
sqlite3 test_db.db < maindb.sql
以及
sqlite3--> .read maindb.sql
但是这些引发了很多语法错误和没有这样的表"错误.
But these throw a bunch of syntax errors and 'no such table' errors.
我还尝试了经常引用的脚本在此处找到的脚本,但是当我尝试时使用以下命令从MySQL Workbench导出运行此命令:
I have also tried the oft-cited script script found here, but when I try to run this using an export from MySQL Workbench, using the command:
943776/mysql2sqlite.sh maindb.sql | sqlite3 test_db.sqlite
我收到以下错误:
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysql.sock' (2) when trying to connect
我没有正确配置导出吗?
Am I not configuring the exports correctly?
推荐答案
请参阅引用的脚本连接到数据库服务器本身.它确实不期望转储!
Please see that the referenced script connects to the database server itself. It does not expect a dump!
./mysql2sqlite -h example.com -u root -pMySecretPassWord myDbase | sqlite3 database.sqlite
这是应该执行脚本的方式.使用主机,用户名,密码和要转储的mysql数据库.
This is the way the script should be executed. With host, username, passwort and the mysql database you would like to dump.
由于不同的DBMS(例如MySQL和sqlite3)之间的数据库转储和DBMS功能可能存在很大差异,因此,我建议安装本地MySQL服务器,而不要使用sqlite3.对sqlite3进行更改时,您获得了什么优势?如果不进行更改,就无法将其应用于MySQL生产数据库?
Since database dumps and DBMS features can be severely different between different DBMS (like MySQL and sqlite3), I would recommend to install a local MySQL server instead of using sqlite3. What advantage have you achieved when you make changes to sqlite3, which you cannot apply to the MySQL production database without changes?
这篇关于如何从PHPMyAdmin导出MySQL数据库并将其导入SQLite?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!