Skip to main content

Mysql Quota

I installed a forum, and forget about it.

After several months, I received a Mysql Quota warning, and found that the forum has got thousands of registered users and posts. All of those usernames are randomly generated and posts are ads with many links, fortunately there are no adult photos and videos.

Here is the Mysql Quata warning email:

Dear Valued Customer
We are mailing you to let you know your free account has exceeded its mysql quota of 50mb.
The ability for your user to add new data to your databases has been revoked (denied) due to the quota breach.
You will be able to log into phpmyadmin (or possibly use tools in your script) to remove data from mysql.
If you are unable to reduce your database usage to under 50mb, we would ask you to upgrade.
Best Regards
Besides of the restriction of SQL usage, there are disk usage quota, bandwidth usage quota and daily CPU usage quota.

Comments

Popular posts from this blog

How to Input Phonetic Symbols (IPA) in Google Docs

You can insert special characters by clicking "Insert" on the menu, then click the "Ω Special Characters", the choose "Latin" category from the drop-down menu, and then Phonetics (IPA) sub-category. Insert Special Characters in Google Docs There is a short-cut for inputting some IPA symbols which you use them frequently. Automatic Substitution in Google Docs similar to Auto Correct in MS Word. You can replace common acronyms, misspellings and other symbols. So you can set auto-replace for your IPA symbols, for example, "e<" for "ɛ", "o/" for "ø", "o>" for "ɔ" etc. Automatic Substitutions in Google Docs

How to stop Freenet?

How to stop or temporally shutdown Freenet? On Windows, you may find "stop freenet" in Freenet Tray. On Ubuntu, or other Linux system, go to your Freenet folder, run a command inside the terminal: FreenetUser@ubuntu:~/Freenet$ ls *.sh run.sh  update.sh You can see run.sh command, run.sh have six options, one of them is to stop the Freenet: FreenetUser@ubuntu:~/Freenet$ ./run.sh ? Usage: ./run.sh { console | start | stop | restart | status | dump } FreenetUser@ubuntu:~/Freenet$ ./run.sh stop Stopping Freenet 0.7... Waiting for Freenet 0.7 to exit... Stopping Freenet 0.7... Stopped Freenet 0.7. This is how you to stop the Freenet on Ubuntu.

Vodafone Router Configuration for Incoming Connection and other Services

This post is about specific Vodafone Home Broadband Router configuration for Incoming Connection and other service on your home computer. This is not a tutorial, and will not be going into details of the services and router configuaration, I just want to point out couple of points you need to pay attention to. 1. Port Forwarding. Vadafone Router has its own name for Port Forwarding, it's called Port Mapping under Port Management category.The picture below shows that I set up web server on my desktop, I map my local address on port 80; and I set up PPTP incoming connection by mapping local address on port 1723. Port Forwarding 2. Exposed Host. If you have set up Port Mapping, you still can't get what you want, then you have to put your device outside the Firewall, i.e. bypass Vodafone Connects (means Router) firewall, in a Demilitarised Zone (DMZ), using it's Exposted Host Function. Static NAT (Network Address Translation) means the Router will translate publi