27 Jul, 2010
A very good way to reduce page load time on your website is to tell your visitors' browser it can cache some specific files and save a copy on the disk.
This process is done by your web-server which is sending an Expires header and a max-age header during the HTTP response, e.g.:
200 OK
Cache-Control: max-age=604800
Connection: close
Date: Tue, 27 Jul 2010 22:31:03 GMT
Accept-Ranges: bytes
ETag: "2c956-376b-4696cb8b385c0"
Server: Apache/2.2.14 (Ubuntu)
Content-Length: 14187
Content-Type: image/gif
Expires: Tue, 03 Aug 2010 22:31:03 GMT
Last-Modified: Fri, 08 May 2009 20:46:23 GMT
Client-Date: Tue, 27 Jul 2010 22:31:02 GMT
Client-Peer: 127.217.30.5:80
Client-Response-Num: 1
Apache2 offers this feature through its mod_expires module. Note that this module is usually disabled by default, meaning your visitors would download all the files over again each time they change the page.
Read the rest of this entry »
――
10 Jul, 2010
When you want to backup your mysql databases, you usually do mysqldump ... --all-databases or mysqldump ... --databases mysql ... but you end up with the whole mysql table which is a pain to insert back when you need it because it can mess up the root password or the debian-sys-maint user...
If you wish to just backup all the users and privileges other than root and debian-sys-maint, you can use this command:
mysqldump -nt -uroot -p -w"User NOT LIKE 'root' AND User NOT LIKE 'debian%'" mysql user db > users_privs.sql
Here's an explanation of each of the options:
- -nt: Do not add "drop table" and "create table".
- -uroot -p: Connect as root and ask for a password
- -w...: Add a "WHERE" condition to each query. We exclude everything related to root and debian-sys-maint.
- mysql user db: Dump the user and db tables from the mysql database.
- > users_privs.sql: Store the sql dump into the users_privs.sql file.
――
10 Jul, 2010
A new version of your operating system just got released and you want to have a fresh new install, or you want to migrate all of your data to another machine. There are so much stuff to backup that you don't even know where to start?
I will try to list the most common stuff (on a web-server) to backup or copy somewhere when you want to do a server migration.
Read the rest of this entry »
――
9 Dec, 2009
After my second hard disk started failing, I really thought about moving my +11000 pictures to my young main hard disk, BUT, also keep all my favorites, tags, comments in F-spot.
F-Spot
So here's how I did it:
Read the rest of this entry »
――
