Re: [libreoffice-users] Connection to SQL database

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