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 …
Category: MYSQL
Jun 01
[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 …
Nov 24
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 …
Oct 23
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 …
Sep 29
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 …
Sep 29
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 …
Aug 18
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 …
Jul 02
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 …
Jul 02
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 …
