MySQL

MySQL is an extremely popular database engine on windows today and a common question our team fields is "How do you backup mysql databases on windows?"    The easiest way to backup a database on windows is using the mysqldump command. you'll execute the command as follows:   mysqldump database-name > database-script.sql -u USERNAME -p [...]

This article is to demonstrate how to use MySQL Front software to connect to a MySQL database and also to export and import a database from one MySQL database host to another.   MySQL Front is a freeware GUI client for interfacing with MySQL databases that you download on your computer. Download it directly from their [...]

HeidiSQL is a free tool that can be downloaded from: http://www.heidisql.com/download.php       How to Export a MySQL database using HeidiSQL First, connect to your database in HeidiSQL.   Replace the Hostname, User, and Password fields with your database server and login details:             Once connected, RIGHT-CLICK on your [...]

Open a command prompt on your Windows server and enter the following: (replace the values with your MySQL username, password, and database name)   mysqlcheck -u<USERNAME> -p<PASSWORD> --databases <DB-NAME> (Note there are no spaces before the username and password)   This will then check your database and if you do have a corrupt table you [...]