I bought a new host on Friday.It is much cheaper than China hosts.And I got an extra domain which is selected “bjdch.org”.It is stand for Beijing DCH Studio–An organization for computer technology.
At the first time,I want to get a domain name like “dominic.com”.Because my english name is Dominic-Our foreign english teacher gave me that name.But the domain has been registered by others and I cannot find a suitable new domain name except “bjdch.org”.So I choosed it.It sounds great!
But I was frustrated by the transportation from old one to the new one.Because I only knew little about the Mysql Databases.I searched the Internet for help.
The main difficulty is the domain name.Because I used to make “w t . b j d c h . c o m / b l o g” and “w w w 1 . b j d c h . c o m” for my blog address.I want to change them into “blog.bjdch.org”.It nees knowledge about the syntax.I tried many times.At last, I won!
It needs four syntax:
UPDATE `_snapshot_recover_wp_posts` SET `guid` = replace (`guid`,’w t . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w t . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `guid` = replace (`guid`,’w w w 1 . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w w w 1 . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `post_content` = replace (`guid`,’w t . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w t . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `post_content` = replace (`guid`,’w w w 1 . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w w w 1 . b j d c h . c o m / b l o g%’
This host contains a powerful control panel.Here is the main pages of the panel.
03/06/2007
[2007.06.03]A remarkable day for my E-life
By dch1 in Just Notes No Comments
I bought a new host on Friday.It is much cheaper than China hosts.And I got an extra domain which is selected “bjdch.org”.It is stand for Beijing DCH Studio–An organization for computer technology.
At the first time,I want to get a domain name like “dominic.com”.Because my english name is Dominic-Our foreign english teacher gave me that name.But the domain has been registered by others and I cannot find a suitable new domain name except “bjdch.org”.So I choosed it.It sounds great!
But I was frustrated by the transportation from old one to the new one.Because I only knew little about the Mysql Databases.I searched the Internet for help.
The main difficulty is the domain name.Because I used to make “w t . b j d c h . c o m / b l o g” and “w w w 1 . b j d c h . c o m” for my blog address.I want to change them into “blog.bjdch.org”.It nees knowledge about the syntax.I tried many times.At last, I won!
It needs four syntax:
UPDATE `_snapshot_recover_wp_posts` SET `guid` = replace (`guid`,’w t . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w t . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `guid` = replace (`guid`,’w w w 1 . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w w w 1 . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `post_content` = replace (`guid`,’w t . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w t . b j d c h . c o m / b l o g%’
UPDATE `_snapshot_recover_wp_posts` SET `post_content` = replace (`guid`,’w w w 1 . b j d c h . c o m / b l o g’,’blog.bjdch.org’) WHERE `guid` LIKE ‘%w w w 1 . b j d c h . c o m / b l o g%’
This host contains a powerful control panel.Here is the main pages of the panel.