Accessing MySQL shell in WAMP

System details

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:

cd wamp64\bin\mysql\mysql5.7.11\bin

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:

cd wamp64\bin\mysql\mysql5.7.11\bin

To use the mysqldump program:

mysqldump -u mysqlusername -p databasename > c:\wamp64\www\siterootfoldername\databasedumpfilename.sql
	Enter password:

Example:

mysqldump -u root -p my_database > c:\wamp64\www\projectrootdirectory\dbdump_date.sql

cd\ // (same as cd ~ in Unix/Linux)

Resources:

How to dump MySQL database on WAMP: https://snippetsofcode.wordpress.com/2011/08/02/howto-dump-mysql-database-on-wamp/