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


SQL files are normally SQL scripts which are backups or scripts that create a database on a SQL server. If you need something in that script, you would need to setup a MySQL server, execute the SQL file on that server, and then get the data out that you need. I know that is a mouthful, and the process varies based on your operating system (Linux, Windows, Mac, etc).

After you do the above, you can connect with base, but you could also get your data out using the MySQL Workbench tool or even a command-line if you are using Linux. I can help you if somebody else doesn't help first, but I need to know what OS you are running to be able to help you further.

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


--
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

Context


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.