If you are used to Linux/Unix based environments using the command line on Windows could get a bit tricky. Here are some steps as a reminder of using mysqldump on WAMP.
Accessing MySQL shell in WAMP
In this article we are working with WAMP 3 - WAMPSERVER (64 BITS & PHP 5.6 & PHP 7) 3.
As of 01.08.2016, the package includes:
64 bit WampServer 3.0.4:
- Apache 2.4.18
- PHP 5.6.19/7.0.4
- MySQL 5.7.11
Operating system: Windows 10
System type: 64-bit
Logging in to MySQL from the Windows Command Prompt
To access mysqldump program change directory to the WAMP server’s binary folder:
Then log in:
mysql.exe -u root
You might be asked for a password as the next step.
From WAMP's UI
Open WAMP’s pop up navigation by left clicking on the WAMP icon in your system tray and navigate to MySQL > MySQL console
Using mysqldump on WAMP
To access mysqldump program, change directory to the WAMP server’s binary folder:
To use the mysqldump program:
mysqldump -u mysqlusername -p databasename > c:\wamp64\www\siterootfoldername\databasedumpfilename.sql Enter password:
mysqldump -u root -p my_database > c:\wamp64\www\projectrootdirectory\dbdump_date.sql
- ! TIP ! -
To get back to the root directory on Windows:
cd\ // (same as cd ~ in Unix/Linux)
How to dump MySQL database on WAMP: https://snippetsofcode.wordpress.com/2011/08/02/howto-dump-mysql-database-on-wamp/
Setting up multiple projects in WAMP 3 with aliases
Local development environment
When you have to set up a development environment quickly on a Windows...
My often used MySQL commands
Basic MySQL commands
Basic commands for managing databases in MySQL on the command-line in local...
‘mysqldump Version Mismatch’ warning from MySQL Workbench
Changing the path to mysqldump program file
How to make sure that the mysqldump.exe version of MySQL Workbench is equal...