Simon G's Blog

I was wanting to export the contents and design of an OpenOffice.org Base database to SQL with the intent of migrating to MySQL. I struggled to find out how to do this, but finally found out how. To generate an SQL file that contains both the contents and the data of the database I used the following command from the “Tools –> SQL…” menu: SCRIPT 'C:\temp\file.sql' When I tried to write it to the C:\ root directory I got a security error, but using another directory worked fine. Thanks to http://www.oooforum.org/forum/viewtopic.phtml?t=32333 for pointing me in the right direction. Incidentally, on my way to the final solution I also came across the following command to generate a CSV file of a table’s contents: SELECT * INTO TEXT "output_csv_file_name" FROM "table_name" The version of OpenOffice I was using was OpenOffice.org 3.3.0 – OOO330m20 (Build:9567) and I running this on a Windows 7 machine.

In many organisations a user's Profile size is restricted to a certain size and there is a constant juggling act to try and keep under your Profile quota. Firefox is an example of one application that was taking up lots of space in my quota, but I found that there is a nice and easy way to relocate the Firefox Profile to another drive or directory. Check out Mozilla's Step-by-step instructions for how to do this. This worked fine for me using Firefox v3.0.8 on Windows XP.