If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > See SQL Sent To MySQL

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-18-11, 09:25
pinkfloyd43 pinkfloyd43 is offline
Registered User
 
Join Date: Dec 2010
Posts: 39
See SQL Sent To MySQL

Working on a system where I don't have the source code and migrating to new system. As there a literally 100's of tables in the source it's hard to figure out what is going on.

I am looking for a tool that will display SQL calls to the database so I can test a particular form process and see exactly what is happening within the database.

Thanks,
Jim
Reply With Quote
  #2 (permalink)  
Old 02-18-11, 11:59
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 623
Hi,

MySQL allows you to record SQL statements from all clients. Check out the General Query Log MySQL :: MySQL 5.1 Reference Manual :: 5.2.3 The General Query Log If this is not enough a nice tool for developers and designers is MySQL Workbench - which might help in understanding the data model?
__________________
Ronan Cashell
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #3 (permalink)  
Old 02-22-11, 16:11
pinkfloyd43 pinkfloyd43 is offline
Registered User
 
Join Date: Dec 2010
Posts: 39
Thanks, perfect exactly what I needed thanks again!!!!!!!!!
Reply With Quote
Reply

Tags
monitor sql calls

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On