Export dump file from MySql

mysql dump workbench
frazman picture frazman · Sep 15, 2011 · Viewed 89.4k times · Source

I want to create a dump file of a table in the database. So database --> king, tablename --> castle So what I want to do is create a dump file.. and then the next part is to import it in my local host. database name --> king_local. Any ideas on how to go about this!! Thanks

Answer

Mohit Jain picture Mohit Jain · Sep 15, 2011

To export:

 mysqldump -u mysql_user -p DATABASE_NAME > backup.sql

To import:

 mysql -u mysql_user -p DATABASE < backup.sql

Related questions

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this MDB file into a MySQL database for importing so I don't have to go through the CSV step. I would …

Read More
Dump File MySQL 5.6.10

I was trying to create a dump file from my MySQL database, but when I try it always gives me this error Operation failed with exitcode 2 16:06:07 Dumping proactivetraindb (userstate) Running: mysqldump.exe --defaults-extra-file="h:\docume~1\anarita\locals~1\temp\tmpde5rwy.…

Read More
create dump file from database in mysql

following is the that I create dump from mysql database. mysqldump -u root tempbkk > ttt.dump but I want to create a dump that exclude one or more file while creating dump from database we select.What is the …

Read More