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/[EMAIL PROTECTED]