Now I want to connect to this new schema from LibreOffice Base and save as a new DatabaseĪsks for ODBC or JDBC Connectivity.Go to my user and add all Schema Privileges to GVaccounts Open mySQL Administrator and enter the following: Initial Steps - Connecting to MySQL on my computer Libreoffice-mysql-connector -needed to connect directly to MySQL without ODBC or JDBC wrapper. Mysql-query-browser -used to enter queries and scripts directly Mysql-admin -this is a GUI admion tool for mysql mysql-server -this is a metapackage for all the required server programs for latest build. After further trial, I will likely install the MySQL server on my always on Zentyal server. I have setup automatic backups via MySQL Administrator (writes a cron job in my case) which drops data backups into my DropBox folder. Feel free to add additional info as comments! By the way, I really like my new setup! MUCH faster than my database was while embedded. Here are my notes for anyone else planning this migration. I was unable to move to hsqldb 2.x implementation for technical reasons, so converted to MySQL back end. After losing data from a power failure while using Base as Embedded, I decided to convert to Front end-back end configuration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |