My ubuntu server has crashed.

[Kameelperdza]

Hi i have installed ubuntu 9.04 on vmware server. Im using it as a email,www,irc,ftp,samba,mysql server.

Now i can stil restore the files on the server but will this mean that i have to setup everything again? What i mean is that can i export databases from mysql and then import it to the new server. For example the mail database.

fsck give me a EXT-FS error.

:-(

 

[ruan567]

Try to copy the actual sql files from the directory where they reside. I've done this loadsa times - it works when you have your new system set up and you just dump those files back in the same place.

 

[Kameelperdza]

Thanx so in what folder is all the important files? etc???? var???

 

[s0lar]

Ouch! a crash in a VM? dodgy filesystem/dedicated drive? Anyhow just make sure to preserve the file permissions.

 

[concentricpuddle]

Have you tried repairing the file system?

 

[Kameelperdza]

I tried to run fsck but then i get EXT-FS error and something that dm-0 cannot be found. Then it shows it all the time. When i reboot VM then i get drop to a shell.

 

[concentricpuddle]

I tried to run fsck but then i get EXT-FS error and something that dm-0 cannot be found. Then it shows it all the time. When i reboot VM then i get drop to a shell.

I had a similar error with a problem with a disk. Instead addition /dev/sda* it had /dev/dm*. Mounting /dev/sda* didn't work while mounting /dev/dm* (* greater than 1) did.

Anyway, you dump an MySQL database using mysqldump and restore it using the mysqlimport commands. I'm not sure how to go about using these, so check out the manpages for more info. I don't know if you'll be able to run it with your system borked though.

On my system it seems like the mysql files are stored in /var/lib/mysql. What you do with that knowledge is up to you.