How to stop replication from external master in RDS MySQL
RDS MySQL providing the option to configure replication from external master server. To stop the replication from external master, the
Read more
Mysql
How to find all views in a MySQL database
We can use the following MySQL query to list out all views created in a specific database. Where DB need
Read more
MySQL not showing the UPDATE and INSERT query outputs
The UPDATE and INSERT query provides the outputs when executed in MySQL shell. The same query can be executed from
Read more
How to skip replication errors in RDS MySQL
Errors will break the replication process in slave. RDS provides an option to skip the error and re-sync the replica.
Read more
MySQL Error: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement This is not an issue
Read more
How to create additional super user in RDS MySQL
RDS have only one super user by default when the instance is created. But we can create users the same
Read more
PHP Fatal error: PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away This is a common error happens if the PHP script
Read more
How to skip errors in MySQL replication
MySQL replication will stop working if there is error running query on slave machine. But there is an option to
Read more
How remove column header from MySQL query output
MySQL output contains lines column headers while printing and hence it may be difficult to use this in automation scripts.
Read more
How to stop replication in RDS MySQL instance
To stop replication in RDS MySQL instance, the following query need to be executed in MySQL shell as admin user.
Read more
How remove "+----------+" lines from MySQL query output
MySQL output contains lines "+----------+" while printing and it will be difficult to use this in automation scripts. But there
Read more