backup a mysql table

Take a backup:
mysqldump -p database_name table_name >some_file.sql


Restore:
mysqldump -p database_name <some_file.sql

debian 6 update

omg, dist-upgrading my system didn't use to be this hard?... Or so I remember.
This new update for some reason made my happy hacking lite 2 keyboard mapping crazy (maybe reseted it), I had my meta and alt key to work the same, because I don't need to have two keys where I think there should be only one! But now even telling xmodmap to work the same it ignores me...

ah... I've been updating for 3 days now. Every time there're some packages left.

Edit:
It took me 3 or 4 days^^ to totally dist-upgrade.
udev is giving me problems (can't change permissions for devices in the /dev dir...), the monospace fonts changed, mplayer-snapshot stopped working, and for some reason my xclock looks weird... But I guess that's as bad as it gets, all the rest seems to work OK.

CREATIVE SoundBLASTER 5.1VX in GNU/linux

I finally got it working! I remember I tried for weeks a few years ago, and now that my USB sound card broke, tried again, and worked!!!

I'm using Debian.
Taken from here:

1. Download OSS from here (select your architecture and package -> DEB if you're using debian or ubuntu)
2. Install the downloaded package.
   (something like:)
   sudo dpkg -i oss-linux-4.2-2004_i386.deb
   
   
   Something like this will appear in your screen:
   

   Selecting previously deselected package oss-linux.
   (Reading database ... 192851 files and directories currently installed.)
   Unpacking oss-linux (from oss-linux-4.2-2004_i386.deb) ...
   Shutting down ALSA...done.
   Unloading ALSA sound driver modules: snd-ca0106 snd-ac97-codec snd-opl3sa2 snd-opl3-lib snd-hwdep snd-cs4231-lib snd-pcm-oss snd-mixer-oss snd-pcm snd-mpu401-uart snd-seq-dummy snd-seq-oss snd-seq-midi snd-rawmidi snd-seq-midi-event snd-seq snd-timer snd-seq-device snd-page-alloc.
   Setting up oss-linux (4.2-2004) ...
   Building OSS Modules for Linux-unknown 2.6.26-2-686
   
   OSS build environment set up for REGPARM kernels
   
   Building module osscore
   Building module lynxone
   Building module lynxtwo
   Building module oss_ali5455
   Building module oss_atiaudio
   Building module oss_audigyls
   Building module oss_audioloop
   Building module oss_audiopci
   Building module oss_cmi878x
   Building module oss_cmpci
   Building module oss_cs4281
   Building module oss_cs461x
   Building module oss_digi96
   Building module oss_emu10k1x
   Building module oss_envy24ht
   Building module oss_envy24
   Building module oss_fmedia
   Building module oss_geode
   Building module oss_hdaudio
   Building module oss_hdsp
   Building module oss_ich
   Building module oss_imux
   Building module oss_madi
   Building module oss_midiloop
   Building module oss_midimix
   Building module oss_sblive
   Building module oss_sbpci
   Building module oss_sbxfi
   Building module oss_solo
   Building module oss_trident
   Building module oss_usb
   Building module oss_userdev
   Building module oss_via823x
   Building module oss_via97
   Building module oss_ymf7xx
   depmod -a
   -----------------------------
   Detected Sound Blaster Audigy LS / Live7.1
   USB support available in the system, adding USB driver
   Detected Generic USB audio/MIDI device (BETA)
   -----------------------------
   
   Forcing re-detection of installed soundcards
   Starting Open Sound System
   WARNING: All config files need .conf: /etc/modprobe.d/pnp-hotplug, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/isapnp, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/display_class, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/blacklist, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libsane, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libpisock9, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/pnp-hotplug, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/isapnp, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/display_class, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/blacklist, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libsane, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libpisock9, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/pnp-hotplug, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/isapnp, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/display_class, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/blacklist, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libsane, it will be ignored in a future release.
   WARNING: All config files need .conf: /etc/modprobe.d/libpisock9, it will be ignored in a future release.
   
   ************************************************************
   * NOTE! You are using trial version of Open Sound System   *
   ************************************************************
   
   Processing triggers for man-db ...
   Processing triggers for menu ...
   
   

3. That should be it!
   If on ubuntu, apparently you have to set your sound settings to user "OSS4 - AudigyLS front".
   Let's test it on mplayer:
   
mplayer -ao oss somevid.avi

4. Now however you'll have to tell your previous applications to use OSS instead of alsa... maybe uninstalling alsa would solve this problem.
   In mplayer, add the following line in your ~/.mplayer/config file:
   ao = oss
   

I can't believe my speakers sound this good!! (After using a USB bad quality made in China sound board for almost two years...)

dragon ball porn

I can't believe all the good dragon ball porn you can find for free!!
I've always loved Bulma, she's like even maybe better than One Piece's Hancock.
That's one more reason for me to want to become Vegeta... we even have the same haircut!

growisofs double layer dvd issue

For some reason using growisofs to burn a dual layer dvd (DVD-DL) was giving me an error that ended with like this line:
:-( write failed: Input/output error growisofs dvd dual layer

The command I used was:

growisofs -Z /dev/scd0 -R -J -V "someID" .

It usually works just fine on regular DVDs.
I thought it was only an option for burning ISO files, but apparently using the -dvd-compat option fixes it (it did for me!). So instead of the above command, you'd type:

growisofs -dvd-compat -Z /dev/scd0  -R -J -V "someID" .
And you'll be able to burn a dual layer DVD(8.5GB) with growisofs without any problem.

Setsubun, Japanese spring welcome day or something

That's the title all my friends in the SNS I'm using (mixi, the most popular in Japan) used in their nikkis. I really have no idea what that is...

Anyway, today at work, after I had the annoying high school guy I have every week this day (who for some reason won't talk with me, but really likes my jokes), I had the usual two guys who are rather fun to teach^^.
I told one of them I won't be teaching on March (being that I'm graduating and having to move to Tokyo to finally work), and told me like "What?... Are you serious?..." in such a sad way^^. I have to admit, all my students (excepting for that annoying high school guy) are great, and I'll greatly miss all of them... I can't believe they pay me for this job! Even as part-time^^, I even get to teach cute girls sometimes, it's really great.
(My part-time job being an English Juku teacher)

After my part-time job, I re-organized my DVDs. After writing my DVD-database-interface, it was very easy to search in which DVD the thing I was looking for was, but not so easy to find the actual DVD...
I organized them by the ID (used in the database), so now it's really easy to search for stuffs!
Here's a pic:

And, it has nothing to do with the above topic, but I really want Koda Kumi to more sexy vids! CRAZY4U was great, and she has a few more sexy vids after that, but lately it's all too-many-clothes-wearing-no-sexy-dancing crap...


Koda Kumi vs Britney Spears

Haunted spots in Japan (2)

Maebashi->Asama trip (meganebashi bridge + abandoned museum)

In Kanna Gunma (Arai's house)

Pics taken in Arai's house and shrine near by.