Are you just trying to copy a subset of one table into another? If so, simply do this:
CREATE TABLE new_one SELECT * FROM old_one LIMIT 1000,5000; That will create a table with the same columns, but no keys or such. If you want to copy the key structure, it will take you two commands: CREATE TABLE new_one LIKE old_one; INSERT INTO new_one SELECT * FROM old_one LIMIT 1000,5000; If you want a random selection (say 1% of your original records), use ... WHERE RAND() < .01; Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 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, 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=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
