[wellylug] Weird MySQL problem.

[Jethro Carr]

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,

-- 
-- Jethro Carr

jethro.carr at jedolinux.com

http://jethrocarr.jedolinux.com
http://jethrocarr.jedolinux.com/index.php?page=cv/cv.php

http://www.jedolinux.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://lists.wellylug.org.nz/pipermail/wellylug/attachments/20050513/e3448c0a/attachment.pgp