我是資深的電腦資訊從業員,曾於 Motorola 及 Philips 等跨國大型公司管理層工作十多年,具各類ERP資源管理系統及其它應用系統經驗,如QAD之MFG/PRO、SAP、Ufida(用友)、Kingdee(金蝶)、Microsoft's Dynamic、Wonderware's In-Track (SFC)、Webplan (SCM)、Hyperion (business intelligence)、Informatics (Data Warehouse)...等等。另外,我精於廠房車間之電腦資訊運作,擁有 CISSP 及 ITIL 認證,能提供日常資訊運作之檢測及審查,以提高操作效率。 本人誠意為各類大中小型廠房提供資訊審計、支援及意見,歡迎聯絡,電郵為




我想很多人會對"香港股票價位的歷史數據"有興趣,我已下載成Microsoft Access database version 2000 的文檔,資料由2008/1/1至2009/12/2,zip壓縮後也有11M,若索取請留你的PM我 。




Update wordpress domain address after site/domain transfer

WordPress Home Fix

If the links in your blog show the wrong domain, redirect to another site or if they are missing images or styling, this is typically due to an improperly configured URL for your blog's domain name in your database.
To resolve the issue, you will need to update your domain in WordPress; this update will also be necessary to make your blog display and function properly with your temporary web address or secure web address.

Update WordPress Domain with Database Access

To update an improperly configured WordPress domain or to use a temporary URL or a secure web address for your WordPress domain via database, follow the steps below:
  1. Log into your cPanel.
  2. Check the wp-config.php file in the appropriate directory to get the WordPress database name.
    1. In the Files section, click the File Manager icon.
    2. Select the wp-config.php file in the base directory for your blog.
    3. Right-click on the file and select View.
    4. Find the line:
      define('DB_NAME', 'username_wrdp1');
    5. Exit the File Manager and return to cPanel home.
  3. In the Databases section of cPanel, click on the phpMyAdmin icon.
  4. In the left menu, click on the database name.
  5. In the left menu, click on the wp_options table.
  6. In the option_name column, look for the siteurl and home variables.

  7. Change those variables to the correct address for your blog.
    1. Click Edit on the far left of the option name.
    2. On the next page, place the full URL for your site into the large text box in the option_value field.
    3. Click Go.
If you are using your temporary URL or shared SSL address to preview your blog on the HostGator servers, be sure to change the siteurl and home database values back to your normal domain if you want your blog to work with your regular domain name once your name servers (or DNS) have been switched over to HostGator.

Update WordPress Domain through WP-Admin

This method cannot be used if you cannot access the WP-Admin section of your WordPress installation.
WordPress allows users to update their domain name through the administrative access panel; however, this should be done with caution. This method is best for users who wish to update the domain prior to a directory change.
To change a WordPress domain through WP-Admin:
  1. Visit and log in with your admin username and password. (Be sure to replace with your working domain name.)
  2. In the left menu of the dashboard, click Settings.
  3. Under General Settings, in the WordPress address (URL) field, enter the new domain.
  4. In Site address (URL) field, enter the new domain again.
  5. Click Save Changes at the bottom of the page.

WP-Admin Lost Password

If you've lost or forgotten your WP-Admin username or password, navigate to the login page ( ) and click the Lost your passwordlink.

You will be prompted to enter your username or email address in order to receive an email with your username and a link to create a new password at the email address you entered when you created your blog.

Update WordPress Domain via File Manager or FTP

If you are unable to update your WordPress domain using the methods above, you can alternativley try the following:
  1. In cPanel, go to File Manager or connect via FTP.
  2. Navigate to your WordPress directory.
  3. Edit the wp-config.php file.
  4. Update (or add) the following lines to the code:
    define("WP_SITEURL","desired url address");
    define("WP_HOME","desired url address");
  5. Save the changes.