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 :-)
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.
Thanks!
I will check them when I can mount it again.
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….
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 :-)!