Author Archive
Backup & Restore mySQL database | quick guide
Create a backup: mysqldump -u username -p password –databases database1 database2 db_name3 > multi_db_names.sql mysqldump –all-databases > alldatabases.sql mysqldump –all-databases | bzip2 -c > databasebackup.sql.bz2 mysqldump –all-databases | gzip > databasebackup.sql.gz Restore from a backup: mysql -u [username] -p [password] [database_to_restore] < [backupfile] gunzip < backup_name.sql.gz | mysql -u username -p password db_name If you […]
mySQL csv import via LOAD DATA INFILE
Well it’s actually quite simple. That sample worked for me like a charm: LOAD DATA INFILE “C:\\\\us_mag_sizes.csv” INTO TABLE support_sizes_US FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n” IGNORE 1 LINES LOAD DATA INFILE “C:\\\\time_pojas.csv” INTO TABLE pt_time FIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY “””” LINES TERMINATED BY “\r\n” IGNORE […]
New cool web site about… cats and fun :) And more!
Web site called www.mapikcha.com and everybody welcome to visit and create new funny pictures! Like this for example: see more funny pictures on www.mapikcha.com
In: English, Fun · Tagged with: cats, funny cats, pictures
Backup and Restore PostgreSQL database
I am not quite sure why phpPGAdmin doesn’t have “import” feature and only have “export”, but… who cares? Dump Individual DBs with pg_dump PostgreSQL provides the utility program pg_dump for dumping individual DBs: pg_dump dbname > outfile pg_dump writes its results to the standard output. pg_dump is a regular PostgreSQL client application. This means that […]
Here I go. I am oficially gonna create new jQuery plugin.
Just one link to follow: Simple tutorial http://www.queness.com/post/112/a-really-simple-jquery-plugin-tutorial http://docs.jquery.com/Tutorials possibly more to follow….
WordPress plugin for nice colourfull code in posts
Today is gonna be a very short post. Oddly enough I asked myself – why I still don’t have any nice plugins to display programming languages code with different colours? And now here we go: Dojox WordPress Syntax Highlighter Available codes: PHP, Phyton, Java, Javascript, Delphi, Css, HTML, HTML+Django Syntax: <pre> <code class=”HTML”> // Put […]
RPM’s on Red Hat 5 and “yum”
RPM on Reh Hat Linux seems like a good solution, but sometimes it just gives you headakes and nothing else. Here are few good comand samples to use with RPM’s: To list all installed modules with “mysql-” name: rpm -qa | grep -i ‘^mysql-‘ Forced Update: rpm -Uhv –force MySQL-server-community-5.1.34-0.rhel5.i386.rpm And one more thing… don’t […]
In: English, Fighting the system · Tagged with: linux, Red Hat, RPM
How to find duplicated values in MySQL (or/and probably any other RDBM)
As an example I take one real (almost) table I have in my db. Structure is very simple : Table name: “words”, field “filename” name of the file and “words” just some information about each file. +—————–+———————+ | filename | words | +—————–+———————+ Suddenly we had a few files with exactly same name and […]
In: English, sql · Tagged with: dublicated values, mysql, sql
Not very often used HTML tags
We all know <form> tag, as well as <ul><li> and so on… but how many of web developers used good old (and sometimes not just usefull, but VERY usefull) html tags in forms: <fieldset> <legend> and <optgroup label=”label”></optgroup> in <select> ? here are two good samples to use (taken from my new template engine version): […]
In: English, JavaScript, WEB2.0 · Tagged with: guru, html, w3c
Ukulele Orchestra of GB – The Good the Bad the Ugly
These guys really rock! I’ve heared their other compositions and they always do everthing look and sound so-o-o-o cool 🙂
In: English, Fun, JavaScript · Tagged with: music, The Good the Bad the Ugly, Ukulele Orchestra, youtube