Use MySQL dump command to backup & restore any database

MySQL offers an easy way for both backup and restore either a single database or the entire databases via “mysqldump” command. Learn how to use this command is essential to clone a database from one host to another or backup your databases regularly. Where to locate “mysqldump” command To find the location of ‘mysqldump’, open…

MySQL Character Sets & Collation

In this post, we will focus on a specific type of character set and encoding, MySQL CHARSET & COLLATION.  I also recommend checking out the earlier post on character encoding for beginners. Have you ever wondered why some non-English characters with accents or Chinese characters such as “豆贝尔维 ” showing as question marks ���� on…