Link to home
Create AccountLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

PHP Query Tools

I have a php database export with some tables I need to remove and check the records in them. Is there a free opensource tool that I can install on my personal PC that will allow me to review the data in those tables. Like something like SQL Server's Query Tool. Free and functional is helpful. Thank you.
ASKER CERTIFIED SOLUTION
Avatar of Dave Baldwin
Dave Baldwin
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of RUA Volunteer2?

ASKER

I have a php database with a partial export of tables not all the tables. It was put in a .SQL file format and the tables were only a few of the original set of tables so instead of getting 200 tables I got a set of 40.

I have a Windows Server and Windows 7 Professional which I would like to be able to open this .SQL file and look at the tables. I do not have a web server that runs on my Win7Pro but I can if that is an easy download and setup. I was thinking that their might be a simpler tool to setup. Rather than what it sounds like a configuration of the webserver and a bunch of stuff like that. Is there something simple to setup that would connect to the php db that came out of my phpmyadmin tool....?

If all else fails I guess I could create a new PHPMYADMIN database and upload the export to it.....? But that does not answer my question of is there a simple desktop type tool....?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If I am trying to establish an ODBC connection and the database is on my machine and the database is on a file path location on my machine. Where would I need to put that in order to get the connection to the database established. Under the Connection Parameters windows. An example would be great as I cannot seem to find one.
Not enough info.  What software do you have installed?  Where are you seeing this?
If you have .sql file you can run the query there.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I have installed the MySQL WorkBench and the MySQL connector or MySQL ODBC. Since I have the file which was originally sent to me in a .DUMP file and I was told to change it to .SQL......and my database is on a file path under C:\Downloads\db427685231.sql. So based on the images below how do I point to the database and how to connect when I use Window7Pro and the one of the tools. I thought it might be like SQL Server you point to the file and it opens......? It does not seem that easy.
MYSQLConnector.png
MySQLWorkBench.png
In MySqlConnector you must put the database name/schema in
Database
field.

In Workbench  you must put the database name/schema in in
Default Schema
field.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I got it it took me a while but thanks to you I got it. Thank you very much. I got some great results from this link. It was very helpful. Once i figured out that I had downloaded the wrong file types and had installed it incorrectly. I was able to decifer the video piece by piece and it works. This video was most helpful as were all the other bits and pieces people contributed.
http://www.youtube.com/watch?v=3_6Pk9e08Ug
Got PHPMyAdmin Installed thanks.
Good, glad to help.  Thanks for the points.