Hi all.
I've been testing out mysql-5.0.10 on my Powerbook ( Gentoo Linux PPC ),
and I've hit an incredibly unfortunate bug. It is demonstrated
adequately with the following:
mysql> use entropy;
Database changed
mysql> show tables;
ERROR 1052 (23000): Column 'TABLE_NAME' in order clause is ambiguous
mysql> quit
Bye
[EMAIL PROTECTED] ~ $ mysqldump -u root --opt --all-databases > full_dump.sql -p
Enter password:
mysqldump: mysqldump: Couldn't execute 'SHOW DATABASES': Column
'SCHEMA_NAME' in field list is ambiguous (1052)
[EMAIL PROTECTED] ~ $
I can't get anything out of the DB with any GUI tools. I assume they all
want to inspect the tables and bail out when they hit something like the
above.
The data is still there, and I can select from tables that I already
know the name of ( which, luckily, I do ... for the important stuff ).
So I suppose I don't *really* need any help in backing stuff up - I can
back up table by table to text files and then re-import.
Is anyone interested in examining what went wrong? ie should I create a
bug report? I suppose I'd have to upload a zipped copy of my
/var/lib/mysql folder or something, since mysql isn't too keen on giving
up any data voluntarily.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
