Backup DB from MYSQL command prompt

Question

I recently tried to put my web application and mysql database on the same virtual server. Now I receive a port error. In order to fix the port issue, I want to back up the database and reinstall WAMP. Since I can't get to the phymyadmin, I have to use the mysql command prompt to do a dump.

Would anyone happen to know the EXACT command to put in, if my username is root, I have no password, and the database name is dev? I've tried it multiple ways and I get an error saying that my syntax is wrong.

Thanks in advance.

Community · Accepted Answer · 2017-05-23 12:33:04Z

4

You can use the following command provided you know the name of the database:

mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Alternatively I would install the MySQL Workbench which can connect to your local database instance and provides a GUI to run the export: MySQL Workbench.

Unfortunately if you've uninstalled WAMP then MySQL might not be running anymore, and the above commands will not work because the utilities cannot see the database. If this is the case, try installing WAMP to a new directory and manually copying over the MySQL data files:

How to restore MySQL database from WAMP?

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Jan 13, 2015 at 22:21

citizenen

7036 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Demetrick Norris Over a year ago

MySQL Workbench worked great. The command lacks a good interface and instruction. When I entered the command, nothing happened. No error, and no creation of a dump file. GUI all the way.

citizenen Over a year ago

Glad that worked for you! No better GUI tool for working with MySQL imo.

Nikola · Accepted Answer · 2015-01-13 22:24:17Z

2

mysqldump -u root -p dev > devBackUp.sql

answered Jan 13, 2015 at 22:24

Nikola

1311 silver badge6 bronze badges

Comments

Alejandro Aranda · Accepted Answer · 2016-08-16 08:50:46Z

0

DOS batch file to export the database with date and time in the filename

FOR /f "tokens=1-8 delims=:./ " %%G IN ("%date%_%time%") DO (
SET dt=%%G%%H%%I_%%J_%%K
)
mysqldump -u root -p[root_password] [database_name]> [database_name]_%dt%.sql
pause

answered Aug 16, 2016 at 8:50

Alejandro Aranda

7599 silver badges18 bronze badges

Collectives™ on Stack Overflow

Backup DB from MYSQL command prompt

3 Answers 3

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Linked

Related