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.
Today is Sunday . This week is more busy than passed weeks . On Monday , when I went to the libruary , the administrator rufused me to entered the building . Because the Student Card is invalid . I was so depressed that I did not want to read a word in the classroom because I used to study in the libruary every evening . Maybe that is why I am writting weekly diary now .
I got flu this week . I think I need to take more physical exercise . And my father was sent to the HuiMin Hospital because of the fever . He has been fever for more than three weeks . Now he feels better now in the hospital .
Yesterday , I converted all the Cambridge Ielts(tape edition) into digital audio(128Kbps 44Hkz MP3 files) . It was really a hardwork . You need run all the tapes . But I was glad because it is easy to the teachers and our classmates to use it .
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.