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
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
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
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).
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: 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