On 26-Jul-2003 Priscilla Walther wrote:
>
> 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.
>
> Is there some kind of export command that will expor
ay to alias the name of the
'CREATE TABLE' column that is returned?
SHOW CREATE TABLE mytable
- Original Message -
From: "Jackson Miller" <[EMAIL PROTECTED]>
To: "Jim McAtee" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
> Sent: Friday, July 25, 2003 11:39 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: How to export db or table structure?
>
>
> > 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 ta
mysqldump --opt
-Jackson
On Friday 25 July 2003 10:39, Jim McAtee wrote:
> > 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 d
> 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 w
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 se
