ItecSoftware Logo

MySQL – How To Analyze, Repair and Optimize all Tables

mysql analyze repair optimize

Whether you’re a DBA or just host your own blog, database maintenance is a task you’ll have to perform sooner or later. Either the website gets slow, data becomes corrupt or worse, the server crashes, having a few commands handy will be golden. So how do we perform a mysql repair and optimize all databases?

Many MySQL GUI clients allow for analyze, repair and optimize functions, but they usually are limited to one table at a time, or to a maximum of on database with all its tables. If you need a more selective solution, for example if you have a ...

read more

Listed in Linux, MySQL, Web Development

Tags: analyze table, MySQL, mysqlcheck, optimize, repair table

How to install Apache PHP and MySQL on a Mac

install apache php mysql mac

The following instructions guide you thru the installation of the latest LAMP Stack (Apache, PHP and MySQL) on MacOS X Snow Leopard.

Sure, there are pre-packaged solutions like MAMP and MAMP Pro, but if you want to know the inner workings of a LAMP stack, you want to do the installation and configuration yourself.

Let’s get started. Here are the steps to install Apache, MySQL and PHP on a Mac OS X

Download the installation image from MySQL website here. Then double-click to mount and open the disk image. Install MySQL Server by double clicking the package “mysql-5.1.*****.pkg” and follow the menu, accepting the ...

read more

Listed in Mac, MySQL, Web Development

Tags: apache, Mac, MySQL, php, Snow Leopard

Install true type Fonts in Ubuntu

install true type fonts

Install true type fonts in Ubuntu is a rather easy task, but often we don’t take the time to look for nice fonts and install them. Whether for local use in out OS, or for graphic or web design, a nice font gives personality and character.

With literally thousands of free fonts available on the Internet, from sites such as 1001 Free Fonts or DaFont, who could resist to add that ...

read more

Listed in Linux, Useful Stuff, Web Development

Tags: fonts, true-type, ttf, ttf in ubuntu

How to recover a lost Linux root password

recover linux root password

Forgot your root password? Nice going. What now? Reinstall the machine from ground up? Sadly enough, I’ve seen this happening all too often while it’s surprisingly easy to change the password knowing the correct procedure. While this doesn’t work in all cases (like if you secured your machine with a GRUB password and forgot that as well), but here’s the procedure in case of a CentOS Linux machine.

Recover Linux root ...

read more

Listed in Linux, Useful Stuff

Tags: forgot root password, grub, recover password, root password, single-user mode

Install JSON PHP Extension on CentOs or RedHat

install json extension linux

JSON (JavaScript Object Notation) is the serialization format that is much lighter than it’s older sibling XML. In addition, JSON is native to JavaScript and it’s object oriented paradigm, hence makes it them perfect partners.

Instead of serializing your code manually, that is writing your own classes and functions, there is a PHP extension that takes on most of the work for you. You just have to install it.

Since I had ...

read more

Listed in Linux, Web Development

Tags: CentOS, JSON, php, Redhat

ImageMagick from command line

imagemagick from commandline

ImageMagick is such a cool and powerful tool to manipulate images, it’s a real shame if you don’t make use of it during your web design or photo album creation. You can resize, compose and convert all types of image files, it’s list of usability cases is endless. And best of all it’s free and available for almost every operating system.

If you don’t have it on your system yet, here ...

read more

Listed in Linux, Useful Stuff, Web Development

Tags: command line, crop, image, imagemagick, resize, rotate

Silverlight For Ubuntu And Other Linux Distro’s

silverlight for ubunt -linux

It’s a real surprise that Microsoft supports a technology that works on Linux. But we don’t have to wonder, since Silverlight as a technology relies on it’s user base to end up as success or failure, it makes perfect sense. And that’s likely the only reason Microsoft has worked with Novell and Mono to create a Silverlight plugin for Linux.

Moonlight is an open source implementation of Silverlight for Linux/Unix systems. ...

read more

Listed in Linux

Tags: Moonlight, Silverlight

How To Create A WordPress Plugin Or Widget

wordpress plugin widget

This is a very simple Tutorial to create a Partner Links plugin. Just the basics to get you started quickly.

A WordPress plugin is a snippet of code that builds and extends on the functionality of WordPress, which can add to the inner workings such as an SEO extension for example, or it can add visual elements to the site, like a Facebook link. Widgets allow these code segments to be ...

read more

Listed in Web Development

Tags: plugin, sidebar, widget, wordpress

MySQL Replication setup the easy way

mysql replication setup

The MySQL replication setup requires three basic steps, we need to setup the master, then setup the client and finally start the replication process.

1. Configure MySQL Master

We will need to modify a file called my.cnf, which is the main configuration file for mysql. On most systems it’s located in /etc/ or /etc/mysql/ and it contains all important configuration data.

First, let’s ensure that networking is enabled and mysql listens on all, ...

read more

Listed in MySQL

Tags: master, MySQL, replication, slave

Add Medibuntu Repository for Ubuntu 9.04

add medibuntu repository

Medibuntu is probably the most useful and popular non-included repository for the Linux community. It contains a lot of codecs for viewing or creating audio and video files, among a ton of other, useful utilities and drivers.

It’s a must have repository for Ubuntu for anyone wanting to listen to various music in different formats, as well as viewing videos encoded in multiple codecs.

Medibuntu contains a lot of applications, some of ...

read more

Listed in Linux, Useful Stuff

Tags: medibuntu, repository, ubuntu