Re: how to transfer data from mysql to excel or MS SQL database or any readable format

[Mike Williams]

just to provide more information let me explain you how i get this backup file:

we are using a software since few months and soon we are switching to a new software so we want to keep a backup of all the records in the current software, that is the reason i want to convert this backup file into readable format

Now coming back to backup file, the software company installed a different dos software that is connected with the database of the software we are using currently, and this dos software is used to take a backup of current database

In order to get the backup, what i do > i just have to go open the software and click on button "Back Your Database" - as soon as i click the button, it run a number of commands in dos prompt (black screen appears) and within few seconds a backup.data file is generated in the output folder.

I don't have any experience with mysql so don't know what is the format of this backup files that's why iam telling you about the extension - the extension of this file is ".data"

i have no idea what exactly is there in the backup file as it is being generated with a software thru dos commands(i notices when thes dos commands are running in dos prompt there are few linux commands too)

That's all i know about the backup file and that's the best explaination i can provide you about it.

the software is online based i mean it is linked with the software company
so we don't have anything at our end
the software company manages the database and everything
the dos software that they provided is also linked with the database at their end, so when we take a backup it gives a back file to us in our machine

Hope it helps