Now were did I put that time machine project…

So after a poor link line I will now get on with the actual content of Ta Ta Tadaaa…. Backing Up Our Data, lights flicker, in the distance a dog barks, pan to eerie face briefly illuminated by moonlight. Anyway, this will consist of backing up:

• The Photographs.
• The Photograph Gallery .
• The SQL Databases
• FrownyBaby
• DizmalBlog
• Wiki

So, photo’s and gallery first. This is simply a matter of archiving the directories onto a DVD. I create a tempry directory with symlinks to the base of all the directory tree’s I want to include and use the mkisofs option to follow symlinks.

e.g.

mkdir tmp; cd tmp
ln -s /media/photos; …
growisofs -Z /dev/dvdrw -J -R -f .

To append more data use the -M option rather than -Z

Alternatively I could just use Nautilus but that would be dull

Next comes the databases. I have little interest in databases. Everytime I try and learn enough about them to get around I start to dribble and then get distracted. So, in order to combat this I am going to document to myself enough information to get around and backup the data. I know this is going to be easy but I always forget everything I try to learn about databases.

So, first of all I am using MySQL as all developers support this one so all Web based information storage sites are based around it. So, what users have I created whilst installing the blogs and wiki sites?

mysql -u root -p –database=mysql
select user, host from user;

Okay I seem to have more users than I need but then thats because i didn’t know what I was doing. Anyway, three of them are regularly used. So, looking around the most obvious way that bounces straight out would be to use mysqldump to dump all databases as the root user. This would dump all tables (which would included the user account tables) in a format ready to import into another SQL database. Brilliant.

mysqldump -u root -p –all-databases > .sql

To import this data back into the database should just be

mysql < .sql

And this is the same paragraph in a blockquote. This is a check to examine how Wordpress implements the blockquoted text. This is a blockquote paragraph.

This is a check to examine how Wordpress implements the blockquoted text. This is a normal paragraph.

There, probably not the best entry you have ever read but it gets to the point.

I could talk more but there is plenty of information here if you are interested.

It may seem like I have gone post mad, but the previous couple of posts are just some drafts that I have had hanging around for a while wondering what to do with them. in the end I have just published them so I can move on and just reference them if I need to.

I currently use dvdshrink to extract the data. I have not yet found the equivalent command line utilities for Linux, though it is an agenda item of mine to find out what it does.

To write the pre-formated ISO data image:

growisofs -dvd-compat -Z /dev/dvd=image.iso

For now I am going to place this stuff in the sites pages and see how I get on.

I need to become the type of person who talks to everyone, but how?