Web Projects Consulting

Software Development and Architecture Since 2000

MySQL Administration

Programming for mysql with Native Timezone Support

The idea behind that is that you do not have to take time server time offset when programming for mysql.

By Alec | 21/03/2010 | MySQL, MySQL Administration, PHP, Programming & Freelancing, Webmaster, Zend Framework Programming | No Comments |

PHP, MySQL, AJAX Freelancer Programmer And Web Application Developer Available for Hire

Having coded PHP, MySQL and Javascript hard for around 10 years, I can witness that communication is the key to problem solving for any project of any complexity level. I am currently looking for a long-term php programming-related position, please…

By Alec | 03/03/2010 | Apache, Javascript, Linux, MySQL, MySQL Administration, PHP, Programming & Freelancing, Site Updates, Software, Webmaster | No Comments |

PHP, MySQL, Javascript Programmer Consultant (Freelancing, Telecommuting)

Coding PHP, MySQL and Javascript hard since 2001, I can witness that communication is the key to problem solving for any project of any complexity level. I am am looking for a long-term programming-related position at present . I have…

By Alec | 23/07/2009 | Apache, Javascript, Linux, MySQL, MySQL Administration, PHP, Programming & Freelancing, Site Updates, Software, Webmaster | No Comments |

Preparing for Fedora 11 – MySQL Database-per-file Dump

Yes, yes, man, I am still NOT on Fedora 11… Because I know how newly-out distributions of Fedora tend to behave on my hardware (which is never really brand-pathetic but effective in the terms of gigahertzes and terabytes). I have…

By Alec | 22/06/2009 | How-Toes, Linux, MySQL, MySQL Administration | 3 Comments |

Sometimes you feel romantic and want to get something else than phpMyAdmin to communicate to MySQL. Download mysql-workbench-oss-5.2.1-1fc10.src.rpm from one of the mirrors picked up here:

By Alec | 02/06/2009 | Linux, MySQL, MySQL Administration, MySQL Development GUI Tools, Software | No Comments |

MySQL latin1 Content Upgrade to an UTF-8 Database

The below is pretty useful if you have some databases in other than UTF-8 charset and simply importing dumps does not help.

By Alec | 14/05/2009 | How-Toes, Linux, MySQL, MySQL Administration, Software | No Comments |

Quick Backup of MySQL Database

One-line shortcut to dump to a compressed file: Dump with stored procedures

By Alec | 01/05/2009 | Backup, MySQL, MySQL Administration, Webmaster | No Comments |