From: John Oliver (joliverjohn-oliver.net)
Date: Wed Oct 07 2009 - 11:28:51 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]