When moving mysql database from one server to another or, to test that the data backup works as expected we need to import mysql dump file in the testing environment. Create the database (test-database) in the testing environment and identify the location of the .gz or .sql file. If the mysql dump was a .gz file, you need to gunzip to uncompress the file by typing $ gunzip mysqldump.sql.gz This will uncompress the .gz file and will just store mysqldump.sql in the same location. (more…)

Mysql Tips for Beginners * How to log into Mysql from command prompt? First, Go to the Mysql installation directory and move to the bin directory (C:\Mysql\bin\) Execute the following command to log into Mysql C:\Mysql\bin> mysql -u [username] -p [password] You will be shown mysql command which indicates that you have successfully logged in mysql> _ (more…)