How to Migrate MySQL from DBngin to Laravel Herd

This guide details a straightforward method for migrating your local MySQL databases from DBngin to Laravel Herd Pro, leveraging its integrated database management capabilities. This process minimizes data loss, but remember to back up crucial databases beforehand as a precaution. I am not responsible for any data loss during this process.

Important Note: This migration technique is only reliable if your MySQL versions share the same minor release (e.g., 8.0.33 to 8.0.36 is acceptable, but 8.0 to 8.2 is not).

Step 1: Halt DBngin's MySQL Service

Within the DBngin application, locate your MySQL service and click the "Stop" button to safely shut it down.

Step 2: Provision a MySQL Service in Herd

Navigate to the "Services" tab in Laravel Herd Pro. Click "Add Service" and create a new MySQL service. It's recommended to stop the newly created Herd MySQL service to prevent data corruption during the migration.

Step 3: Migrate Database Files

To locate your DBngin database files efficiently, right-click on the MySQL service in DBngin and select "Show database files." This will reveal a "mysql" folder containing your database directories.

Similarly, in Herd, right-click your MySQL service within the "Services" tab and choose "Open data directory" to identify the destination folder.

Copy all the folders and files from the DBngin database directory to the corresponding directory in Herd.

Step 4: Restart Herd's MySQL Service

After the file transfer is complete, return to Herd's "Services" tab and restart your MySQL service. Connect to the service (using your existing credentials) via your preferred database management tool; your databases should now be accessible.

Step 5 (Optional): Uninstall DBngin

If you've migrated all services from DBngin to Herd, consider uninstalling DBngin to streamline your Mac's application management.

Conclusion

Laravel Herd Pro simplifies Laravel development by offering streamlined database and caching management. Its ease of use and comprehensive features make it a valuable tool. Share your favorite Herd features on Twitter!

The above is the detailed content of How to Migrate MySQL from DBngin to Laravel Herd. For more information, please follow other related articles on the PHP Chinese website!