Playing mp3 File on linux sever (And convert MDB file to txt)

I'm back,

Work has been quite busy recently that I haven't had time to post any new discoveries.

So I will start slow with some personal needed tricks I picked up recently and then I'll add a work related process.

First up.

I wanted to be able to start a mp3 file on my home computer from work.

Problem : I only have access via ssh protocol.

I found a few ways to stream the file to my work computer using vlc, but that was not what was needed and will eat my bandwidth, not what I want.

Solution : Use mpg123

So you just ssh into the server and command is :

mpg123 song.mp3

Gave my girlfriend a fright when music started blaring out of my home computer, ha ha.

Next a simple work related process.

I received a .MDB file from a client. (Access database file)

So as I run Linux I did not have and do not want to have Access installed on my PC.

Therefore I needed to convert file into a better usable format.

Solution : Use mdbtools

Steps to follow are install mdbtools with :

sudo apt-get install mdbtools

Then once completed you need to run this to see what tables are within the file with :

mdb-tables file_1.MDB

Then using the result of the above command execute this to export the file to text :

mdb-export file_1.MDB Table_Name

Done.

Have a good weekend and I hope this is usefull to someone else one day.