How to dump one table data from mysql database, not whole database?
thanks
DROP TABLE 'table_name'
sorry to let you misunderstand my question. I mean how I can transfer one table from one database into other database in other server?
run 'mysqldump --help' from command line, it is all explained there.