I found this article on Geekpreneur called “10 Cool Uses of Twitter”. The most useful one to me is the traffic alerting via Commuter Feed. For Orlando there are currently 12 incidents posted. Cool. Florida Highway Patrol has a site that shows traffic incidents. Be interesting to convert these to Tweets or SMS messages.
Thanks to mydigitallife for the hints on how to do this.
In my case bilbo.some.net was renamed to kinscoe.somenewplace.com.
UPDATE wp_options SET option_value = replace(option_value, 'http://bilbo.some.net',
'http://kinscoe.somenewplace.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_options SET option_value = replace(option_value, 'http://bilbo.some.net',
'http://kinscoe.somenewplace.com') WHERE option_name = 'home';
UPDATE wp_posts SET guid = replace(guid, 'http://bilbo.some.net','http://kinscoe.somenewplace.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://bilbo.some.net', 'http://kinscoe.somenewplace.com');
show tables;
+---------------------------+
| Tables_in_bilbo_wordpress |
+---------------------------+
| wp_categories |
| wp_comments |
| wp_link2cat |
| wp_links |
| wp_options |
| wp_post2cat |
| wp_postmeta |
| wp_posts |
| wp_usermeta |
| wp_users |
+---------------------------+
10 rows in set (0.02 sec)
SHOW FIELDS FROM wp_options;
+---------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+------------------+------+-----+---------+----------------+
| option_id | bigint(20) | | PRI | NULL | auto_increment |
| blog_id | int(11) | | PRI | 0 | |
| option_name | varchar(64) | | PRI | | |
| option_can_override | enum('Y','N') | | | Y | |
| option_type | int(11) | | | 1 | |
| option_value | longtext | | | | |
| option_width | int(11) | | | 20 | |
| option_height | int(11) | | | 8 | |
| option_description | tinytext | | | | |
| option_admin_level | int(11) | | | 1 | |
| autoload | enum('yes','no') | | | yes | |
+---------------------+------------------+------+-----+---------+----------------+
11 rows in set (0.04 sec)
select option_value from wp_options WHERE option_name = 'home';
+---------------------------+
| option_value |
+---------------------------+
| http://bilbo.some.net |
+---------------------------+
1 row in set (0.01 sec)
Note that in this case I was only renaming the virtual host not actually moving the site to another server. If you do that then you also need to backup your database and restore it to the new server as well.
I kind of get twitter now. The recent SXSW made me see the light. it’s not just micro blogging as I had been using it for. It’s a global irc chat. So the point of following someone is the point of being able to talk to them in a safe way. So then whomever follows you you may as well follow them. Of course when you reply to (”@”) someone you don’t really have to be following them to send them a message. The weird thing is if you use the twitter web site you won’t see replies unless you are following the sender. The other day I installed twitter on my blackberry and it had a feature to see replies and I found people were replying to my posts but on the public timeline I suppose. I just was not seeing them on the web site. Now to find a web app that will.
According to the Twitter settings:
“Always: all @ replies
I receive all @replies from people I follow, even if I don’t follow the person to whom the @reply is directed.”
Notice it does not say “@replies from people I do not follow”.That is a problem so how do I do this from the web? The only way I have now is to either use the Blackberry app. or scrape the public timeline.