Request - Step by step to migrate from SQL to Mariadb and move existing projects? #589

Answered by Pen-y-Fan

KoolPal asked this question in Q&A

KoolPal
Oct 17, 2023

Hi All,

I am not fully technical but I am learning a bit using Laragon.

Can someone please guide on steps required to migrate from SQL to Mariadb and move existing projects?

I found this link https://www.kreaweb.be/laragon-migrate-mariadb/ but I am stuck on exporting and importing existing projects bit which has not been explained on this page.

Please help.

@Pen-y-Fan Can you please make one of your excellent Laragon guides on this? I am sure all would appreciate it, including me!

Thanks

Answered by Pen-y-Fan

I would recommend HeidiSQL, to export and import:

Login to the MySQL database
Right-click the database and select Export database as SQL

Export the data as per this screenshot:

Login to the new MariaDB server
Select File > Run SQL file...

Select the file you exported and it will auto-run
if you have problems, to troubleshoot, use: File > Load SQL file

View full answer

Replies: 2 comments

Pen-y-Fan
Oct 17, 2023

I would recommend HeidiSQL, to export and import:

Login to the MySQL database
Right-click the database and select Export database as SQL

Export the data as per this screenshot:

Login to the new MariaDB server
Select File > Run SQL file...

Select the file you exported and it will auto-run
if you have problems, to troubleshoot, use: File > Load SQL file

0 replies

Answer selected by KoolPal

KoolPal
Oct 17, 2023
Author

Thank you!

0 replies

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment