This is what I think hit me too, Daniel. Unfortunately, it's not on my own server (a hosting provider), so my access to the shell is very limited.
My website is still running, but, I can't export the database using phpMyadmin anymore, because the troubled table is on the first list of tables. Do you have any idea on how to save my other tables? Thanks. Fajar On Tuesday 09 August 2005 08:16 am, Daniel Kasak wrote: > 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 -- Fajar Priyanto | Reg'd Linux User #327841 | http://linux2.arinet.org 00:25:04 up 59 min, Mandrakelinux release 10.2 (Limited Edition 2005) for i586 public key: https://www.arinet.org/fajar-pub.key -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
