To scale your system and ensure redundancy, you can set up MySQL replication. MySQL replication allows one database server (primary/master) to replicate its data to one or more secondary/slave servers.
I usually import my SQL files from phpmyadmin, but when files are huge sometimes it gets hard to import the SQL files. Use this command to import your SQL files
I wanted to explain the main differences between these commands in a table format. Difference Between DROP, TRUNCATE and DELETE Commands The following table shows the what are DELETE, TRUNCATE,
If you want to change the SQL mode that MAMP Free is running follow these easy steps to do so. 1. Quit MAMP (stop the servers) 2.Run following command in the terminal -
I recently had a database with the latest MySQL which does not use the traditional mysql_native_password so I had to alter my user via the terminal to change the type.
