- Install cPanel on a Virtual Server Running CentOS 6 with 7 Simple Steps
- Clear Your System Cache in Ubuntu with These Quick Steps
- Install MariaDB on CentOS 7 with these Simple Steps
- What is an A Record?
- Smartermail vs. Mailenable – What does it hold for you?
- Common Issues with Website Migration
- Tips to Evade Spamming
- Dirty Cow Vulnerability – Check How Dirty It Is?
- It’s Time to Update Your Server
- How to Change the Listening Port for Remote Desktop?
Tag Archives: WAMP
Today, we will learn how to save a MySQL database on Windows environment, after installing a web server WAMP. We will use a native tool that comes with MySQL i.e. MySQLDump.
In this tutorial, we are going to use WAMP 2.5 and will name the backup as “mydb”.
We will have to open a Windows command prompt. Building on the executable “mysqldump” then can quickly backup a database.
cd "C: \ wamp \ bin \ mysql \ mysql5.6.17 \ bin \"
mysqldump.exe -u root -p mydatabase> C: \ Backup \ mabase.sql
Enter password: ****************
We jump by assigning the directory where the executable file is located and then mysqldump.exe with the –u option to the user name, –p option to be asked the password and following your options as it is necessary to indicate the name of the database. Then the end of the line to record the output to a file named “mabase.sql” and located the directory “C:\Backup”.