how to view raw mysql file? .myd file ? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

AllenD -> how to view raw mysql file? .myd file ? (7/11/2005 17:13:08)

Hello all, I have been given a .myd (mysql) file that needs to be converted to some other format (excel or access), but I cannot open the myd file, or I cannot find a free viewer that will open the file without setting up a server (which I have no clue on how to do). Does anyone know how I can view the raw file? or is this not possible? If it is not possible, can I setup the mysql locally some how to view the file?

Thanks,
Allen



bobby -> RE: how to view raw mysql file? .myd file ? (7/11/2005 17:29:04)

It's not as fancy an interface as say MS-Access... but if you install XAMPP you can run the MySQL database through Apache web server on your local machine. It also comes bundled with phpMyAdmin that gives you at least some GUI to administer the database file...

http://www.apachefriends.org/en/xampp.html
(I use this at home)

There are 3rd party applications that can transfer data from between Access and MySQL... which may be more of what you're looking for... try Google and see what it comes up with.



AllenD -> RE: how to view raw mysql file? .myd file ? (7/11/2005 17:49:10)

Hmm, not really familiar with Apache, but I did discover this:

http://www.freesql.org

I created a database connection there, but I dont understand how I upload my database to the server so I can make a connection??? Does anyone know?



ou812 -> RE: how to view raw mysql file? .myd file ? (7/11/2005 23:57:04)

I may not understand what you are looking to do, but I would recommend loading up MySQL ( http://dev.mysql.com/downloads/index.html ) on your system and then export (dump) the database ( http://dev.mysql.com/doc/mysql/en/mysqldump.html ) to a file and import to whatever format you need. You should be able to use the install wizard for setting up ( http://dev.mysql.com/doc/mysql/en/installing.html )



AllenD -> RE: how to view raw mysql file? .myd file ? (7/12/2005 12:58:04)

Ok, I downloaded mysql and put the files into a directory under c:\mysql, and I can see the database and the index's, but the entire database is blank? The file is 45 megs, so I know something is in there, I can see the whole structure and everything but no entries?! I did a repair, but that did not help, does anyone have any idea why everything in the database would be blank?



ou812 -> RE: how to view raw mysql file? .myd file ? (7/12/2005 22:59:55)

You can can see the schema information but no data? Hmmm, not really sure at all, especially if repair did nothing. I wonder if the DB is a different version and is having problems with it being too old? I looked around google for some ideas and nothing really popped up. Sorry I can't be of more help, but will be curious to hear what it ends up being. Maybe some others will have some ideas.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875