Mysql : Dump/Exports existing data to a .sql file

Question

I have a database. All I want to do is dump ALL the existing data in every table to I can then use it to simply import the SQL to my new database?

Im presuming the dump will be a bunch of MySQL INSERT statements

Harper Shelby · Accepted Answer · 2012-11-28 19:22:54Z

4

You can also use mysqldump, native mysql tool for this purpose.

edited Nov 28, 2012 at 19:22

Harper Shelby

16.6k2 gold badges47 silver badges52 bronze badges

answered Nov 28, 2012 at 19:22

damiankolasa

1,5209 silver badges8 bronze badges

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

2 Comments

Malkus Over a year ago

Example: mysqldump -u username -p db_name > dump.sql

damiankolasa Over a year ago

-p stands for password :) without a space :).

boruch · Accepted Answer · 2012-11-28 19:21:19Z

1

You can use a tool such as mysql workbench or phpmyadmin to create the dump. It will be a bunch of inserts as well as all the other data in it (such as procedures).

answered Nov 28, 2012 at 19:21

boruch

4633 silver badges16 bronze badges

Collectives™ on Stack Overflow

Mysql : Dump/Exports existing data to a .sql file

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related