From: Richard Heyes (richardhphpguru.org)
Date: Mon Feb 18 2008 - 05:24:21 CST

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

> 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

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