Migrating MySQL databases to a new server with phpMyAdmin
1
vote
2
answers
818
views
Looking for the best way to migrate a dozen or so MySQL databases from an old Mac mini to a new one.
I've tried the source machine's phpMyAdmin (v. 4) EXPORT command, using what looked like reasonable options, and with all my existing databases selected. It created a 5+GB SQL file. Scanning through it, I see the "CREATE TABLE" commands but not any "CREATE DATABASE" commands.
Am I doing it wrong?
Asked by Rob Lewis
(111 rep)
Jun 5, 2023, 05:50 PM
Last activity: Jun 10, 2023, 12:38 AM
Last activity: Jun 10, 2023, 12:38 AM