Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I've used this tool to manage MySQL databases on several hosting sites. Does anyone know how to do this?

share|improve this question
add comment

closed as off-topic by Alex, Jacob Jan Tuinstra, jonsca Feb 8 at 6:23

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "It is a question about creating/developing a web application." – Alex, Jacob Jan Tuinstra, jonsca
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

up vote 3 down vote accepted

In order to track history, you need to enable the "SQL history feature" of phpMyAdmin. You can find details on how to do this on the documentation site.

One thing to note is that the SQL history feature will only track commands entered via the phpMyAdmin interface. If you're looking for specific transaction history on a given table that an application does, you will need to implement some kind of tracking or log feature into the application(s) involved.

Depending on how things are setup, you may be able to access the binary log of the MySQL database itself through phpMyAdmin. You'll need to look into your current database configuration to see where/how to access it.

share|improve this answer
add comment

it's not exactly what you mean but when you go to status tab it gathered some information for you:

you can get some info but not exactly get the time.

share|improve this answer
    
Hmm, I don't have a status tab on mine. Is that something that my hosting provider has to enable? –  Abe Miessler Aug 25 '10 at 0:25
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.