• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Electric Toolbox Blog

The Electric Toolbox Blog

Linux, Apache, Nginx, MySQL, Javascript and PHP articles

  • Applications
  • FCKEditor
  • Apache
  • Windows
  • Contact Us
Home / Suppress the “skipping the data of table mysql.event” message

Suppress the “skipping the data of table mysql.event” message

When using the mysqldump command to make a back of the mysql database, you might get the message “Warning: Skipping the data of table mysql.event. Specify the –events option explicitly”. This post shows how to suppress this message.

How to suppress the message

How to suppress it is given in the message: simply add –events to the command. If you were doing this, for example:

mysqldump -u root -p mysql > mysql.sql

simply add –events like this:

mysqldump --events -u root -p mysql > mysql.sql

Easy! This is useful if you are doing automated backups and do want to see error messages, but not this particular one every time a backup is done.

Other databases

Note that when using the same command & flag on other databases, you’ll see this output for each database you dump:

--
-- Dumping events for database '[database]'
--

So if the other databases do not have events, and you want to prevent this output from being displayed, then don’t use the –events flag for those dumps.

Check Out These Related posts:

  1. Backing up MySQL with mysqldump
  2. Using mysqldump to save data to CSV files
  3. Load data into MySQL with foreign key constraint issues Part 2
  4. Warning: Skipping the data of table mysql.event

Filed Under: MySql

Primary Sidebar

Categories

  • Apache
  • Applications
  • Article
  • Case Studies
  • Email Servers
  • FCKEditor
  • HTML And CSS
  • Javascript
  • Linux/Unix/BSD
  • Microsoft SQL Server
  • Miscellaneous Postings
  • MySql
  • Networking
  • Nginx Web Server
  • Offsite Articles
  • OSX
  • PHP
  • Quick Tips
  • RFC – Request for Comments
  • SilverStripe
  • VMWare
  • VPN
  • Windows
  • WordPress

Recent Posts

  • Vim Show Line Numbers
  • Add User To Group Linux
  • Chmod 777 Tutorial
  • How to Copy Directory Linux
  • Linux create user

Copyright © 2021. ElectricToolBox. All Rights Reserved.

  • Contact Us
  • Copyright Info
  • Privacy Policy
  • Sitemap