Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

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,

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 (

Jay Lozier

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.