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 specify rows 1000-1050. And then I'm guessing that mysql < result.sql would restore? Or would it not know what table it came from, and I'd have to specify that? -- *********************************************************************** * John Oliver http://www.john-oliver.net/ * * * *********************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
