Hello Chris,
As Otomatic has said:
Quote
otomatic
“the only sustainable way to transfer databases is to perform exports/imports as SQL files”
To migrate MySQL databases to a new computer:1. Go into your old PC and open phpMyAdmin.
2. Export all of the databases you want to migrate as sql files, save them to usb drive.
3. Go to your new PC and open phpMyAdmin.
4. Create new databases with the same names of the databases you exported on your old PC.
5. Make sure you create the same usename and password for each database as your old PC.
6. Insert the usb drive with your saved databases into your new PC.
7. For each database, select Import in phpMyAdmin and follow the prompts.
This is pretty much the procedure I go through when upgrading MariaDB or MySQL to a new version with the exception of saving databases to a usb drive. I usually save the files to my desktop. When I'm done importing, I move the files to an external drive for backup.
Quote
Chris98
How do I change it to use MySQL instead?
Right-click the WampServer tray icon >> Tools >> Invert Default DBMS MariaDB <-> MySQL
Hope this helps. Aloha...
P.S. The manual is your friend.