December 18, 2007

I want you for ...

There should be the Uncle Sam poster here :-), but it is so widely used... I want only to ask if you aren't interested in joining us in kenjutsu, jodo or iaido trainings. This term we have a low attendance in comparison with last year and the recruitment leaflets are still not prepared. You can read more on our webpages.

Some photos by Valor:

Export/import all your database

I have many backlogs at the faculty, the one was new server with user databases and other services. So I spent this Sunday moving them from one server to another. PostgreSQL and MySQL were easy, but I had some problems with installing Oracle 10g on Gentoo x86-64. I made a short notes for me on how to export/import data from them.

With the indentity of user postgres dump all:
$ pg_dumpall -D >pgsql.dmp
On new machine init database under postgres:
$ initdb -E UTF-8 --locale=cs_CZ.UTF-8 /var/lib/pgsql/data
Configure and run database:
$ vim /var/lib/pgsql/data/postgresql.conf
$ /etc/init.d/postgresql start
Recover database under user postgres:
$ psql -f pgsql.dmp

Dump all data:
$ mysqldump -u root -p -A >mysql.dmp
On new server init the data structures, configure and start server and import old data:
$ vi /etc/my.cnf
$ mysql_install_db
$ /etc/init.d/mysqld start
$ mysql -u root <mysql.dmp
(or look at the mysqlimport command)

To export/import Oracle there are exp/imp utilities in $ORACLE_HOME/bin directory.
$ exp file=oracle.dmp full=y
$ imp file=oracle.dmp full=y

December 17, 2007

Moving to Blogspot

Update your RSS reader, please. I'm temporarily moving to Blogspot.

I planned to create my own simple blogging application, because I hate Blosxom for using PATH_INFO. I have already created the backend for loading/saving blog posts from/in data files, but I won't have time to finish that in near future (for reasons which I'll uncover in another blogpost). The Blogspot was a natural choice, because I want to have most online data in Google.

I have imported 4 blogposts from my old blog to see how it works. I'm not very satisfied with the style of writing (but it's only question of time) and I don't like what Blogspot does with images (simple image is than few lines of JavaScript and CSS). Good thing is that pictures are stored in Picasa, but if you delete a blogpost, the pictures still remain there.

I'll try to convert my old design, which I like more than the default ones.