2011 in review

The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.

Here’s an excerpt:

The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 17,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 6 sold-out performances for that many people to see it.

Click here to see the complete report.

Google Webmaster Tools[網站管理員工具]

可以提供網站(blog)站長,透過這個工具觀看網站在Google索引資料庫中的狀況。而且透過sitemap提交也可以讓Google能夠更快 速的將你的文章捉取進入資料庫中。但是,由於Wordpress.com並不支援上傳檔案或是編輯Head meta的功能,因此無法進行Google Webmaster Tools的驗證。

不過這個問題現在得到解決了,我已經實際測試過,的確可以通過驗證,而且也可以新增sitemap。

方法如下:

1.先要申請Google Webmaster Tools的帳號,並且在控制主頁中新增你wordpress.com的網站。

2.新增後,頁面會有驗證的連接,點選後選擇驗證方式為上傳檔案。會出現需要驗證的檔案名稱,通常是xxxxxxxxxxxxxx.html,請複製這個檔名。

3.到你wordpress.com的後台,新增一個Page,注意不是post。

4.在標題(title)的欄位貼上剛才複製的檔名,選擇右邊的Page status為Drafe,也就是草稿模式,然後選擇發佈。這樣wordpress.com就會在你的root路徑下,新增一個該檔名的檔案。而且由於是草稿,所以不會在主頁上面出現。

5.回到Google Webmaster Tools選擇開始驗證,你就會看到驗證成功的畫面。

原理分析:

wordpress.com發佈page的功能,並不是將資料存放於資料庫,而是在根目錄下,產生與標題一樣的html檔案。

接著說明一下sitemap新增的方法,其實很簡單。在Google Webmaster Tools選擇sitemaps,然後選擇新增sitemap,接著選擇類型為新增一般網頁sitemap。接著在網址後面欄位輸入atom.xml,接著點選新增就可以了。我測試過rss.xml但是會出現錯誤的格式。

原創連接:

網站:JIUNN’s MIND Tigre de Fogo

文章:Tutorial: How to make Google verify your WordPress.com Blog (Verify site ownership)

如何訂閱本網站特定主題的RSS feed?

How to get site feeds for specific labels in blogger?Yes, you can! If a blog you read is using labels and also has site feeds enabled, then you can pick and choose which topics you want to subscribe to. The format for label feeds is this:

http://blogname.blogspot.com/feeds/posts/default/-/labelname

Be sure to substitute in the correct blog address for blogname and the label you’re interested in for labelname. Also, don’t miss the hyphen (“-“) in the URL. That’s not a typo!

Note that a URL of this form will only work if the blog in question is using this specific label, and has also enabled site feeds. However, no special site feed settings are necessary. As long as the basic site feed for posts is enabled (with either short or full descriptions) then label feeds will also work.

How to create a backup of DNN and the database

from Mitchel Sellers’ DotNetNuke, .NET, and Other Topics Blog

Another very common question that I see regarding DotNetNuke is when and how should I backup my DotNetNuke site. This topic is VERY important and requires a bit of planning, especially if you do not have direct access to your database server to perform your own backups. In the following sections I will first talk about what you must backup and why some of those items are very important. I will then discuss how to perform a DNN backup and SQL Server backup, both for SQL 2000 and 2005. Finally I will discuss options available for third party modules for performing backups for individuals that do not have direct access to their servers.

What to Backup?
Simply put, it is a best practice to backup your ENTIRE DotNetNuke directory on the web server as well as a full backup of the database. Some people will say that you can get by with only backing up the “portals" folder, this is NOT correct! To successfully restore a DotNetNuke installation you must ensure that you have all module .dll and other code files you also must have the same validation and decryption keys. I have found that the only real method to keep your data safe is to create a backup with all files. Given the limited file size of the core DNN installation I have not found this to be a hinderance, especially since the additional files that exist in my website are all related to the content available within and is something I must have a backup.

Performing the Backup
Performing a backup of DotNetNuke is a fairly easy two step process. First I will discuss backing up the DNN installation directory, then I will discuss options available for backing up the database.

Backing up the DotNetNuke Directory
You have two options when backing up the DotNetNuke directory. If you have direct access to the server, you can simply right click on the DotNetNuke directory and select “Send To:" -> “Compressed (Zipped) Folder". This applies for most versions of the windows operating system. You will then have a file named dnn441.zip where dnn441 was your directory name. This zip file will contain all needed backup files, you will want to store this in a safe location.
If you do not have direct access to the server and can only access it via FTP you will have an additional step to obtain a zip file for your site. You will want to connect to your FTP site and COPY all files to a temporary location on your local computer. Once all files have been copied you will want to create a zip file including ALL files and folders that were just downloaded.
NOTE: if using a program such as WinZip for zipping, ensure that the “Use Folder Names" option is enabled so that the folder structure is preserved within your zip archive.

Backing up the DotNetNuke Database
To backup the database you must have access to the database server and the file system of the database server. If you are in a hosted environment you will need to rely on your hosting provider to obtain a backup, or you will need to look into a potential third party solution to backup the database from within DotNetNuke. If you have full access to the server please use one of the below sets of instructions to backup your database..
Backing up a Database with SQL Server 2000 and Enterprise Manager
Follow the below steps if you wish to create a databse backup file from Enterprise Manager for SQL Server 2000 using Enterprise Manager.
Navigate to your specific database in Enterprise Manager
Right click on the database and select “All Tasks" -> “Backup Database.."
Ensure that “Complete" is selected for the backup type
Click the “Add" button in the “Destination" section
In this section provide a full file path to the desired backup file, typically named DATABASENAME.bak where DATABASENAME is your database name
Click “Ok" to generate your backup, you will receive a success notice upon completion
You will now have a full backup file containing all tables and data for your database.
I believe the functionality is fairly similar using SQL Server Management Studio Express with SQL Server 2005