In some cases you have to change the default MySql data directory, for doing this you have to follow some steps. Here I will explain each steps one by one. Stop MySql server using following command. $ sudo /etc/init.d/mysql stop Copy the existing data directory (which is located in /var/lib/mysql) using following command. $ sudo ...

Getting the below errors: $ ./agent/sbin/mysql-proxy -V mysql-proxy: error while loading shared libraries: libmysql-chassis.so.0: cannot open shared object file: No such file or directory mysql-proxy: error while loading shared libraries: libmysql-proxy.so.0: cannot open shared object file: No such file or directory The error ...

In certain applications we need the details of all the counties in the world, all the states in in each country and the capital of all the country.  And it is difficult to create all theses information's manually. But mysql provide a file world.sql which contains sample data for a world database that you can play with. This file ...

Monitoring services using Mon mon is a general-purpose scheduler and alert management tool used for monitoring service availability and triggering alerts upon failure detection. Mon uses some Linux command and services such as ping command to check host connectivity and mail servers for sending mail, so you must install postfix ...

Recovering MySQL Password and Permission Problems If you garble your GRANT commands or forget passwords and find that you don't have access to the critical mysql table even as the root user don't panic. You can access MySQL without password. Superuser can access MySQL using mysqld_safe command and you can change mysql password. ...

Introduction Memcached is a high-performance, distributed caching system. It is often used to speed up dynamic database-driven websites by caching data and objects in memory to reduce the number of times the database must be read. Installing memcached shahid@shahid-laptop:~$ sudo apt-get install memcached shahid@shahid-laptop:~$ ...

Using mysqldump Using 'mysqldump' command you can take the mysql database backup. This command all the datas to a text file. The syntax is shell> mysqldump [options] db_name [tables] shell> mysqldump [options] –databases db_name1 [db_name2 db_name3…] shell> mysqldump [options] –all-databases Backuping ...