× Want to win an Epson Printer? Enter the 7 Weeks of Christmas Photography Contest! Click Here --> Win an Epson Printer or a ThinkTank Photo Camera Bag!

Get Your FREE copy of Top 10 Tips for All Beginning Photographers ...plus Lightroom Develop Presets & Wedding Photography Checklist!

@Cazillo Newsletter #Cazillions Forum Email #Cazillion Special Offers
Joomla Extensions powered by Joobi
Please take a moment to share pages on Cazillo.com to grow the #Cazillions Community! Consider it your 'thanks' for Greg's hard work & dedication.

I've been moving my servers to Amazon EC2 and have been quite happy with it so far.  Today I started setting up a backup script to backup the databases from RDS as well as the web files from the EC2 Instance.  I got this error when attempting to execute mysqldump:

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)

Problem is that the RDS server is running MySQL 5.6 and MySQLDump is only v 5.1 on CentOS 6.4 as of this article.  After a bit of googling I found the answer on a Chinese site, translated it via Google Translate and it works great.  Hopefully this will help you too!

cd /root
wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
tar -xzvf mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
cp mysql-5.6.13-linux-glibc2.5-x86_64/bin/mysqldump /root
rm -rf mysql-5.6.13-linux-glibc2.5-x86_64
rm -rf mysql-5.6.13-linux-glibc2.5-x86_64.tar.gz
/root/mysqldump [options]

Explanation:

  1. Change directory where you want to permanently store new mysqldump version
  2. Download MySQL server version, you might need to find newer version or an x86 package file for your distro
  3. Untar downloaded file
  4. Copy msyqldump executable to /root folder (or your destination folder)
  5. Remove other package contents not needed
  6. Remove tarball not needed
  7. Always execute mysqldump with complete path instead of just #mysqldump

Add comment


Security code
Refresh

256 Eagleview Blvd PMB 104
Exton, PA 19341