Server crash need help recovering sugar MYYSQL files

[tnmti]

Ok, so I had some OS coruption on my Redhat server which caused me to have to rebuild the server from bare metal.

I rebuild instead on CentOS5 - no problem

Installed a new copy of Sugar (5.2.0e) and it is fine, but a blank db.

I then mounted the OLD HDD into the server, and now have the 'flat?' my sql files on that HDD. I need to see if I can re-constitute the db if possible form the 'flat' files.

Is there anyone on who can assist? I am willing to PAY if I have to, the data is that important, but also hoping someone who knows MSSQL can assist me.

I am not a linux guy, but a MS guy, this is my only linux server. We use it for cpanel to host web abd mail for a few clients, as well as host out Sugar Server for use by our support dept.

I think I see the old 'flat' files unfer /var/mssql but again am not sure. any assistance woudl be appreciated.

-tim
tlang@tnmti.com

[crmsiva]

Hi Tim

Do you have the MySql db? or Do you want to find the MySql db from the corrupted HDD?

OR

you just want help for moving data from MySql to MSSql ?

[tnmti]

I need help recovering.. not sure where exactly the db is located in hte file system.. /var/lib/mysql I think... I see a TNMTI_SUGARSUITE directory there.. so i think that is it..

I am still on MySQL so want to stay there.. short version ishte server had an OS problem, we build a new bare metal server, installed out cpanel app, and then installed sugar app (5.2.0e) for my company.

I mounted the old HDD in the server and can 'see' all the files that were on that server.. now I need to figure out how to get me old sugar db back. I don;t care if we export accts, contacts, appts, cases from the old to import into the new, or just upgrade the old to the new .2.0e version and then replace. I just need to get to my data. I have SSH and VNC access to the server.

-tim

[tnmti]

ps you can email me directly at tlang@tnmti.com

[crmsiva]

i sent you an email. Plz check