LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 02-19-2011, 04:53 PM   #1
BobNutfield
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.

Bob
 
Old 02-20-2011, 11:01 AM   #2
fordeck
Member
 
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.

Regards,

Fordeck
 
Old 02-20-2011, 11:55 AM   #3
michaelk
Moderator
 
Registered: Aug 2002
Posts: 12,175

Rep: Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784Reputation: 784
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 11:58 AM.
 
Old 02-20-2011, 02:48 PM   #4
BobNutfield
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.

Bob

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


Reply


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 02:19 AM
[SOLVED] Serial port : Read data problem, not reading complete data anujmehta Linux - Networking 5 09-06-2010 07:10 AM
USB enclosure MySQL data dump and file access bbrian017 Linux - Server 16 02-06-2010 02:19 PM
gnuplot, pull X data from file, specify Y data at cmd line? hedpe Programming 5 03-16-2007 12:32 AM
need to get data from xml file to MySQL database, and then use php to access Armon Linux - General 1 01-18-2006 03:54 PM


All times are GMT -5. The time now is 01:09 AM.

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