467,161 Members | 929 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,161 developers. It's quick & easy.

How to export db or table structure?

Hi All -

I'm a newbie to the database area, but have inherited a MySQL database to
manage along with my development duties.

We have a very large MySQL database, and the designer of the database no
longer works for us. I need to re-create the same table structure, but
without the content, on a separate machine.

I know I can do a show tables on the existing db, and also a describe on
those tables, so I know what the table structure looks like. I am trying to
avoid having to re-type the create table statements for each table.

Is there some kind of export command that will export that info to a file
without the contents of the tables themselves?

The current MySQL server version is 3.23.2-alpha-log. It is running on
SunOS 5.6 (i386).

If it matters, the new box will be a dual proc linux server, probably
running RedHat 6.x or 7.x. We want to start with an empty database on that
box.

Sorry if this is a faq, but I didn't see it listed anywhere.

Pris




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
  • viewed: 7363
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by gdubois@deloitte.vg | last post: by
1 post views Thread by Andrew Arace | last post: by
2 posts views Thread by David Richards | last post: by
1 post views Thread by manmit.walia@gmail.com | last post: by
2 posts views Thread by manmit.walia@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.