Weekend of disaster

Yesterday, my precious qube3 crashed. Does not want to boot anymore and no power at the board. (smoke!!)
We tried a second qube (yup we have a spare now) but swapping the harddisk did not solve the error.
No idea what is the cause .. I have one idea, but that can only be checked if I can access the Harddisk again.

The spare Qube3 is a development qube where we noticed that a normal internet connection is not possible and running a normal webserver is total out of the question. So we have to restore this little thing with an Intel / 3Com nic.

Meanwhile my collegue Pieter searched for a tool to access the ext2fs filesystem under XP. Pieter searched and found: Ext2fsd. As the ext2fs is journalized, I have only read-access. But lucky as we are we managed to save all our: images, websites etc..

The only trouble is the mysql databases. No idea how to retrieve those when you cannot run mysql anymore.

We are happy to see the sun again :-)

4 thoughts on “Weekend of disaster

  1. Bob says:

    Mysql databases _are_ saved as files. If you can access the filesystem, just backup the files. When you get your new system running, recreate the same databases, shut down mysql and replace the files. This might not be the most ‘clean’ way to do it, but for me it worked..

    The files on my system are in /var/lib/mysql/ , or just search for the database names.

  2. see //mysql

    and *please* make a backup of your database on dayly bases and if you are smart, pump it to another server by using weex.

    something like this:

    #!/bin/sh

    echo “doing ini stuff…”
    username=”user”
    database=”database”
    password=”password”
    hostname=”127.0.0.1″
    path=”/path/”

    echo “making msql dunp…”
    # /usr/bin/mysqldump -h $hostname -u $username $database > $path/backup-`date +”
    %Y%m%d”`.sql
    /usr/bin/mysqldump -u $username -p$password $database > $path/backup-`date +”%Y%
    m%d”`.sql
    echo “gzipping dumpfile”
    /usr/bin/gzip $path/backup-`date +”%Y%m%d”`.sql

    echo “removing vandaag dir…”
    rm -rf path/vandaag
    echo “making vandaag dir…”
    mkdir /home/pimsbb2/willybak/vandaag
    echo “copy-ing latest mysqldump to vandaag dir…”
    cp $path/backup-`date +”%Y%m%d”`.sql.gz /vandaag/vandaag/backup-`
    date +”%Y%m%d”`.sql.gz
    echo “syncing vandaag dir with xs4all…”
    /usr/local/bin/weex xs4all -s
    #note you have to configure weex as well
    echo “done!”

    note: it is a stupid script, i should check if vandaag exists and then redo stuff, yet it works….

  3. Sander says:

    Good luck !

    My site looks empty now :-)

    I think you had some kind of power failure ? Are you using a UPC power protection? Could be usefull (ook in nederland tegenwoordig :-)!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.