Posts Tagged ‘wordpress’

Doing it differently

December 25, 2013

I have said this many times. Most people resist change so we keep on doing things the same way. For certain things, if I could, I like to do it differently every time.

I can’t escape hiccups failure so I tried to enjoy them.

About 10~12 years ago I set up at work a browser based search facility to help myself with mountain and ocean of papers. I published my experience on an ASP Programming site.   What I’ve learned is obsolete, I hardly remember anything, never mind that I enjoyed the learning process.

Then few years back I did that again that time I used XAMPP server stack and WordPress, a popular CMS, as the platform. Everything went as planned and I learned from that experience backing up the database and scheduled backup by running DOS batch files using XP’s scheduled task.   XP support ends in a few month so again I used obsolete technologies.

Recently I’m in the mood of doing this again, the 3rd time.  To do this differently I’m working on XAMPP portable lite on an external SSD drive. However my work location uses DHCP so in case my 6~7 years old DIY computer failed on me I could still run the stack on another computer running Windows OS.   I did struggle a bit if I should be running Linux or XP for this little project, at the end I chose the easier option as I want this launched ASAP.

I’ve worked out a few safety measures such that I could migrate my work easily, backup the whole thing, making it easy to restore things etc.   I’ll post codes separately later as I’m sure these will be useful to me in the future.

Yahoo Blog

October 13, 2013

收到 Yahoo blog (2005 – 2013) 死亡通知,在這裡又要寫歷史。

我試用時應該是 2006 吧,那些年是 Yahoo 的黃金歲月,多數人都用他們的電郵,試用他們的 blog service 實在容易,但功能不多且不見得流行。

我最先用的是 Blogger (1999 – ?), 大概是 2004 吧, Google 收購了它們不久,當年可能因資源問題, 服務不是太穩定, 最近二年見 Google 大力推 Google+ 我想 Blogger 已經年事已老,死期不遠。 Google+ 有很大的發展空間,似是把瑞士刀,張張利是有可能的。Facebook 如果能稱王十年八載已經不錯了,當然 Facebook 也是不錯的發表平台。

還記得當年在同學間有辯論應否將班內活動資料,功課,照片等放在網上,當時反對的佔多, 擔心隱私,在今天幾乎人人用 Facebook 的年代,當年的爭論有點可笑!

我最後做了少許市場調查,決定從多個 CMS 中選了 WordPress,除了短期試了 Habari 之外始終沒變心! 我試過的 Blogware 和 platform 多到都記不清了,有興趣的可看這個, 這個。 對於唔搬又搬搬家所以我經驗十足。

網絡世界中所謂高科技東西有五年盛年已經不錯了, 從來都要有搬家的心理準備。

DOS again

August 10, 2011

Have not touched DOS command line for many years.

I set up an intranet running XAMPP under XP recently. The hardware is pretty aged so I have to backup the database just in case. I use XP’s scheduler to run a batch file daily during lunch time. The batch file looks like this

title backup database by mysqldump
for /f "tokens=1-4 delims=/ " %%a in ('date/t') do (
set dw=%%a
set mm=%%b
set dd=%%c
set yy=%%d

SET bkupdir=c:\xampp\htdocs\dump
SET mysqldir=c:\xampp\mysql
SET dbname=my_database_name
SET dbuser=root
SET dbuserpwd=my_db_user_pwd
SET dumpfile=%bkupdir%\backup_%dbname%_%yy%_%mm%_%dd%.sql

@ECHO Beginning backup of database %dbname%...

%mysqldir%\bin\mysqldump --opt --user=%dbuser% --password=%dbuserpwd% %dbname% > %dumpfile%
FOR %%A IN (%dumpfile%) DO SET FileSize=%%~zA
@ECHO Done!
@ECHO New File: %dumpfile% %FileSize%bytes

This is just for one database so instead of looping through databases in a single batch file I did the lazy way of using another batch file to CALL a series of batch files with one batch file for each database.

Restoring the mysql dump file should be (in my To-Do list) straight forward. I’ll try this manually at command line.

mysql -u root -p[root_password] [database_name] < dumpfilename.sql

Why there were more clicks at Posterous?

September 22, 2010

I tried Tumblr and Posterous side by side then dumped Tumblr leaving my Posterous behind since my miCoach run charts posted here are hot linked from there. Posting those run charts with a few words via email to Posterous is really handy.

Most free blogging platform these days have stats, Blogger has it, has it and Posterous has it.

I just can’t understand why stats in my Posterous blog is so much higher than this one here? Firstly my friends will click this one from within Facebook and a few random clicks from Twitter, secondly I have never promoted my Posterous blog, most importantly my posts are so boring?!!! I surely am not alone asking this. The official reply is here but I’m still doubtful.

Screen shot 2010-09-22 at 12.20.26 PM