How to dump mysql table structure without data, and some static tables with data

Question

I want to import my SQL database with below two conditions

Import data and structure for some static tables.
Import structure only for all the tables which are not static means tables values are get updated after moving an application from one server to another server.

Can any one know the SQL command to dump the database with above-matching conditions?

treyBake · Accepted Answer · 2017-07-18 11:14:52Z

4

there is a no data parameter for this:

mysqldump -uroot -p --no-data dbname > db.sql

this will export your database with no data to a file called db.sql

you can go onto specify tables after dbname

mysqldump -uroot -p --no-data dbname tbl1 tbl2 > db.sql

To import the files you do:

mysqldump -uroot -p dbname < db.sql

or you can use:

mysql -uroot -p dbname and then after logging in: source /path/to/db.sql

you don't need to specify tables because it's all inside the .sql file

edited Jul 18, 2017 at 11:14

answered Jul 18, 2017 at 11:06

treyBake

6,5698 gold badges28 silver badges64 bronze badges

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

2 Comments

omprakash sharma Over a year ago

The above command will import structure but, while performing import operation I want to import both data and structure to my static table named country.

treyBake Over a year ago

if your table country is in the sql dump then it will be imported? Or you can use the second command to get country as an individual .sql file and source it in mysql command line (will update answer on how-to)

Mohammed Athar Imran Ahmed · Accepted Answer · 2017-07-18 11:04:00Z

-2

(1)

Open Sql Server Managment studio
Right click database → Tasks → Generate Scripts → Choose DB → Change “Script Data” option to true → …
Right click database → Tasks → Backup → ...

(2)

select *
from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME='tableName'

answered Jul 18, 2017 at 11:04

Mohammed Athar Imran Ahmed

6853 silver badges11 bronze badges

5 Comments

treyBake Over a year ago

your second option won't export it - just show it - also not everyone uses SQL Server Management Studio - in fact I didn't even know it existed.. but to be fairs I'm an anti-ui guy :p

Mohammed Athar Imran Ahmed Over a year ago

i suggest you to don't downvote any answer. As this will discourage a person to answer.

treyBake Over a year ago

we downvote when the answer is bad, I mean no offense honestly but to keep SO clean and what not we need to downvote bad answers. This is a benefit though as it allows you to learn from it :)

Mohammed Athar Imran Ahmed Over a year ago

@ThisGuyHasTwoThumbs It not necessary. You can upvote if the answer works for you. otherwise leave it. By the way this answer is not completely bad as it not answering totally out of context.

treyBake Over a year ago

it is - that's why the functionality is there, don't take it to heart man :) and it kind of is, your solution is for one application and your second solution selects data, it doesn't export it. This means this isn't an answer at all, if you get my meaning? It's out of context because it it doesn't answer the OP's question

Collectives™ on Stack Overflow

How to dump mysql table structure without data, and some static tables with data

2 Answers 2

2 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related