This is easy upgrade process like previous versions.
But there are problems, this sign � shows up in blog posts.
Here is a way to fix it (same as search and replace contents in WordPress) :
1. Backup a WordPress database. You can use phpmyadmin or mysql console.
Using mysql console :
- mysqldump :
mysqldump -u [username] -p [databasename] > [mysqlfile_name]
example :
mysqldump -u try -p nineteenlabs > /tmp/kate/backupfile01.sql
output :
Enter password : [type your password]
Using phpmyadmin :
- Choose Database
- Choose Export tab
- Options : Export SQL, Structure Add DROP TABLE / DROP VIEW, check Save as File and push Go button
2. Now, search and replace contents. This time i’ll do it in phpmyadmin, because this sign isn’t recognized in a console, �
- Choose Database
- Choose table wp_posts (click wp_posts in left bar)
- Choose SQL tabs
- Type this inside Run SQL query/queries on database box :
UPDATE wp_posts SET post_content = REPLACE (post_content,'�',' ')
note : without delimiter ; its already fill by phpmyadmin in below box
- Push GO button. DONE!
SEARCH AND REPLACE THROUGH MYSQL CONSOLE WORKS IF ITEMS TO REPLACE IS EASY TO READ BY CONSOLE.
Using mysql console
- log in to mysql console
mysql -u [username] -p
Enter password : [type your password]
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is xxx to server version: x.x.x��
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>use [database_name]
mysql>(You want to make sure wp_posts table) show tables;
mysql>+----------------------------+
| Tables_in_wordpress |
+----------------------------+
| wp_comments |
| wp_falbum_cache |
| wp_links |
| wp_liveshoutbox |
| wp_liveshoutbox_useronline |
| wp_options |
| wp_podpress_statcounts |
| wp_podpress_stats |
| wp_postmeta |
| wp_posts |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_useronline |
| wp_users |
+----------------------------+
16 rows in set (0.00 sec)
mysql > UPDATE wp_posts SET post_content = REPLACE (post_content,'Item to replace','Replacement text');
mysql > exit
I have this problem after OpenDNS setup, i can’t ‘browse’ computer on a private network by name, following a recommendation from OpenDNS, simple tweak in /etc/hosts file.
What is /etc/hosts file?
This is a way for hostnames to map to IP addresses. Operating system will attempt to resolve domain names to IP addresses by first accessing a local file called the “hosts” file, which is simply a database of IP-to-hostname mappings for hosts we know about—such as hosts on our local network—with the /etc/hosts file. /etc/hosts allows you to build a table in which each entry lists an IP address, its most common (or “official”) hostname, and any aliases (additional names that map to the same IP address), separated by spaces or tabs. This table is consulted before any DNS queries are made, so /etc/hosts acts both as a backup to DNS (if it’s not available) and an override (if it’s not serving correct information). DNS is queried only if the domain name that you are looking for is not listed in this file.
format
ip_address official_hostname alias1 alias2
example
192.168.x.x nineteenlabs.com nineteenlabs
When I fix this, also resolve a ftp error. Now, my ftp can use domain name
It’s Basic, and i forget this command all the time, use this ‘chown’ in one of servers, i want to (b)log this command :
I am using this command to change a file owner and a group of directory, its subfolders, and its files
chown -R name:group [directory path]
example :
chown -R kate:kate /usr/local/www/directory_name
I am using OpenDNS, because my curiosity.
OpenDNS claims make Internet safer, faster, smarter and more reliable. My Internet Connection here already fast, but when many peoples connects, it’s getting slow.
So i try OpenDNS.
OpenDNS is fast and help ‘boost’ our internet connection. But when it comes to features, only phising, block adult sites, stats, typo correction gets my attention. Other feature like shortcuts need an additional setup, when i run a network with many users, tells everyone to setup shortcuts in their browsers are difficult.
Most features set in an OpenDNS account, so if you don’t create an account, you get internet connection booster. But if you do create an account, you get a powerful tool for your internet connection (not just internet connection booster).
UPDATED
OpenDNS (from its website) : it’s a DNS service, aim to make Internet safer, faster, smarter and more reliable.
This is how to setup OpenDNS in SQUID :
Edit squid.conf and add this :
OPTIONS FOR EXTERNAL SUPPORT PROGRAMS
dns_nameservers 208.67.220.220 208.67.222.222
or
dns_nameservers 208.67.220.220
dns_nameservers 208.67.222.222
Save and run this :
squid -k parse
squid -k reconfigure
but if your squid add nameservers from squid.conf, just run squid -k reconfigure
If your squid add nameservers from /etc/resolv.conf, add to /etc/resolv.conf :
nameserver 208.67.220.220
nameserver 208.67.222.222
Save and run :
squid -k reconfigure, since your squid need to refresh its configuration
Where do I get OpenDNS IP? You can look at a OpenDNS Web Site.
Test the configuration : open this address in your browser http://welcome.opendns.com
For more configuration or troubleshooting you can ask OpenDNS people.
Add below to proftpd.conf :
DefaultAddress domain_ip
The solution hide a warning, getaddrinfo domain_name error: hostname nor servname provided, or not known in ProFTPD.
I visited wordpress.com page about Posting Source Code, there’s a link to Automattic Projects.
I scroll down and there are plugins from Automattic.
Here is some great plugins to install in your wordpress:
- Wordpress.com Stats: stats with no additional load on your server by plugging into WordPress.com’s stat system.
- Sidebar Widgets : arrange widgets on your sidebar. A latest wordpress already include this feature
- Random Redirect : create a link to yourblog.example.com/?random which will redirect someone to a random post on your blog, in a StumbleUpon-like fashion.
- Admin IP Watcher : monitors when someone logs in with a new IP and emails you.
- No Self Ping : keeps your site from pinging itself
- Draft Notifier : sends a notification email to your blog�s admin address when a post is written by a Contributor or when such a post is edited.
- Search Hilite : when someone is referred from a search engine like Google, Yahoo, or WordPress� own, the terms they search for are highlighted with this plugin
Plugins description taken from Automattic Projects Page