guacamole-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zach Bonjour <zbonj...@vibrantcreditunion.org>
Subject Copying the database is giving me an error (Amazon Aurora)
Date Tue, 09 Jan 2018 18:19:45 GMT
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.

Mime
View raw message