* 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
