When my server was running MySQL 4.1 I used mysqldump for backup with no
errors - Redhat Linux 9. In fact when the server crashed and I had to
restore the whole box I used the backups from mysqldump to restore all
the databases and tables including the users. However, the server is now
running MySQL 5.0 on Redhat Linux 9.
When I try to run mysqldump I encounter errors as shown below:
[mysqldump -p -u eusers mysql]
--
-- Dumping data for table `columns_priv`
--
/*!40000 ALTER TABLE `columns_priv` DISABLE KEYS */;
LOCK TABLES `columns_priv` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `columns_priv` ENABLE KEYS */;
mysqldump: mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE
'columns\_priv'': You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the
right syntax to use near 'TRIGGERS LIKE 'columns\_priv'' at line
1 (1064)
Does anyone know what is happening here? What am I doing wrong?
--
Peter ___________________________________
Life is not measured by the number of breaths we
take, but by the moments that take our breath away.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
