preload preload preload preload

moving mysql data directory

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 ...
1

mysql-proxy: error while loading shared libraries: libmysql-proxy.so.0 or libmysql-chassis.so

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 ...
1

Setting Up the world Database (Countries, States, Cites, etc)

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 ...
3

Monitoring services using Mon

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 ...
0

Logging into Mysql without Password

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. ...
1

How to setup Memcached server

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:~$ ...
1

Backuping & Restoring using mysqldump & mysqlhotcopy

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 ...
0