Dump / restore rows in table?

I did try to find out how to do this in the manual, but row and table occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm guessing I'd try mysqldump -u root -pPASSWORD database_name table_name and then add something to

Re: Dump / restore rows in table?

In the last episode (Oct 07), John Oliver said: I did try to find out how to do this in the manual, but row and table occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm guessing I'd try mysqldump -u root -pPASSWORD

RE: Dump / restore rows in table?

860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -Original Message- From: John Oliver [mailto:joli...@john-oliver.net] Sent: Wednesday, October 07, 2009 12:29 PM To: mysql@lists.mysql.com Subject: Dump / restore rows in table? I did try to find out how to do this in the manual

RE: Dump / restore rows in table?

-Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Wednesday, October 07, 2009 2:15 PM To: 'John Oliver'; mysql@lists.mysql.com Subject: RE: Dump / restore rows in table? [JS] I should have mentioned that you can do this even if you are creating a table