Best Webhosts

MySQL: Repair & Optimize all Tables in all Databases

0
4 months ago
by hismis in

MySQL tables can crash quite easily, especially when your server unexpectedly shuts down or crashed, or when you're forced to copy data around when it's still being accessed.

Luckily, there's a simple command to automatically check, repair and optimize all tables in all databases when you're running a MySQL server on Linux / Unix / BSD.

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

That's all there is to it!

Best Webhost

9
5 months ago
by admin in

Our Recomended Webhost for the month:

DreamHost

With our promo take 50 USD OFF using promotional code: GIVE50GIFT

That gives you a One Year webhost for only 69.4USD

Please share you opinions if you think otherwise.

Below is a table comparing popular webhosts and any hidden limtations they have. If you have updates to this please comment.

Feature Dreamhost Hostmonster GoDaddy (Delux)
Price/Month $9.95 $6.95 $6.99
Price Promo 1yr $119.4-50=$69.4 Adhoc 5.95$x12=$71.4 $6.64×12=$79.68
Host Unlmited Domains Yes Yes Yes
Hosting Space Unlimited "Unlimited" but if high your account will be suspended 150GB
Bandwidth Unlimited Unlimited 1500GB
SSH Access By Default Need to send ID Can be requested no ID needed
CPU Limit No Limitation 60Sec then Site suspended No Limitation
Uptime 99.9 99.9 99.9
MYSQL Databases Unlimited 100 25
Email Accounts Unlimited Unlimited Unlimited
First Yr Domain Registration Free Yes Yes No
Custom Cronjob Yes Yes Yes
Tech Support Chat, Email Ticket system(response time: 1-24hours),Phone: only call back Phone, Chat, Ticket(Response time 1-24 Hours) Phone,Ticket(slow 1 Day response time)
Install Custom PHP Yes Simple see article here No No
FFMPEG Yes No No
Max File Upload Size 7MB, unlimited with Custom PHP install 2MB, can be increased with copying php to all folders, still limited with CPU time limit 7MB
Can host Adult Content Yes No Yes
Loading speed for a 64kb website size 2-3 Seconds performance is stable since dreamhost upgraded to new servers 2-3 Seconds, performance was stable 5-6 Seconds
Midnight Commander Installed by default Not installed and can not install it Not sure

How to increase UPLOAD MAX FILE SIZE for DREAMHOST?

2
1 year ago
by admin in ,

This article is a slightly modified article from a great blog post at www.bluesunray.com about how to have our own php.ini with dreamhost.Thank you for your work:
0-Set up your domain for FastCGI (usually it is the case by default)
Login your Dreamhost, enter Manage Domains, Edit your domain setup, in Web Options->PHP mode, select ‘PHP 5 FastCGI’

  1. Download DreamHost Custom PHP.ini from DeamHost Scripts and Tips. Or attached here as of today dh-phpini
  2. Extract the dh-phpini.php from dh-phpini.zip and upload it to you website root.
  3. Open dh-phpini.php in you browse. Example: http://www.yoursite.com/dh-phpini.php.
  4. Then, this result shows,
  5. After install, this script create ‘cgi-bin’ folder in you website root, including ‘php.ini’ files in the folder, and add this lines in you .htaccess file, if they are not there already:

AddHandler fastcgi-script fcg fcgi fpl
AddHandler php-fastcgi .php
Action php-fastcgi /cgi-bin/dispatch.fcgi

6. Default, the Max upload file size increase to 20M, if you want to change to more, edit php.ini file in ‘cgi-bin’ folder like this,

post_max_size = 50M

upload_max_filesize = 50M

7.For changes to the new php.ini file to take effect , you’ll probably need to restart FastCGI for them to take effect.

Unfortunately you can’t do this from the Dreamhost Control Panel. You need to log in via SSH, and issue the command “killall -9 php5.cgi” to restart FastCGI.

Commands using iconv to fix website Characters

0
2 years ago
by admin in
Here are some useful SSH commands to fix special characters on your website.
Sometimes you would see ? or strange charsets…
Recommended to use UTF-8 and have your database collation also as utf-8
Convert a bunch of HTML files from ISO-8859-1 to UTF-8 file encoding in a folder and all sub-folders
for x in `find . -name ‘*.html’` ; do iconv -f ISO-8859-1 -t UTF-8 $x > “$x.utf8″; rm $x; mv “$x.utf8″ $x; done
Convert mysql database from latin1 to utf8
mysqldump –add-drop-table -uroot -p “DB_name” | replace CHARSET=latin1 CHARSET=utf8 | iconv -f latin1 -t utf8 | mysql -uroot -p “DB_name”
find . -name “*.php” -exec iconv -f ISO-8859-1 -t UTF-8 {} -o ../newdir_utf8/{} \;
Batch convert files to utf-8
iconv -f ISO8859-1 -t UTF-8 OLDFILE > NEWFILE

For example in ssh type:
iconv -f ISO8859-1 -t UTF-8 listing_default.tpl >listing_default2.tpl

Then rename or delete your old listing_default.tpl and rename listing_default2.tpl to listing_default.tpl

Competent Support

10
3 years ago
by admin in

Please post here any conversation that you had with hostmonster and would like to share..

Happy New Year Hostmonster way…

6
3 years ago
by admin in

It seems hostmonster is cleaning their servers again.

I have been hosting with them for 18 months with few issues. I also referred more then 10 clients to them. The last referral was just yesterday and today January 10th 2009… all I noticed that my web page was taken down without a single warning…

Contact them and asked for a reason. They said: you are using too much server resources. I told them I had this site up and running for the last 6 months without any change in script/visitors/database so what happened?

The referred me to the error log to check. One of the support suggested that I should delete empty databases. I told her you allow us to use 100 db in your plan why would my 33 databases be an issue even if it is empty??

The reinstated my site and I started working on the error log and scripts only 5 minutes later they just took down the whole site and killed my cpanel access. I had to beg to get back my data…

Moving on .. AVOID hostmonster if you are thinking of a website with more than 100 visitors a day. Once you go up bit with visitors they will take your site down.

Go to Top