How to change the time in MySQL server

We showed you the other day how to change the time server in Ubuntu Linux in .

But then I realised that MySQL server was not using the updated time, why was that???

Well, remember, that if you would like the change in linux time to affect MySQL server, you have to restart MySQL server

service mysql restart

and then it will use the same time as the linux server.

Testing websites in Internet Explorer for Windows, using Mac or Linux with VirtualBox

If you develop your website applications from a Linux of a Mac platform, you will have problems to test your websites in Internet Explorer.

Thanks to Microsoft initiative www.modern.ie, it is possible to download a Virtual machine for VMWareParallels or VirtualBox for free, with various versions of Internet Explorer preinstalled. This is a official Microsoft site for all information related to testing IE, great for developers.

Direct download of virtual machines: http://www.modern.ie/en-us/virtualization-tools#downloads

Your problems with Internet Explorer will be easier to tackle if you start testing the browser with this virtual machines.

Thank you Microsoft for helping the community to build IE compatible websites.

mysql does not start and parallels is not working

I just experienced a major server breakdown in 1and1. MySQL crashed and when I tried to restart it the result would be negative:

 

Then I restarted the server and the problem persisted.

So my third action was to have a look at my Parallels Plesk web panel, and the result was that it would not load, showing a MySQL problem.

I then figured out that the problem could be a lack of memory, so I entered with ssh to the server and started listing directory sizes, using the great “du” linux command:

du -h –max-depth=1

until i found that the problem was in the backups folder:

/var/lib/psa/dumps

then I deleted one of the backup folders and could restart mysql

service mysqld restart

Thanks to this guide for the du parameters: http://www.linfo.org/du.html

 

 

how to avoid receiving an email every time a cron task is executed

How can you disable the automatic sending of mails to the sysadmin in linux/unix each time a task is run in the crontab list?

I found the solution thanks to a very useful explanation between adding:

>/dev/null

or

>/dev/null &2>1

to a cron task.

Both of them avoid that an email is sent everytime a task is completed. But in the second case it will also avoid sending error mails.

Read the details here http://www.mydigitallife.info/cron-differences-between-devnull-21-and-devnull/

The mails are sent if you don’t use either of those two at the end of the cron task. I didn’t know it and was receiving tons of alerts, since I have a cron every two minutes!