No, I mean the type of the fields. When you create a table you have to define the field types -- char, varchar, stuff like that. Does your code take care of that?
Thanks for the links! Bogdan Roger Baklund wrote: > * 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 --------------------------------------------------------------------- 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
