Before running an update, it is recommended that you pull an update of your database.
...
It’s currently using MySQL 5.6 path – but you could change that to use it for MySQL 8.
You need to change the text “password” to the actual password (leave the quotes in place).
It will log any errors to the file name
superticker_dumpErrors.txt
in the current folder.It will save the dump to the file called:
superticker_dump.sql
in the current folder. If you want to have it dump to a specific folder replace the file name by putting the full path inside the quotes.The final
"superticker"
at the end is telling it to dump the superticker database.On machines that do not have the MySQL server installed you can also find the
mysqldump
andmysql
command line utilities in the MySQL Workbench installed files -> like C:\Program Files\MySQL\MySQL Workbench 6.3 CE.
Restore/Import this
To import this you can use a command like this:
Code Block |
---|
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe" --user=root --password=your_password --host=localhost --port=3306 "superticker" < "c:\temp\superticker_dump.sql" > "c:\temp\import_results.txt" |
You can change change the paths and files to point to your setup. And be sure to change the password to the actual password.
Master Backups for Replication
...
The default charset that is used is to export data is utf8. To support full Unicode though we need utf8mb4. To achieve this it's possible to modify Workbench to use utf8mb4 manually.
Go to C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules
open this file wb_admin_export.py.
Create a backup copy
Replace all occurrences "default-character-set":"utf8" with "default-character-set":"utf8mb4".
Save the file.
Restart Workbench.
The next time you run the export you will see in the log results like this:
Running: mysqldump.exe --defaults-file="c:\users\jonathan\appdata\local\temp\tmpidlh7a.cnf" --host=localhost --protocol=tcp --user=root --allow-keywords=TRUE --port=3306 --default-character-set=utf8mb4 --routines --skip-triggers "superticker"
MySQL Workbench version 6.2
...