MySql Tutorial : mysqldump utility in mysql

The mysqldump client is a backup program o It can be used to dump a database or a collection of databases for backup or transfer to another SQL server (not necessarily a MySQL server). The dump typically contains SQL statements to create the table, populate it, or both. However, mysqldump can also be used to generate files in CSV, other delimited text, or XML format.


To take dump of a mysql table use below command
-------------------------------------------------------
~/mysql/bin/mysqldump -u root  database_name ORDERS > orders.txt

1.  command to dumb  only tables definitions , not the data “ use –d command”  if path is not set then you need to run that command from mysql/bin directory

./mysqldump -d -u root database_name  ORDERS , CLIENTS , COMPANY  > ~/tmp/test.database.sql

2. Command to recreate table from that file

mysql -u root database_name < ~/tmp/test.database.sql


hope this would be useful. if you have not read my other MySQL command tutorials , you can see it here

MySQL tutorial and commands part 2
MySQL tutorial and commands part 3
MySql Tutorial : mysqldump utility in mysql
MySQL tutorial and commands Part 1

Difference between truncate and delete in SQL

Basic and Advanced SELECT command example

How to manage transaction in MySQL

Do you like Books?

If you love to read books here are few Java titles which is worth of money :

Effective Java by Joshua Bloch , Head First Design Pattern by Kathy Sierra , Head First Object Oriented Analysis and Design , Java 5.0 Tiger: A Developer's Notebook and Java Performance by Binu John

Please vote +1 or consider sharing if your like this article