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


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

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.