create dump file from database in mysql

Question

mysqldump --host=localhost --user=root --password=sysadmin --no-data test > "C:\test1\ttt.dump";

This the command that i fire to create dump from mysql database , that's working fine and create dump with no data.

but I want some table with data , this command create dump with table that all are blank.

Removing the no-data switch would be a wild guess of mine. — Bobby
– Bobby, Commented Sep 27, 2010 at 7:25
@Bobby: How about making that an answer so you can collect points for it? — Aaron Digulla
– Aaron Digulla, Commented Sep 27, 2010 at 7:37
@Aaron Digulla: I was not sure if it is an answer. The description of the flag is a little vague. — Bobby
– Bobby, Commented Sep 27, 2010 at 8:20

Bobby · Accepted Answer · 2010-09-27 08:21:33Z

4

Removing the no-data switch would be a wild guess of mine.

answered Sep 27, 2010 at 8:21

Bobby

11.6k5 gold badges48 silver badges70 bronze badges

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

Comments

Rupeshit · Accepted Answer · 2010-09-27 07:42:11Z

2

You can create dump of whole db using this command

     mysqldump -uUserName -pPassword --add-drop-database --add-drop-table --hex-blob SchemaName > FileName.sql

Just enter proper UserName,Password SchemaName and filename.

answered Sep 27, 2010 at 7:42

Rupeshit

1,4661 gold badge14 silver badges23 bronze badges

Imre L · Accepted Answer · 2010-09-27 08:07:11Z

0

There is no possibility to do it with 1 command, but theres a way to get creative.

Now you have 2 options:

Open the second dumpfile in editor and use find/replace option to replace CREATE TABLE with CREATE TABLE IF NOT EXISTS or
When importing the second file with data use a --force option when importing the dump file

answered Sep 27, 2010 at 8:07

Imre L

6,29126 silver badges32 bronze badges