[Gllug] MySql problem...

[Alistair Mann]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Thus spaketh Kristian Davies on Tuesday 20 May 2003 3:42 pm:
> I have managed to get mysql up and running and I have created a few
> tables... But.... I seem to have done something I shouldn't and it seems to
> have let me..
>
> I have created a field within a table with a dot in it. i.e.. Within Table
> "users" a field called "user.name" instead of "user_name"
>
> When I open the table for edit, it allows me to press delete and it
> disappears but then when I try an exit I get "[MyHost] ERROR 1091: Can't
> DROP 'name'. Check that column/key exists" and thus it wont let me save.  I
> have also tried a few things from the command line which more or less give
> the same error.
>
>
> Anyone able to help ?

MySQL tables are commonly held in 

"/usr/local/mysq/var/<database name>/"

With three common files "table.frm", "table.MYD" and "table.MYI"

I suggest you rename these three by hand to remove the errant dot. If you 
can't find the tables in the place above, as root do:

find / | grep ".MYD" 

and it should (eventually!) show you where they all are. 

Cheers,
- -- 
Alistair
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE+yqW6Ez+/jt85AfsRAoFJAJ9MSnb+Wtn4k/26D9x6b0q4an7DFwCfWWEG
MmQqXrvXpokrbIlpewqE/Uk=
=rOv5
-----END PGP SIGNATURE-----



-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug