CODEWITHSUNDEEP
mysqldatabasedump
Muhammed Bhikha
Muhammed Bhikha

Reputation: 4999

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

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

Upvotes: 2

Views: 1060

Answers (2)

damiankolasa
damiankolasa

Reputation: 1500

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

Upvotes: 4

boruch
boruch

Reputation: 463

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).

Upvotes: 1

Related Questions