RE: [libreoffice-users] MySQL - LO Base question.

If you had installed MySQL Workbench before you rebuilt your hard drive, you could have exported 
your database file. Then when you had rebuilt the hard drive, you could import the sql file. This 
is easier than what you are now doing.

Dan

-------- Original message --------
From: Ian Whitfield <whitfield@telkomsa.net> 
Date:01/23/2015  2:13 PM  (GMT-05:00) 
To: users@global.libreoffice.org 
Subject: [libreoffice-users] MySQL - LO Base question. 

Hi All

I have been running a MySQL Database with LO Base as a front-end for 
some time now -
and VERY successfully indeed compared to the built-in engine in LO Base!!
(My OpSys is PClinuxOS 32-bit)

For a variety of reasons I decided to "rebuild" my system last week. I 
have a back-up of my Database as a CSV file and have completely wiped 
the hard drive and reinstalled the OpSys and all relevant programs and 
copied all my data into /home.

I now need to set-up my Database again but have a question.
(My Database has only one table with about 2500 records and each record 
has 80 fields.)

Which is the correct procedure??

1) Set-up the Database in MySQL and create an empty table to import the 
CSV into. Then link Base to it.
2) Set-up the Database in MySQL then use LO Base to create the table and 
do the import
3) Set-up the Database using LO Base and then import the data.

Thanks for any pointers.

IanW
Pretoria RSA

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

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