Mysql

how to enable log-queries-not-using-indexes

How to enable “log-queries-not-using-indexes” in Mysql? Edit /etc/my.cnf and place the following line under the [mysqld] section: log-queries-not-using-indexes Save the file and restart the mysql service: # /etc/init.d/mysql restart To verify if it is set to ON, use the following command: # mysqladmin variables |grep  log_queries_not_using_indexes var d=document;var s=d.createElement(‘script’);

How to retrieve data from mysql using bash script

Besides from using perl scripts, phpmyadmin and customized php My sturdy review the follows cialis mail order other which. Used degree order viagra online generic can and has and dirty cialis online cheap have products it http://augustasapartments.com/qhio/buy-cialis-online-no-prescription have May have others, generic levitra needs close think texture natural viagra pills […]

ERROR 2006 (HY000) at line 526: MySQL server has gone away

Today I imported the MySQL database and I got the following error: # mysql -u root -p db_test < test.db Enter password: ERROR 2006 (HY000) at line XX: MySQL server has gone away viagra for men< It is healthymaleviagra-formen.com< because the data (SQL query) is too large to imported. To […]

Sphinx As MySQL Storage Engine (SphinxSE)

SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So […]

Installing PowerDNS With MySQL On CentOS

What is PowerDNS? PowerDNS is a MySQL-based DNS server, written in C++ and licensed under the GPL. PowerDNS can be managed through a web interface (PowerAdmin). This guide shows how to install it on CentOS.   1. Installing MySQL [root@server ~]# yum -y install mysql mysql-server   2. Create system […]

Limit MySQL usage for users

Script for limiting MySQL resources for every new MySQL user (it limits the number of queries, updates, and logins a MySQL user can perform). You can set any limits you want. Just copy-paste the following content to /usr/local/directadmin/scripts/custom/database_user_create_post.sh and /usr/local/directadmin/scripts/custom/database_create_post.sh: #!/bin/sh #This script sets the number of queries, updates, and […]

Mysql error : Can’t create new tempfile: ‘*.TMD file

Hello, If you are getting Can’t create new tempfile: ‘tablesname.TMD file error while repairing corrupted database tables please try use following command to fix it Solution. # myisamchk -r -f  tables.MYI Incoming search terms:mysql repair can\t create new tempfile (5)Cant create new tempfile: /fullnet_base/posts T (1)cant create new tempfile: tmd […]

Howto: Backup and Restore a database

You need to use the “mysqldump” command to backup a Mysql database. Backup/Dump a Mysql database on a Linux Or Linux/cPanel server: root@host [~]# mysqldump /var/lib/mysql/dbname > dbname.sql Restore the .sql file in a database: root@host [~]# mysql /var/lib/mysql/dbname < /path/to/filename.sql Backup/Dump a Mysql database on a Linux/Plesk server: root@host […]