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 > Finding MySQL Administrator log files

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-06-11, 17:33
melgra70 melgra70 is offline
Registered User
 
Join Date: Mar 2011
Location: Sydney, Australia
Posts: 58
Finding MySQL Administrator log files

I have set the startup variables in as Querymydb; Errormydb and Updatemydb, with the Binlog Options set as Log updates for mydb. The Option File chosen as the default was C:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini
I have examined that directory and the log files aren't there.
I've done a global search on *mydb*; I've examined many folders, including the Windows installation directory as suggested in the Administrator Help menu.
However, I've not been able to find any logs by these file names.

I'm not sure whether the fact that I'm running through Wamp Server would cauase any changes of location, but I assumed that the Option File location indicated by Administrator would be where I would expect to find the files.
Are there any suggestions as to anywhere I can look to find the logs I need to submit? Has anyone else experience this?
Reply With Quote
  #2 (permalink)  
Old 10-07-11, 03:46
it-iss.com it-iss.com is offline
Registered User
 
Join Date: Sep 2009
Location: San Sebastian, Spain
Posts: 620
What exactly have you put into the my.ini and under which section?

As for the log files. This is what I found in the manual:

To enable the binary log, start the server with the --log-bin[=base_name] option. If no base_name value is given, the default name is the value of the pid-file option (which by default is the name of host machine) followed by -bin. If the basename is given, the server writes the file in the data directory unless the basename is given with a leading absolute path name to specify a different directory. It is recommended that you specify a basename.

So look for the process identifier followed by -bin
__________________
Ronan Cashell
Senior Oracle/MySQL DBA
http://www.it-iss.com
Reply With Quote
  #3 (permalink)  
Old 10-08-11, 03:59
melgra70 melgra70 is offline
Registered User
 
Join Date: Mar 2011
Location: Sydney, Australia
Posts: 58
Finding MySQL Administrator log files

Thanks, Ronan.
The my.ini file that I mentioned is the location of the Option File on the Startup Variables screen in Administrator, which shows as:
C:\Program Files (x86)\MySQL\MySQL Server 5.1\my.ini
I didn’t actually do anything that I was aware of to create or affect this file.

I had a look at the General Parameters on the Startup Variables screen.

Base directory is:
C:/Program Files (x86)/MySQL/MySQL Server 5.1/
Data directory is:
C:/ProgramData/MySQL/MySQL Server 5.1/Data/

When I went into this data directory, I found the three files that I had been looking for, the names of which I had set up in the Log Files screen. I assume these files were created by my backup process through the command line prompt:
Querymydb
Errormydb
Updatemydb

However, I still have a problem: As a second step I was required to process a new backup and restore through MySQL Administrator this time, changing the names of the files to in the Startup Variables screen, which I did, saved and closed both Administrator and the MySQL Server:
QuerymydbB
ErrormydbB
UpdatemydbB

Having successfully processed the second backup and restore, I am unable to now find these later log files anywhere, including in the program data directory above where I found the first files. I’ve checked all the bins in the MySQL and MySQL Server 5.1 directories.

We don’t have any instruction about creating binary logs, and I’m unfamiliar with this type of process and its purpose.
Reply With Quote
Reply

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