Viewing mySQL Files

T

texas_amy

Registered Member

Jun 24, 2008

60

8

• Oct 1, 2009

• #1

who knows a free viewer to inspect the content of a mysql database?

 

neo

Power Member

May 5, 2007

792

672

• Oct 1, 2009

• #2

If it is a .sql file backup on your harddisc you can right click open it with notepad. However you won't get a clean view and if the size is too big notepad will hang.

If it is already on your server, use phpMyAdmin to view and edit the database.

 

IamNomad

Junior Member

Mar 27, 2009

135

23

• Oct 1, 2009

• #3

I believe youre looking for phpmysql. its an opensource web based package allows you to view, delete and manipulate your databases.

Be careful it is a very powerfull tool. logging in with your admin rights and clicking hte wrong button can cause you to permenantly loose youre data

 

onegg

Junior Member

Dec 12, 2007

152

178

• Oct 1, 2009

• #4

navicat is what you are looking for.

 

mrjinx

Regular Member

Nov 10, 2008

323

297

• Oct 1, 2009

• #5

phpmyadmin, navicat or SQL Maestro.

I have these so let me know what you need

jinx