From: Stephen Sunderlin (stephen.sunderlinverizon.net)
Date: Tue Feb 19 2008 - 01:15:03 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This works fine for me:

http://www.mysql.com/products/tools/administrator/

-----Original Message-----
From: Esbach, Brandon [mailto:Esbachbtycoelectronics.com]
Sent: Monday, February 18, 2008 12:22 PM
To: richardhphpguru.org
Cc: MySQL User Group
Subject: RE: Backup table structure, not data

I ended up using mysqldump, worked well enough for what I was doing.
I have to admit, I'm really surprised there's no way to do this directly
in the admin gui that comes with MySQL though :).

Thanks all for the replies!

-----Original Message-----
From: Richard Heyes [mailto:richardhphpguru.org]
Sent: 18 February 2008 11:24
To: Esbach, Brandon
Cc: MySQL User Group
Subject: Re: Backup table structure, not data

> Is there any way to backup a complete database structure
> (tables/fields/indexes/etc), without the data? Or even get a creation

> script per table?
>
> At present the only way I can think of is to restore a backup to
> another server and just delete records (a legacy database with data
> hitting over 12GB, might take some time) - but there's gotta be an
> easier way to do it...

mysqldump has a --no-data option. Try "man mysqldump" (assuming your
MySQL server is Unix based.

--
Richard Heyes
http://www.websupportsolutions.co.uk

Knowledge Base and Helpdesk software hosted for you - no installation,
no maintenance, new features automatic and free

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=stephen.sunderlinverizon.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]