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). Bogdan Roger Baklund wrote: > * saraswathy saras > > how to copy table from one database to another database,is it possible. > > If the table type is MyIsam, you can copy the tables on the OS level. > > You can also execute some commands like these: > > create database new_db; > use new_db; > create table new_table select * from old_db.old_table; > > You would also need to add any indexes defined for old_table to new_table. > > -- > 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 --------------------------------------------------------------------- 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
