Category: MYSQL

[Warning] IP address ‘X.X.X.X’ could not be resolved: Name or service not known

In one of  RDS instance getting  warning messages in the error log file. “[Warning] IP address ‘X.X.X.X’ could not be resolved: Name or service not known” I have checked and DNS lookup is working fine. In RDS hope you all aware about the concept of Security Groups where we white list the IP address so that they …

Continue reading

[Warning] IP address ‘10.10.10.10’ could not be resolved: Name or service not known

Getting Warning Messages in MYSQL.log file. [Warning] IP address ‘XX.XX.XX.XXcould not be resolved: Name or service not known. Now question is why this warning message captured in MYSQL log file. First we have to check the IP address or domain is internal or external. If the Users are not authorised users than we have to …

Continue reading

MySQL Workbench cannot load MYSQL.PROC

One of my team member starting to use MySQL Workbench tool especially for development task but not able to see the tables, stored procedures and views, Getting a strange error message: Error: Cannot load from mysql.proc. The table is probably corrupted Considering the error message. I tried to repair the table but no solution. Basically I …

Continue reading

Create MySQL User to Backup and Restore Databases!!

Create MySQL User to Backup and Restore  Databases It is always recommended to create a Backup and Restore User. I always recommend not to use MYSQL root user for database backup and restore. There is a slightly difference in the User privileges for Restore and backup.   User Privileges Required for Backup  and Restore are: Backup …

Continue reading

MySQL Binary Logging

How to enable MySQL binary logging. To enable MySQL binary logging stop the MYSQL service and then add the mentioned parameter in “my.cnf” configuration file. ………………………………………………………. log-bin=/var/lib/mysql/mysql-bin server-id = 1 innodb_flush_log_at_trx_commit=1 sync_binlog=1 ………………………………………………………. Once the above parameter added than start the MySQL service “Service  mysqld Start”.  This is the mistake which majority of people will do. I strongly recommend …

Continue reading

mysql is dead but subsys locked

When I tried to connect to MySQL it displayed the Following Error: …………………………………………………………….. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock'(2) …………………………………………………………….. I had issued command to check mysql status with root user: service mysqld status Message received that mysql is dead but subsys locked than tried below command to start the MYSQL Restarting …

Continue reading

MySQL – Resetting a lost MySQL root password

If you lost MYSQL root password than follow the below steps to reset the same. Stop MySQL The first thing to do is stop MySQL. For CentOS, Fedora, and RHEL the command is: sudo /etc/init.d/mysqld stop Safe mode Next we need to start MySQL in safe mode – that is to say, we will start …

Continue reading

MYSQL Database Cluster Configuration

MYSQL Database Cluster Configuration MYSQL Database cluster on Windwos 2008R2

MYSQL Database Tuning Tips

Top Table Size SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base Size in MB” FROM information_schema.TABLES GROUP BY table_schema ;   Free space available for my Data Base in MySQL   SELECT table_schema “Data Base Name”, sum( data_length + index_length ) / 1024 / 1024 “Data Base …

Continue reading

MYSQL-To drop all the tables from the database using query

To drop all the tables from the database using query, mysqldump -u[user] -p[ssht…] –add-drop-table –no-data [DATABASE] | grep ^DROP | mysql -u[user] -p[sshht…] [DATABASE] Can also be used with the -h option in both places. If you use the empty -p options, you’ll have to enter the password twice after running the command. The 2nd …

Continue reading

WP2Social Auto Publish Powered By : XYZScripts.com