MySQL Forums
Forum List  »  Newbie

Re: ERROR: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
Posted by: Johan Daine
Date: August 29, 2006 04:01AM

I got the same problem, resolved usiong the '--single-transaction' option of
mysqldump. Seems not to be documented on older versions (see below)
johan@nostradamus:~$ mysql -p dev
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21061 to server version: 4.1.11-Debian_4sarge5-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select version();
| version() |
| 4.1.11-Debian_4sarge5-log |
1 row in set (0.00 sec)

mysql> Bye
johan@nostradamus:~$ mysqldump --single-transaction -u bxcms -l -p dev > foo
Enter password:
johan@nostradamus:~$ head foo
-- MySQL dump 10.9
-- Host: localhost Database: dev
-- ------------------------------------------------------
-- Server version 4.1.11-Debian_4sarge5-log

/*!40101 SET NAMES utf8 */;

johan@nostradamus:~$ mysqldump|grep single
johan@nostradamus:~$ mysqldump --version
mysqldump Ver 10.9 Distrib 4.1.11, for pc-linux-gnu (i386)

on Debian Etch
[johand@horus]~ $mysqldump --version
mysqldump Ver 10.10 Distrib 5.0.24, for pc-linux-gnu (i486)
[johand@horus]~ $mysqldump --help|grep -- '--single'
whole dump. Automatically turns --single-transaction and
--lock-all-tables on, unless --single-transaction is
forget to read about --single-transaction below). In all

Hope this helps

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.