MySQL update table based on value of another table Join

While working on MySQL, sometimes we need to update the table values based on the values of another table. In this case, we can update the table value by joining from another table. MySQL table join Here, I have done this as follows: For example, we need to update the value to table2 from the … Read more

How to check the Public IP: Mera Wala IP

Working on the internet or in general troubleshooting, we wanted to know the IP address, But you know how to check the IP public address. What is IP Address and MAC Address Here, we will show how to check the IP address from MeraWalaIP.com: How to check the Public IP merawalaip.com : You can check … Read more

How to fix WordPress 404 Errors, requested URL was not found on this server: Home Page works

We often find the issue of the WordPress page not found 404 error when we move the WordPress to another new server. Here will see how to fix the issue.How to install WordPress.com desktop app on Ubuntu Error: The requested URL was not found on this server. There could be multiple solutions you can find … Read more

How to set up multi-master slave in MySQL

Today, We will see how to set up a multi-master slave in the MySQL replication process. Read more: Replication with Different Master and Slave Storage Engines Also Read: Reset ( Re-Sync ) MySQL Master-Slave Replication MariaDB 10 supports multi-source replication, and each MariaDB Galera node can have up to 64 masters connected to it. So … Read more

MySQL: How to ignore errors when importing data?

Recently, I faced an issue while importing data to MySQL. Here are the steps that help me to solve and ignore the error. Read more: show progress on MySQL DB Import Use the –force (-f) flag on your MySQL import. Rather than stopping on the offending statement, MySQL will continue and just log the errors … Read more