is this possible in MySQL?????

[Anon]

Hello All,
i have a question regarding mysqldump in mysql
i have a database 'test' with 2 tables 'bugs' and 'dailyreport' in one machine
i want to dump this data into another machine but i only want the contents of 'dailyreport' to be loaded in another seperate databse not in test
how am i to do it?
is it possible to get the data of a particular table from 1 database to put in another database????????
any help appreciated
Regards
Roopa

[Anon]

Well,

usage for mysqldump is;

mysqldump [OPTIONS] database [tables]

So, a mysqldump -u<user> -p<pass> <dbname> <table> >dump.sql

Will store the 'create' statement, and all data from table <table> into dump.sql. If you don't want the table to be created, add -t or --no-create-info to the mysqldump command. Now transfer this file to the remote host, and load it back into mysql;

mysql -u<user> -p<pass> <database> < dump.sql

[Anon]

Hi
thanks ! it worked !
Regards
Roopa