[wellylug] Weird MySQL problem.

[Martin Wehipeihana]

Hi Jethro,

It could be that you have used MySQL reserved words as names for columns 
in your tables. In which case you need to add the allow-keywords option 
to mysqldump

eg:

mysqldump -u$userid -p$passwd --add-drop-table --allow-keywords $database

HTH

Martin Wehipeihana

Jethro Carr wrote:
> hi all,
> 
> 
> I had to reinstall my linux machine. (I was deleting windows from my
> last machine that had a copy, to gain a nice 9GB on a 20GB drive,
> however I had to recreate all my partitions to utilize this space.).
> 
> To backup my mysql database, I did what I usually did, and used
> mysqldump to get a complete backup of all databases.
> 
> Normally, to restore it I use 'mysql < BACKUPFILE.SQL'. However, for
> some strange reason when I try to do it now, I get the error message
> below:
> 
> -----------------------------------------------------------------
> [root at amber sqlbackups]# mysql < sqlbackup-01-05-05.sql
> ERROR 1064 at line 19: 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 '-comments (
>   id int(11) NOT NULL auto_increment,
>   date dateti
> [root at amber sqlbackups]#
> -------------------------------------------------------------------
> 
> It's not the file - I've tried importing the wellylug database from the
> website and that gets the same error too.
> 
> 
> I've found another problem to:
> I added a database by hand to see if that could work, but now I can't
> remove it. phpmyadmin says that it succeds, but it doesn't get removed
> from the list. !??!?!??!??!?!?!
> 
> 
> 
> I'm lost & depressed. :-(
> 
> 
> anyone have any ideas what might be up?
> 
> thanks,
>