* Bogdan Stancescu > I'm curious about this issue too - does the third line in your > code take care of the table structure as well?! > > I'm also wondering how one could duplicate a whole database (for > backup purposes in my case).
> Roger Baklund wrote: > > create database new_db; > > use new_db; > > create table new_table select * from old_db.old_table; I suppose that by 'table structure' you mean the order of the fields, in my experience the order is maintained. The backup question: <URL: http://www.mysql.com/doc/D/i/Disaster_Prevention.html > <URL: http://www.mysql.com/doc/m/y/mysqldump.html > <URL: http://www.mysql.com/doc/m/y/mysqlhotcopy.html > <URL: http://www.mysql.com/doc/B/a/Backing_up.html > (For InnoDb) -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
