MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Does it work with MySQL 5.6? Options · View
boborg
#1 Posted : Wednesday, November 7, 2012 2:04:26 AM
Rank: Newbie

Groups: Registered

Joined: 8/27/2012
Posts: 5
I am trying to do a backup of af MySQL 5.6 db. It fails with this error in the log

mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)

Does this tool not work yet with version 5.6? Any chance of an update soon?
AlexP
#2 Posted : Wednesday, November 7, 2012 2:08:44 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
boborg
#3 Posted : Wednesday, November 7, 2012 4:03:21 PM
Rank: Newbie

Groups: Registered

Joined: 8/27/2012
Posts: 5
You mean setting encoding utf-8 instead of auto-detect? Where do I find that setting?
AlexP
#4 Posted : Saturday, November 10, 2012 12:13:34 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hi,

You can copy an original mysqldump.exe file into the application's folder with "mysqldump-<major>_<minor>.exe" name. Where <major> and <minor> are major and minor version number of MySQL server.
boborg
#5 Posted : Tuesday, November 13, 2012 6:05:35 AM
Rank: Newbie

Groups: Registered

Joined: 8/27/2012
Posts: 5
Thanks a lot. That fixed it
Alexander Omelchenko
#6 Posted : Thursday, August 18, 2016 6:02:45 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Please feel free to contact us on any issues or concerns.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com