Yesterday was one of those days when things that can go wrong went wrong and today was MySQL day, and problem when accessing any table on a live site resulted in following error

MySQL Error - Can't create/write to file '/tmp/#sql_7d3f_0.MYI' (Errcode: 30)

It took me some time to figure out that the error was due to /usr/tmpDSK getting corrupted, and and not really a problem with MySQL or our database as we were thinking all this time, and as usual google came to rescue.

Here are the steps to fix this for cpanel users…  run the following commands in the order mentioned

/usr/sbin/lsof /tmp

/bin/umount -l /tmp

/bin/umount -l /var/tmp

/bin/rm -fv /usr/tmpDSK

/scripts/securetmp

This will create a new /tmp partition for you and the problem will go away. By the way error code 30 means that file system is read only.

http://amiworks.co.in/talk/how-to-fix-mysql-error-error-code-30/

Options +FollowSymlinks
RewriteEngine on
RewriteCond %{REQUEST_URI} !/maintenance.html$ 

RewriteRule $ /maintenance.html [R=302,L]

Namecheap has long been a favorite domain registrar among savvy webmasters who appreciate control and anonymity. In the past five years especially, Namecheap has grown exponentially as it became an independent registrar (before it was an eNom reseller).

Anyway, the reason they have been popular is cuz, well, their names are cheap. They really do have cheaper prices than many registrars out there. Plus, for just $3 a year (first year is free) you can get WHOIS guard, to protect your domain WHOIS data.

In recent months however, Namecheap has began cooperating a little too well with the US government in shutting down domains. That, and Namecheap’s DNS service is notoriously bad. I constantly have to re-save the DNS information because their system constantly freezes up.

It was time to find a good offshore registrar that respects privacy, yet has the simplicity and control of Namecheap.

Enter Internet.bs from the Bahamas. They have zero marketing, zero advertising, yet they have the best damn deal on the market. Not only is WHOIS privacy included free FOREVER on ALL DOMAINS, but their pricing is crazy cheap at just $6-7 or even less. They outsource their DNS services to a fantastic provider called TopDNS. Oh ya, and they are out of reach of the US government.

Note: If you prefer staying in the US market so that you can sue your registrar if needed, check out Moniker. They have a strong reputation among domain professionals, but they are anal about everything. So if you like the ability to quickly update domain info and transfer between registrars while paying with unconfirmed Paypal accounts, stick with Namecheap or Internet.bs.

Cheers folks.

Login to your server as root.

Firstly check the status of MySQL on your dedicated server. Normally, it should be ok – as you’re getting this error.

The database table can be repaired only if the Mysql server is in running status. You can check the status by the command.

root# /etc/init.d/mysql status

Now, login to the MySQL database for a required user.

mysql> mysql –u databaseusername –p databasename

You need to select that particular database having problem.

mysql> use databasename;

Now, you will have to check whether the table is corrupted. On giving the below command you will get a NULL value as your output if it is corrupted otherwise it’s alright.

mysql> check table tablename;

If the table is corrupted for that particular database, then you need
to repair the table by giving the following command.

mysql> repair table tablename;

This will repair the table for you.

Under some situations however, no matter how many times you run a REPAIR on the table, the table still returns IN USE and what’s worse is that the system says the table is “already up to date”.

If you have shell access, here’s what to do;

cd /var/lib/mysql/DATABASE  (where DATABASE is the one you’re trying to fix)

myisamchk –safe-recover –force TABLE  (where TABLE is the table you are tring to fix)

This will will repair the table in safemode, and SHOULD result in success.

more options

http://www3.wiredgorilla.com/content/view/347/58/

If you want to 301 redirect all pages on your website to a new site URL or domain, you can place this code below into your .htaccess file on your public_html or www directory. This will make all pages automatically redirect to the new URL or domain using a 301 redirect wildcard based on Apache HTTPD mod_rewrite rules.

The page/directory called “stayhere” is an example of how to create an exception to this “redirect all pages” rule by telling your server to ignore that page or directory (keep it here, don’t redirect to new site).

Options +FollowSymLinks
RewriteEngine On
RewriteCond %{REQUEST_URI} !^/stayhere(/?$|/.*$)
RewriteRule ^(.*)$ http://example.com/$1 [R=301,QSA,L]

Or, a more simple variation of the code:

Options +FollowSymLinks
RewriteEngine On
RewriteCond %{REQUEST_URI} !^/stayhere
RewriteRule (.*)$ http://example.com/$1 [R=301,L]

Just thought this might be useful to other webmasters out there who are using the WP-PostRatings plugin by Lester Chan, and who are using a dark WordPress theme.

I have redone the star graphics to have a dark (black #000000) background so they  blend properly with a dark WordPress theme.

Here they are, simply replace these files under wp-postratings/images/stars/

Cheers.

Add these to your WordPress ping list or otherwise:

rpc.technorati.com/rpc/ping
rpc.blogcatalog.com/
api.moreover.com/RPC2
bblog.com/ping.php
ping.weblogalot.com/rpc.php
ping.bloggers.jp/rpc/
rpc.weblogs.com/RPC2
topicexchange.com/RPC2
api.my.yahoo.co.jp/RPC2
audiorpc.weblogs.com/RPC2
blog.goo.ne.jp/XMLRPC
blogpeople.net/ping
blogpeople.net/servlet/weblogUpdates
blogsearch.google.ae/ping/RPC2
blogsearch.google.at/ping/RPC2
blogsearch.google.be/ping/RPC2
blogsearch.google.bg/ping/RPC2
blogsearch.google.ca/ping/RPC2
blogsearch.google.ch/ping/RPC2
blogsearch.google.cl/ping/RPC2
blogsearch.google.co.cr/ping/RPC2
blogsearch.google.co.hu/ping/RPC2
blogsearch.google.co.id/ping/RPC2
blogsearch.google.co.il/ping/RPC2
blogsearch.google.co.in/ping/RPC2
blogsearch.google.co.jp/ping/RPC2
blogsearch.google.co.ma/ping/RPC2
blogsearch.google.co.nz/ping/RPC2
blogsearch.google.co.th/ping/RPC2
blogsearch.google.co.uk/ping/RPC2
blogsearch.google.co.ve/ping/RPC2
blogsearch.google.co.za/ping/RPC2
blogsearch.google.com.ar/ping/RPC2
blogsearch.google.com.au/ping/RPC2
blogsearch.google.com.br/ping/RPC2
blogsearch.google.com.co/ping/RPC2
blogsearch.google.com.do/ping/RPC2
blogsearch.google.com.mx/ping/RPC2
blogsearch.google.com.my/ping/RPC2
blogsearch.google.com.pe/ping/RPC2
blogsearch.google.com.sa/ping/RPC2
blogsearch.google.com.sg/ping/RPC2
blogsearch.google.com.tr/ping/RPC2
blogsearch.google.com.tw/ping/RPC2
blogsearch.google.com.ua/ping/RPC2
blogsearch.google.com.uy/ping/RPC2
blogsearch.google.com.vn/ping/RPC2
blogsearch.google.com/ping/RPC2
blogsearch.google.de/ping/RPC2
blogsearch.google.es/ping/RPC2
blogsearch.google.fi/ping/RPC2
blogsearch.google.fr/ping/RPC2
blogsearch.google.gr/ping/RPC2
blogsearch.google.hr/ping/RPC2
blogsearch.google.ie/ping/RPC2
blogsearch.google.it/ping/RPC2
blogsearch.google.jp/ping/RPC2
blogsearch.google.lt/ping/RPC2
blogsearch.google.nl/ping/RPC2
blogsearch.google.pl/ping/RPC2
blogsearch.google.pt/ping/RPC2
blogsearch.google.ro/ping/RPC2
blogsearch.google.ru/ping/RPC2
blogsearch.google.se/ping/RPC2
blogsearch.google.sk/ping/RPC2
blogsearch.google.us/ping/RPC2
hamo-search.com/ping.php
ping.blo.gs
ping.bloggnytt.se
ping.blogs.yandex.ru/RPC2
ping.feedburner.com
ping.kutsulog.net/
ping.myblog.jp
ping.namaan.net/rpc
ping.syndic8.com/xmlrpc.php
ping.wordblog.de/
rpc.aitellu.com
rpc.bloggerei.de/ping/
rpc.blogrolling.com/pinger/
rpc.pingomatic.com
rpc.reader.livedoor.com/ping
rpc.twingly.com
rpc.weblogs.com/RPC2
services.newsgator.com/ngws/xmlrpcping.aspx
www.blogpeople.net/ping
www.blogpeople.net/servlet/weblogUpdates
www.feedblitz.com/f/f.fbz?XmlPing
www.wasalive.com/ping/
www.zhuaxia.com/rpc/server.php
xianguo.com/xmlrpc/ping.php
xping.pubsub.com/ping/
zhuaxia.com/rpc/server.php

Our partners have released a Thai language pack for the Social Engine platform. It was translated and edited by a native college-educated Thai speaker from Thailand. It is regularly updated in regard to errors and new versions of SE.

(ชุดภาษาไทยสำหรับระบบ Social Engine แปลและแก้ไขโดยคนไทยที่สำเร็จการศึกษาจากมหาวิทยาลัยในประเทศไทย เรามีการปรับปรุงชุดภาษาไทยนี้อยู่ตลอดเวลาเพื่อให้ตรงกับระบบ SE รุ่นใหม)

Compatibility: Social Engine 3.20 – 4.x (core translation only)

 

Social Engine License #

Social Engine Customer Email

Since the quality of web directories tends to shift a bit over time, this list will be constantly updated. In addition with the below-mentioned web directories, it is also a good idea to visit Directory Critic and find other smaller (but quality!) “niche” directories to list your site in – both relevant to your site’s subject matter, and also relevant to the region which it services (i.e. Los Angeles). There is no reliable way to truly rank web directories, whether by PageRank, Alexa Rank, backlinks, or otherwise. This list is compiled from good old-fashioned observance (but for the record, you should avoid any web directory with a PR3 or lower, in our opinion).

1. DMOZ – (FREE) – Directory Mozilla, a.k.a. the Open Directory Project, is King of kings, when it comes to web directories. Hard as hell to get approved, not because they are necessarily picky, but mostly because their volunteer editors engage in crony-ism and pure laziness.

2. BOTW – (PAID) – Expensive as hell, but worth it. Best of the Web, as they are called, is one of the oldest and best maintained web directories on the Internet. Also, Google tends to agree with this statement, so you probably should too.

3. YAHOO – (PAID) – Also expensive as hell, but again, worth it. Many SEO experts would list the Yahoo Directory as second best, but since they have so many expired, crappy, and/or otherwise dead websites in their index, I choose to list them third.

4. JOEANT – (PAID) – Amazingly cheap for their quality. JoeAnt is fast becoming of the most respected web directories out there, so all of us webmasters better pray that they are gracious enough to keep their prices down.

5. IPL – (FREE) – Now a merger between IPL (Internet Public Library) and LII (Librarians’ Internet Index). This directory is highly regarded as one of the most powerful in regard to SEO value, however it is nearly impossible to be accepted.

6. EZILON – (PAID) – Originally focused on Europe, now Ezilon seems to accept most any quality websites. Their site is a bit strange to navigate around for me, with weird URL structure sometimes, but they are old and seem pretty respected.

7. BUSINESS – (PAID) – Extremely expensive, and mostly just focuses on business industries. Plus, its confusing as heck to navigate. Can you tell that I’m not a big fan of the Business.com web directory? Esteemed, yes. But I’d say overrated.

8. GOGUIDES – (PAID) – Many webmasters would disagree with me here, but after observing my very successful competitors, I must conclude that GoGuides.org is one of the most respected directories when it comes to search engine rankings.

9. SKAFFE – (PAID) – Reasonably priced and well respected by Google, Skaffe shouldn’t be passed up in your link building. (b. 2003)

10. AVIVA – (PAID) – Aviva Directory has seemingly been penalized multiple times by Google for link-swapping with their other websites among other things. At this time they are still docked to a PR3, but I’ve seen respected SEO experts still using them, so…

11. UNCOVERTHENET – (PAID) – Overpriced, but seemingly quite respected. Great traffic and layout. Just… overly expensive.

12. TYGO – (PAID) – Their site is a bit messy, but they seem to have quality editorial discretion with their approvals. I’ve observed successful competitors using this directory so I will choose to believe it has potential.

13. FAMILYFRIENDLY – (PAID) – Quite overpriced I’d say, but overall pretty reliable. They have a bunch of websites that I don’t see on other directories, and vice-versa, which makes me kind of doubt their authority, but they seem to remain somewhat respected.

14. WEBWORLDINDEX – (PAID) – Decent collection of decent quality sites, but nothing amazing. Seem to have a pretty good sense with their write-ups and acceptance of sites, so they are worth a mention. Keep an eye on these guys.

15. JAYDE – (FREE) – Probably one of the most overrated directories on the web, in my opinion. They seem to accept just about anything, as long as its not too spammy. I wouldn’t be surprised if their PageRank fell to a PR3 soon.

16. V7N – (PAID) – Once again, severely overpriced for how incomplete and unbalanced their directory is. I only include it because they seem to maintain a decent PageRank and decent reputation among certain webmaster circles.

17. ROMOW – (PAID) – Overpriced. Seems to be common, huh. Fantastic design and layout, but barely any websites. They seem to have decent respect on Google but nothing amazing yet. I hope they lower their price and get more content.

18. DIRJOURNAL – (PAID) – Extremely overpriced to the point that they barely have any websites listed in their directory, but somehow they have damn high traffic and pretty high respect on Google it would seem.

19. PEGASUS – (FREE) – Old as the hills, and has a healthy, balanced collection of sites. Go for it.

20. DOMAINING – (FREE) – Seem to have good judgment and good traffic and good sites. Good enough for me.

21. GLOBALWEBLINKS – (PAID) – Overpriced but decent quality. Seems to pass some decent link juice. PR3.

22. LINKOPEDIA – (PAID) – Pretty good editorial judgment and very cheap to submit. Overall a decent option. PR3.

23. LINKCENTRE – (FREE) – Write-ups are a tad bit spammy, but overall good filtering and not bad for a free directory.

24. MASSIVELINKS – (PAID) – Pretty high traffic directory, and decent price. Overall a little overpriced for the quality.