I've recently upgraded my ubuntu server and it's buggered up, typical! The upgrade process failed, I think, due to the fact that I appear to have "gained" a database called '#mysql50#.gnome' which I can't delete, rename or fix. Any tips?!
Chat Forum
[closed]
MYSQL admin help!
-
Posted 1 year ago #
-
All the fun of trying to do an upgrade eh? Usually easier to wipe and install the new distro fresh!
Sorry can't be of any help, if it screwed up part way might just be easiest to wax the partition and start again?
Posted 1 year ago # -
Everything else has been fine, it just seems to be mysql that's hosed.
Posted 1 year ago # -
Do you have root access to mysql?
Any errors in the logs why you can't delete/rename/fix?
Can you do a SQL dump, then remove the current MySQL.... remove.... install new version.... restore SQL dump?
Posted 1 year ago # -
I've got root access and the only place the odd name appears to show its face is the list of database names, there's nothing in the data dir unlike the other databases. I've got a series of backup dumps, I could remove and re-install but I have a feeling it'll drop a whole heap of other packages on the way, which is a bit of a pain.
Nothing in the logs other than to say "incorrect database name" when I try any operation on it.
Posted 1 year ago # -
Upgrade to Windows?
Posted 1 year ago # -
never heared of that, translated this page but seems to have lost a lot in translation; http://translate.google.co.uk/translate?hl=en&sl=zh-CN&u=http://www.pusuo.net/2009-09-15/110802173.html&ei=4gGvTbifJomqhAex6tjdAw&sa=X&oi=translate&ct=result&resnum=2&ved=0CCgQ7gEwAQ&prev=/search%3Fq%3D%2522%2523mysql50%2523.gnome%2522%26hl%3Den%26safe%3Doff%26prmd%3Divns
Posted 1 year ago # -
Think I've sussed it, it was a hidden .gnome# folder with at and crontab subdirs, tracked it down and removed it and it seems to pass tests now.
I'd install webmin (it's in the repos) and do it all from a GUI.
I was happy from the cli, but webmin didn't play ball either
Posted 1 year ago # -
strange directory to end up in the datadir though
Posted 1 year ago # -
I was happy from the cli
Crikey, the best I ever feel when using the cli is 'moderately disheartened'!
Glad you were able to track the problem down.
Posted 1 year ago # -
Crikey, the best I ever feel when using the cli is 'moderately disheartened'!
That was something of a keyboard warrior bravado, I have been sat here for 10 minutes trying command options to be fair!
Posted 1 year ago # -
geoffj - Member
Upgrade to Windows?Good idea. Let's go one better, and upgrade to OSX....
Posted 1 year ago # -
Better idea, I keep with what I know and what has absolutely shedloads of free advice online...
Posted 1 year ago # -
coffeeking - Member
Better idea, I keep with what I know and what has absolutely shedloads of free advice online...and is FOSS
Posted 1 year ago # -
indeed! Thanks to all those who've contributed, for free, however minor.
Posted 1 year ago # -
Good idea. Let's go one better, and upgrade to OSX....
Indeed
Posted from my iPad
Posted 1 year ago #
Topic Closed
This topic has been closed to new replies.
