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: [email protected]
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
