Re: [libreoffice-users] Connection to SQL database

On 01/15/2014 10:51 AM, Carl Paulsen wrote:
> I have a project for which I need to extract data that is in a .sql 
> file (presumably a SQL database).  I've done very little with SQL so I 
> need some guidance on doing this.  One route would be to open it with 
> Base or Access (I now finally have access to MSAccess on a Windows 
> machine but would prefer Base), but I don't understand the basics of 
> doing this.
>
> So...can someone point me to a tutorial on how to do this, 
> step-by-step and from the very beginning?  For instance, do I need to 
> set up a SQL server and if so, how?  (I've tried installing XAMP with 
> MySQL on the Windows machine but haven't gotten it to connect to the 
> file yet.)  Can I access a .sql file directly or via other methods?  
> I'd like to eventually learn how to use SQL but I'm also on a pretty 
> limited timeframe on accessing this data.
>
> Or does someone want to outline the steps here for me to research on 
> my own?
>
> Thanks very much,
> Carl
Carl

First please advise your OS and LO version.

The basic steps to connect to any outside database backend are:

1. Set up the database backend - Note any usernames and passwords used 
to connect to the database. Often the install wizard will prompt you for 
both.

2. Make sure it is running - depending on your boot settings you might 
need to manually start the backend. This may require you to use your 
command line aka terminal on Linux and Macs, Command on Windows.

3. Make sure the correct connector for your backend is installed for 
Base. In Linux check your package manager to make sure it is installed. 
I am not sure what the Windows or Mac installers do.

4. Run the connection wizard in Base. A detail I am not sure about here 
is whether you need to have any schema/database/tables set up in the 
backend. I usually use Base for pretty reports for a MySQL/MariaDB 
backend that has numerous schemas/tables already setup. If you used the 
default settings when setting up the database backend you mainly have to 
enter the log in credentials.

Most backends have a default port they listen on (MySQL/MariaDB is 3306) 
and normally you do not need to change this. Also, you will need to know 
the path to the database or URL to reach it. If the database backend is 
on your local computer the path is localhost (127.0.0.1).

--
Jay Lozier
jslozier@gmail.com


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted