Error 1064 with mysqldump
I'm trying to dump the complete MySQL database with the mysqldump command. I've already looked in this forum or in Google, but couldn't find an answer.
Running from an root shell (FreeBSD 6.2):
# mysqldump -u root -h localhost -ppassword --databases "example.org"
mysqldump: Couldn't execute 'use example.org': 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 '.org' at line 1 (1064)
A dump with PHPMyAdmin works, I don't know if that is really related.
Dumping the database, creating a new (empty) database, makes the dump work, but as soon as I restore its contents (from the PHPMyAdmin dump) the 1064 error appears again. The contents consists of a basic Drupal database structure. Other Drupal sites on the same server dump fine.
Server version: 5.1.21-beta FreeBSD port: mysql-server-5.1.21
Edited 1 time(s). Last edit at 08/31/2007 04:06AM by Bram Schoenmakers.
Subject
Views
Written By
Posted
Error 1064 with mysqldump
4877
August 31, 2007 04:05AM
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.