Re: Copying the database is giving me an error (Amazon Aurora)

2018-01-09 Thread Zach Bonjour
"You could also try using a database name that doesn't need to be quoted, like guacamole_0_9_13 or similar." Winner winner! Thanks! On Tue, Jan 9, 2018 at 1:05 PM, Mike Jumper wrote: > On Tue, Jan 9, 2018 at 10:19 AM, Zach Bonjour < > zbonj...@vibrantcreditunion.org> wrote: > >> ... >> ERROR:

Re: Copying the database is giving me an error (Amazon Aurora)

2018-01-09 Thread Mike Jumper
On Tue, Jan 9, 2018 at 10:19 AM, Zach Bonjour < zbonj...@vibrantcreditunion.org> wrote: > ... > 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

Copying the database is giving me an error (Amazon Aurora)

2018-01-09 Thread Zach Bonjour
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 rig