Tag: mysql
Configuring MySQL Master-Slave Replication on Ubuntu
Replication between master and slave MySQL databases involves replicating and copying database files across multiple servers in a network. Using this setup, the master server serves as a redundancy and fault-tolerance mechanism in the event of a failure, the slave
Mysql | #1553 – Cannot drop Index
Issue: #1553 – Cannot drop index ‘index_name’: needed in a foreign key constraint An issue is generally faced when we are going to drop a unique index from a table. For example, here I have the table articles that have
How to Run Multiple versions of MySQL on the Same Server?
Solution: If your system is having a current version of MySQL installed i.e 5.6 and you also need 5.5 version then follow the below steps. You can also play with different versions also. Installing Docker To install Docker on your
MySQL: only_full_group_by issue on joins
Issue #1055 – Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column xxxx which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by After upgrading ubuntu 14.04 to
PHP: mysqli_multi_query stops the execution of further MySQL queries.
The mysqli_query statement Generally, we use mysqli_query to execute Mysql queries in PHP. We can use multiple mysqli_query statements to execute multiple operations like insert, update, and select. Sometimes, we store records in more than one table during save operation