Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > PHP/MySQL > BOOK: Beginning MySQL
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning MySQL
This is the forum to discuss the Wrox book Beginning MySQL by Robert Sheldon, Geoff Moes; ISBN: 9780764579509
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning MySQL section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old November 13th, 2009, 07:50 PM
Registered User
Join Date: Nov 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Log Files (on Ubuntu) - Chapter 13 P. 506

I'm sitting on Ubuntu 9.04 with MySQL 5.0.75 installed.
The book states that error logging is enable by default and that the file called <host>.err is located in the data directory (on Ubuntu, that would be /var/lib/mysql) but this seems to be incorrect.
There is no such file in that directory and the only .err file that I can find on the system is a file called mysql.err located in the /var/log directory.
This file is empty and is not populated once I execute an erroneous command such as DROP USER noneexistinguser; It remains empty no matter what happens with MySQL.

So I added (like the book suggests) log-error=localhost.err which indeed created a file by that name, but it only contains when the server started and when it was shut down, and not the erroneous command. I assumed that the default behavior would be this since the example in the book has logged an attempt to remove a user that does not exists.

Furthermore, Query Logging records events such as server startup and shutdown. Since the localhost.err file I just created does exactly this, what is the point of the .err file?

Anyone care to enlighten me?

Last edited by MockY; November 13th, 2009 at 07:55 PM.
Reply With Quote

Thread Tools
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 Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Chapter 13 Error Psyclist BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 12 February 15th, 2010 06:49 PM
VB Tools.Log error, Chapter 13 Roosker BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 0 February 14th, 2009 01:08 PM
LINQ Error ? Chapter 13 workidoo BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 July 22nd, 2008 09:37 AM

All times are GMT -4. The time now is 06:04 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.