Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Richard Heyes (richardhphpguru.org)
Date: Mon Feb 18 2008 - 05:24:21 CST
> 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
mysqldump has a --no-data option. Try "man mysqldump" (assuming your
MySQL server is Unix based.
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