how to view raw mysql file? .myd file ?

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

how to view raw mysql file? .myd file ?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> how to view raw mysql file? .myd file ?

Page: [1]


AllenD Posts: 258 From: Dayton, OH, USA Status: offline	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 Posts: 11394 Joined: 8/15/1969 From: Seattle WA USA Status: offline	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. _____________________________ If con is the opposite of pro, is Congress the opposite of progress? (in reply to AllenD)


AllenD Posts: 258 From: Dayton, OH, USA Status: offline	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? (in reply to bobby)


ou812 Posts: 1565 Joined: 1/5/2002 From: San Diego Status: offline	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 ) _____________________________ -brian EnterpriseDB: Enterprise-class relational database management system PostgreSQL: The world's most advanced open source database (in reply to AllenD)


AllenD Posts: 258 From: Dayton, OH, USA Status: offline	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? (in reply to ou812)


ou812 Posts: 1565 Joined: 1/5/2002 From: San Diego Status: offline	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. _____________________________ -brian EnterpriseDB: Enterprise-class relational database management system PostgreSQL: The world's most advanced open source database (in reply to AllenD)

Page: [1]

All Forums >> Web Development >> ASP and Database >> how to view raw mysql file? .myd file ?

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts