Solved

PHP Query Tools

Posted on 2013-05-23
14
224 Views
Last Modified: 2013-05-31
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.
0
Comment
Question by:ruavol2
  • 5
  • 5
  • 2
  • +1
14 Comments
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 300 total points
Comment Utility
What do you mean by 'php database export'?

If you have a web server that runs PHP, you can install phpMyAdmin http://www.phpmyadmin.net/home_page/index.php .  If not, you can install MySQL Workbench http://www.mysql.com/products/workbench/ .
0
 

Author Comment

by:ruavol2
Comment Utility
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....?
0
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 300 total points
Comment Utility
I'm assuming you're here because the files came from a MySQL database.  Note that they aren't "PHP databases" but more likely exports from MySQL.  "*.SQL" files are text files that can be viewed in Notepad or a better code editor like Notepad++ or PSPad.  Don't use Word, it will corrupt the files if you accidentally save them.

To actually manipulate them as database tables instead of text, you would need to install MySQL on your computer and import them into a database and use one of the tools that are available.  Without the webserver, MySQL Workbench would be a simpler choice because it can talk to the MySQL database server directly.  In any case other than viewing them as text, it is not going to be a one-step procedure.
0
 
LVL 15

Assisted Solution

by:Jagadishwor Dulal
Jagadishwor Dulal earned 100 total points
Comment Utility
Install tools like HeidiSql and mysql which can manage your requirement.

http://www.heidisql.com/
0
 

Author Comment

by:ruavol2
Comment Utility
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.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
Not enough info.  What software do you have installed?  Where are you seeing this?
0
 
LVL 15

Expert Comment

by:Jagadishwor Dulal
Comment Utility
If you have .sql file you can run the query there.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Assisted Solution

by:RuiSimoes
RuiSimoes earned 100 total points
Comment Utility
You can use http://www.squirrelsql.org/  but you have workbench from MySql http://www.mysql.com/products/workbench/.
0
 

Author Comment

by:ruavol2
Comment Utility
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
0
 

Expert Comment

by:RuiSimoes
Comment Utility
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.
0
 
LVL 82

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 300 total points
Comment Utility
You have to install the MySQL Server to use those tools.  Then you can import C:\Downloads\db427685231.sql into the MySQL server.  C:\Downloads\db427685231.sql is not a working database but a file that you can import into a MySQL server database.

MySQL Workbench does not need the ODBC connector when you install the database server on that same machine.  Workbench will connect through named pipes on the localhost which is something you do not have to setup.
0
 

Author Comment

by:ruavol2
Comment Utility
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
0
 

Author Closing Comment

by:ruavol2
Comment Utility
Got PHPMyAdmin Installed thanks.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
Good, glad to help.  Thanks for the points.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now