Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 02-19-2011, 03:53 PM   #1
Senior Member
Registered: Dec 2005
Location: United Kingdom
Distribution: Fedora , Ubuntu, Slackware-Current
Posts: 1,477

Rep: Reputation: 51
Over my head with this problem - Access the data in .fbd data file

Hello Everyone,

I am posting this here because this seems to be where all of the database questions get asked. We purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base.

The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.

Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd.

My studying suggests to me that I can get into this database with MySQL. I have never used this and have no clue how to do this. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.)

Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started. While a guided tutorial would be nice because I am not an expert, I am willing to learn on my own if someone could point me in the right direction.

Any thoughts or comments are appreciated in advance.

Old 02-20-2011, 10:01 AM   #2
Registered: Oct 2006
Location: Utah
Posts: 520

Rep: Reputation: 61
I'm not sure I can help you, however having said that you might post some of the raw data from your Backoffice.fbd file. That might give us an idea of the structure of the data and somebody might be more able to help you then.


Old 02-20-2011, 10:55 AM   #3
Registered: Aug 2002
Posts: 16,128

Rep: Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866Reputation: 1866
How did you create the fbd file?

I am not familiar with SQL Manager but I expect it to have tools to create queries and export the data to most common formats i.e. csv. If you export the table as SQL insert statements you should be able to import it into mysql.

I have not played with Firebird but you could also install the server on linux and be able to access the database file as is.

Last edited by michaelk; 02-20-2011 at 10:58 AM.
Old 02-20-2011, 01:48 PM   #4
Senior Member
Registered: Dec 2005
Location: United Kingdom
Distribution: Fedora , Ubuntu, Slackware-Current
Posts: 1,477

Original Poster
Rep: Reputation: 51
Thank you for your replies. Since posting, further investigation suggested just that, installing Firebird. I was successful in connecting to this file, but after doing so found that I had only extracted the database structure files, not the data itself. It showed me the table names and structure, but there was no data to be found. I guess I should have realized that when the file I extracted was only 178MB (this database encompasses five years worth of activity in the store.) I recently had to copy the new systems database to a new machine and the file was 24GB.

But, thanks to your help I believe I can find a way to import the data into this file once I find it on the old system.

Thanks again for your help.


Last edited by BobNutfield; 02-20-2011 at 01:50 PM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace data of one column with data on other file corresponding to transaction ID saurabhmehan Linux - Newbie 1 12-23-2010 01:19 AM
[SOLVED] Serial port : Read data problem, not reading complete data anujmehta Linux - Networking 5 09-06-2010 06:10 AM
USB enclosure MySQL data dump and file access bbrian017 Linux - Server 16 02-06-2010 01:19 PM
gnuplot, pull X data from file, specify Y data at cmd line? hedpe Programming 5 03-15-2007 11:32 PM
need to get data from xml file to MySQL database, and then use php to access Armon Linux - General 1 01-18-2006 02:54 PM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 09:55 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration