Import MySql DB just tables without field values

Question

Is it possible to copy all my DB tables to another DB but without the field values. Soo an empty DB just with tables names and links.

My situation :

I'm developing a web page with a DB(MySql Workbench) in parallel. In that DB I put only fake information and did on local on my PC.

Soo now its time to do it in real with real information >< Soo I wanna tranfert only the tables of my DB in the new server, a copy wouldn't be fine becaucse it will copy also all the fake values :/

Soo is it possible ?

ps : I can't delete all my values because of all PK et FK constraint I declared -_-

If you're very good with SQL you could copy the system-catalog, which copies the schema of the tables, but not the data. And there are most likely tools to do the same... — SingleStepper
– SingleStepper, Commented Aug 1, 2014 at 11:24
I don't use workbench but I'd be surprised if this wasn't a simple setting within the export tools. — Strawberry
– Strawberry, Commented Aug 1, 2014 at 11:27

Michael Bearjaws · Accepted Answer · 2014-08-01 11:24:32Z

1

There are several ways to go about this.

Use SHOW CREATE TABLE db.tableName; to get the structure of the table, repeat for all tables needed.
Use MySql dump to dump the table structure which looks like this

mysqldump -d -h localhost -u root -p databasename > dumpfile.sql

answered Aug 1, 2014 at 11:24

Michael Bearjaws

2011 silver badge4 bronze badges

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

3 Comments

Booba__2012 Over a year ago

I'm to scared to use the mysqldump >< I will go with the "show create table", Thx ^^

Booba__2012 Over a year ago

Is it normal I get : ENGINE=InnoDB AUTO_INCREMENT=317 DEFAULT CHARSET=utf8 at the end of each result ?

Michael Bearjaws Over a year ago

Yes, the ENGINE is what tells mysql which Storage Engine to use, AUTO_INCREMENT tells MySql what value to start the AUTO_INCREMENT at (you can change this to AUTO_INCREMENT=1 if needed), CHARSET tells MySql how you are going to store text in the database, in this case utf8. Read up on character encoding here.

VMai · Accepted Answer · 2014-08-01 11:24:45Z

0

You could use mysqldump with the no-data option

mysqldump --no-data

mysqldump

--no-data, -d

Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).

answered Aug 1, 2014 at 11:24

VMai

10.4k9 gold badges28 silver badges36 bronze badges

Comments

Jens · Accepted Answer · 2014-08-01 11:25:02Z

0

You can make a dump from your database without data. See the mysql documentation. There is a switch --no-data which dumps only the table structure:

--no-data, -d

Do not write any table row information (that is, do not dump table contents). This is useful if you want to dump only the CREATE TABLE statement for the table (for example, to create an empty copy of the table by loading the dump file).

answered Aug 1, 2014 at 11:25

Jens

69.6k15 gold badges107 silver badges133 bronze badges

Collectives™ on Stack Overflow

Import MySql DB just tables without field values

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related