Skip to content

Instantly share code, notes, and snippets.

@Surf-logic

Surf-logic/importDBtoAWSRDS.md

Last active May 4, 2024 23:18
Show Gist options
  • Save Surf-logic/41f0a913266e6ccb1643980f02f37cfd to your computer and use it in GitHub Desktop.
Save Surf-logic/41f0a913266e6ccb1643980f02f37cfd to your computer and use it in GitHub Desktop.
Download ZIP
Import data base into AWS RDS using MySQL Workbench
Raw
importDBtoAWSRDS.md

Remove the 3 lines below if they're there, or comment them out with -- :

At the start:

-- SET @@SESSION.SQL_LOG_BIN= 0;
-- SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '';

At the end:

-- SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;

Note that the comment characters are "dash dash space" including the space.

A better solution is to stop these lines from being written to the dump file at all by including the option --set-gtid-purged=OFF on your mysqldump command.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment