Re: how to copt table not whole database

Thank you Shawn. What I originally thought is that if there is any command like 'sqldump' to copy a few tables of a database. Xiaobo Xiaobo Chen [EMAIL PROTECTED] wrote on 01/16/2006 03:33:36 PM: Hi, all How should I copy a table of a database? Thanks in advance. Xiaobo -- Faculty of

Re: how to copt table not whole database

Xiaobo, Using mysqldump, you can specify which tables to copy. The man for mysqldump is as such: mysqldump [options] [dbname [tablename]] Say db 'db' has tables x, y, and z in it. You only want to copy table x. mysqldump db x x.sql(or whatever you want to name it). Dan Thank you

Re: how to copt table not whole database

Dan, thank you very much. That's what I want. Xiaobo Xiaobo, Using mysqldump, you can specify which tables to copy. The man for mysqldump is as such: mysqldump [options] [dbname [tablename]] Say db 'db' has tables x, y, and z in it. You only want to copy table x. mysqldump db x

how to copt table not whole database

Hi, all How should I copy a table of a database? Thanks in advance. Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: how to copt table not whole database

Xiaobo Chen [EMAIL PROTECTED] wrote on 01/16/2006 03:33:36 PM: Hi, all How should I copy a table of a database? Thanks in advance. Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada Do you want the data or the structure too? Just the data: