Aug 13
Tom Fortis L8.6 MySQL db moved to standalone server not being recognized properly
Aug 13, 2015; 23:32
Tom Fortis
L8.6 MySQL db moved to standalone server not being recognized properly
Hello Lasso folks!
My current setup is a mac mini running Lion, L8.6, MySQL 5.5.21. I have set up a MySQL server-only on a new mac mini running Yosemite and MySQL 5.6.20. My desire is to move the MySQL databases from the Lion server to the new Yosemite server, but keep the Lasso code running on the Lion server for the time being. I did a mysqldump of a production database and moved it to the new server and added it with mysql command line.
I set up lasso site admin on the Lion server to see the new MySQL server and created a unique test database on the new server and it worked beautifully.
So after importing the production database, it shows up in lasso site admin. At this point, I’m not sure what the proper procedure would be. I would like to keep the same name for the database, but there would obviously be a conflict. Lasso site admin happily allows both to coexist, but my code only recognizes the original db on the Lion server. If I disable the original database, or even go as far as removing it from MySQL and lasso site admin, my lasso code throws an error saying the database cannot be access because it has been disabled. Which is basically true, but how do I get lasso to recognize the DB on the new server. It is enabled and all security is setup the same as the original. I’m afraid having the same DB name could be an issue. Should I consider renaming the DB and updating the lasso code, or am I missing something terribly obvious??
Thank you for any input!
Cheers!
Tom
--------
Tom Fortis
BFTV Cluster IT
UC Davis
(530)752-9167
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Aug 13
Ke Carlton Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 13, 2015; 23:59
Ke Carlton
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 14
Tom Fortis Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 14, 2015; 15:13
Tom Fortis
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 14
Mason Miller Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 14, 2015; 11:29
Mason Miller
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17
Peter D Bethke Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17, 2015; 10:50
Peter D Bethke
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17
Tom Fortis Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17, 2015; 16:48
Tom Fortis
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17
Peter D Bethke Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17, 2015; 14:54
Peter D Bethke
Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17
Tom Fortis Re: L8.6 MySQL db moved to standalone server not being recognized properly
Aug 17, 2015; 20:24
Tom Fortis
Re: L8.6 MySQL db moved to standalone server not being recognized properly