Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

Finding Mysql error log

Im running  Windows7 / Mysql5.1
According to various pages the error log should be in: /usr/local/mysql/bin/mysql
However, this partial path name is flawed. When I use "search everyting", I dont even have a folder name usr... Can someone provide a complete and working path to the MySql ERROR log?
0
Paer Toernell
Asked:
Paer Toernell
  • 5
  • 2
  • 2
1 Solution
 
PapertripCommented:
According to various pages the error log should be in: /usr/local/mysql/bin/mysql
That's a Unix/Linux path to the mysql binary ;)

Check this out:
http://dev.mysql.com/doc/refman/5.1/en/windows-installation-layout.html
0
 
maeltarCommented:
You done have /usr on a windows platform, that is for  a unix based OS..

Do a search for my.cnf or my.ini in there it will tell you that file the  location of the log files, they are normally in the data directory...

You are looking for sothing similar to :
datadir="D:/xampp/mysql/data"
log_error="mysql_error.log"

Open in new window



Or use :

SHOW VARIABLES LIKE '%log_file%';

Open in new window

0
 
maeltarCommented:
@Papertrip

Im running  Windows7 / Mysql5.1
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
PapertripCommented:
@Papertrip

Im running  Windows7 / Mysql5.1
That's why I pasted a link to the MySQL 5.1 Installation Layout on Microsoft Windows.
0
 
Paer ToernellAuthor Commented:
Yeah, now i find the folder - but where is the error log where queries witch resulted in an error is stored?
0
 
maeltarCommented:
Sorry Papertrip, it's early and not enough coffee yet....
0
 
maeltarCommented:
You should have a file in the /data directory mysql_error.log
0
 
maeltarCommented:
Oh wait, you want to see the error that the queries returned ?

That is not the place to look....

Post the bit of code you are having problems with and will help out
0
 
Paer ToernellAuthor Commented:
The error i can see, but i need to know the exact MYSQL code that generated the error. Im using Mydac from Devart to send Mysql code from Delphi and in this case I cant see exactly what code is sent - so i want to solve this from the "other side" and see exactly what code Mysql receives.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now