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 <[email protected]> Date:01/23/2015 2:13 PM (GMT-05:00) To: [email protected] 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: [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 -- 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
