Move database

Hello, I want to move databases from one MySQL computer (version 8.0.35) to another (also version 8.0.35). What's the best way to do this? Wolfgang

You do an SQL export on the source server, and import the resulting .sql file on the target server.

If you want to do that with tools from MySQL, you use mysqldump for the first step, and mysql for the import.

With HeidiSQL, you can do the export + import with just a few clicks:

• You need to have both servers defined as a session in HeidiSQL first
• Then, in the source session connected, you click "Export database as SQL" and select the target session in the "Output" dropdown.
• be sure to select the wanted database in the dropdown below. You can also let HeidiSQL create the new database.
• click "Export"

Note this may be a bit slow, depending on your network speed.

Here's a screen of the export dialog with the options I explained above: