We are currently running Guac 0.9.10 and I am wanting to upgrade to the latest version. However, when I try and copy the database (to then upgrade the copy), I am getting an error to seems to indicate an issue with the database. I don't SQL that well, so I'm hoping someone can point me in the right direction. Is this an "Amazon Aurora is not really MYSQL" issue maybe?
ubuntu@ip-172-31-11-33:~$ mysqldbcopy --source='guacamole':'**************'@****************. us-east-1.rds.amazonaws.com --destination='guacamole':'***********'@**************. us-east-1.rds.amazonaws.com '`guacamole_db`':'`guacamole_0.9.13`' --drop-first WARNING: Using a password on the command line interface can be insecure. # Source on ***********.us-east-1.rds.amazonaws.com: ... connected. # Destination on *************.us-east-1.rds.amazonaws.com: ... connected. # Copying database guacamole_db renamed as guacamole_0.9.13 # Copying TABLE guacamole_db.guacamole_connection # Copying TABLE guacamole_db.guacamole_connection_group # Copying TABLE guacamole_db.guacamole_connection_group_permission # Copying TABLE guacamole_db.guacamole_connection_history # Copying TABLE guacamole_db.guacamole_connection_parameter # Copying TABLE guacamole_db.guacamole_connection_permission # Copying TABLE guacamole_db.guacamole_sharing_profile # Copying TABLE guacamole_db.guacamole_sharing_profile_parameter # Copying TABLE guacamole_db.guacamole_sharing_profile_permission # Copying TABLE guacamole_db.guacamole_system_permission # Copying TABLE guacamole_db.guacamole_user # Copying TABLE guacamole_db.guacamole_user_permission # Copying GRANTS from guacamole_db ERROR: Unable to execute constraint query ALTER TABLE guacamole_0.9.13.guacamole_user_permission add CONSTRAINT `guacamole_user_permission_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `guacamole_0.9.13`.`guacamole_user` (`user_id`) ON UPDATE RESTRICT ON DELETE CASCADE . Error: Query failed. 1064 (42000): 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 '.13.guacamole_user_permission add CONSTRAINT `guacamole_user_permission_ibfk_2` ' at line 1 ubuntu@ip-172-31-11-33:~$ <https://vibrantcreditunion.org> -- NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies.
