“mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, and LOCK TABLES if the –single-transaction option is not used. Certain options might require other privileges as noted in the option descriptions.”
– http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html
July 23, 2013
mysqldump privileges required
July 17, 2013
Where’s my line?
mysql -e "select * from test.t where d < '2013-07-17 17:00:00'" +---------------------+ | d | +---------------------+ | 2013-07-17 15:34:19 | +---------------------+ mysqldump -t --compact test t --where="d < '2013-07-17 17:00:00'" (no output)
Where's my line?