
Hello, I tried upgrading Kubuntu Breezy to Dapper using the "alternative CD" It didn't work particulary well and so I looked at kubuntu.org for information on what to do. The upshot is, in the words of the website, that I have "hosed" my Kubuntu install. Naturally enough I didn't do a backup before had because everything that I had done with Kubuntu in the past had worked fine. I have Suse10 installed on other partitions and I can happily see my kubuntu partitions so the file systems aren't corrupt, its just that Kubuntu won't boot anymore. I'll happily resign myself to a fresh install of Kubuntu Dapper except the only data I don't know how to retrieve is information stored in my phpwiki that relies on MySQL for the content storage. I'd forgotten I had it on my machine but now that I have remembered it I'd really like it back. Is my data recoverable from MySQL? I don't mind if I have to cut and paste everything back into the wiki. It doesn' contain heaps of data but it does contain some techobabble gems and I would like to recover them if possible. Is it doomed?

The upshot is, in the words of the website, that I have "hosed" my Kubuntu install.
Fixing it is probably not all that hard. Do you know what in particular is "hosed"? It could be all you need to do is fix your boot loader, and then everything will work fine.
I have Suse10 installed on other partitions and I can happily see my kubuntu partitions so the file systems aren't corrupt, its just that Kubuntu won't boot anymore. I'll happily resign myself to a fresh install of Kubuntu Dapper except the only data I don't know how to retrieve is information stored in my phpwiki that relies on MySQL for the content storage. I'd forgotten I had it on my machine but now that I have remembered it I'd really like it back.
Yes, by a couple of methods: if you can mount the partition, you can possibly chroot to it, and run mysqldump to back them up. If not, you can copy /var/lib/mysql/phpwiki/* somewhere, and then put the directory back on your new installation of mysql, set the owner user/group back to 'mysql' and the permissions the same, and it should pick up the database again. Craig

Is my data recoverable from MySQL? I don't mind if I have to cut and paste everything back into the wiki. It doesn' contain heaps of data but it does contain some techobabble gems and I would like to recover them if possible.
Is it doomed?
It sounds to me like your data is still 100% recoverable. You can most likely bring your kubuntu install up in textmode using the older kernel (which should still be installed) and then do a mysqldump of the data. For the rest, it's probably easiest to back up /home and anything else you want to keep, and do a clean reinstall.

Thanks guys for your confidence in being able to retrieve the data. I have an external usb hard drive now and I am backing everything up before attempting any more upgrades to dapper etc. On 09/06/06, zcat <zcat(a)wired.net.nz> wrote:
Is my data recoverable from MySQL? I don't mind if I have to cut and paste everything back into the wiki. It doesn' contain heaps of data but it does contain some techobabble gems and I would like to recover them if possible.
Is it doomed?
It sounds to me like your data is still 100% recoverable. You can most likely bring your kubuntu install up in textmode using the older kernel (which should still be installed) and then do a mysqldump of the data.
For the rest, it's probably easiest to back up /home and anything else you want to keep, and do a clean reinstall.
_______________________________________________ wlug mailing list | wlug(a)list.waikato.ac.nz Unsubscribe: http://list.waikato.ac.nz/mailman/listinfo/wlug
participants (3)
-
Chris O'Halloran
-
Craig Box
-
zcat