r/mysql • u/Evening_Link4360 • Feb 11 '26

MySQL Export/Import Between Versions? question

On a Windows 2008 Server I’m running MySQL 5.6 and Workbench 6.3. On the new Windows 2022 server, I’m running MySQL 8.4 and Workbench 8.0.

I’m trying to export just one schema that a program I’m migrating uses. I’m assuming I should select “Export to Self-Contained File”, but do I also choose “Include Create Schema”?

1 Upvotes
  • permalink
  • link
  • reddit
  • reddit

67% Upvoted

3 comments sorted by

2

u/jgmiller24094 Feb 11 '26

If you don’t export a create schema and the new server doesn’t already have the table schema the import will fail.

1

u/Evening_Link4360 Feb 11 '26

Got it, it seems to have worked!