samuel157
/root
- Joined
- Mar 19, 2010
- Messages
- 616
- Solutions
- 4
- Reaction score
- 122
- Location
- São Paulo, Brazil
- GitHub
- Samuel10M
How do I convert my SQLite database to MySQL to run XAMPP 1.7.3?
-
2026 staff recruitment is open! Check it out and consider applying!
AAC How do I convert my SQLite database to MySQL to run XAMPP 1.7.3?
- Thread starter samuel157
- Start date
Solution
Dump sqlite sql file and than modify to make it work with mysql. Acutally there is plenty of ways to do it.
you can try programs like DB browser to export sql and than modify or convert to mysql .sql.
PS. I found very old thread but pictures are already gone.
for sure you can find a lot of scripts on git too.
you can try programs like DB browser to export sql and than modify or convert to mysql .sql.
PS. I found very old thread but pictures are already gone.
Your engine is probably 15-20 years old, its time to think about some changes.
Well to start this off I'll just say that I was trying to import my sqlite database into a MySQL database and had no idea. Well after many hours, sweat & tears etc... I've come up with an answer! 
1. Download Firefox if you don't have it; Firefox Browser | Free ways to customize your Internet
2. Download this sql2mysql converter addon; https://addons.mozilla.org/en-US/firefox/addon/5817
3. When it's done installing, restart firefox, then go to Tools, "SQLite Manager"...
1. Download Firefox if you don't have it; Firefox Browser | Free ways to customize your Internet
2. Download this sql2mysql converter addon; https://addons.mozilla.org/en-US/firefox/addon/5817
3. When it's done installing, restart firefox, then go to Tools, "SQLite Manager"...
for sure you can find a lot of scripts on git too.
magozon
Active Member
- Joined
- Jul 27, 2024
- Messages
- 57
- Solutions
- 2
- Reaction score
- 25
Dump sqlite sql file and than modify to make it work with mysql. Acutally there is plenty of ways to do it.
you can try programs like DB browser to export sql and than modify or convert to mysql .sql.
PS. I found very old thread but pictures are already gone.
for sure you can find a lot of scripts on git too.
you can try programs like DB browser to export sql and than modify or convert to mysql .sql.
PS. I found very old thread but pictures are already gone.
Your engine is probably 15-20 years old, its time to think about some changes.
Well to start this off I'll just say that I was trying to import my sqlite database into a MySQL database and had no idea. Well after many hours, sweat & tears etc... I've come up with an answer!
1. Download Firefox if you don't have it; Firefox Browser | Free ways to customize your Internet
2. Download this sql2mysql converter addon; https://addons.mozilla.org/en-US/firefox/addon/5817
3. When it's done installing, restart firefox, then go to Tools, "SQLite Manager"...
1. Download Firefox if you don't have it; Firefox Browser | Free ways to customize your Internet
2. Download this sql2mysql converter addon; https://addons.mozilla.org/en-US/firefox/addon/5817
3. When it's done installing, restart firefox, then go to Tools, "SQLite Manager"...
for sure you can find a lot of scripts on git too.
OP
OP
samuel157
/root
- Joined
- Mar 19, 2010
- Messages
- 616
- Solutions
- 4
- Reaction score
- 122
- Location
- São Paulo, Brazil
- GitHub
- Samuel10M
Thanks @magozon Solved.
I will continue using SQLite even knowing that MySQL has many vulnerabilities and, since my internet is shared, it can easily go down if I open port 80 TCP on the modem. It suffers a DDoS attack and my internet goes down. I'll wait until I receive the money and invest in a dedicated server, unless I can get a PC with more processing power.
I will continue using SQLite even knowing that MySQL has many vulnerabilities and, since my internet is shared, it can easily go down if I open port 80 TCP on the modem. It suffers a DDoS attack and my internet goes down. I'll wait until I receive the money and invest in a dedicated server, unless I can get a PC with more processing power.