On Mon, Dec 22, 2003 at 08:14:51PM -0300, Lucas Lain wrote: > > If it's a plain text dump, make a copy of the backup file. Edit the > > copy and delete everything that doesn't relate to the database to be > > restored. > > it's quite large to do this ...
Maybe you could try getting the line numbers for the data you want using grep (be sure to anchor the patterns with ^ to make the search faster), and then extract the data using either awk (see NR) or perl (see $.). This way you don't have to open the dump with an editor, which would load the whole file in memory. -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "La fuerza no está en los medios físicos sino que reside en una voluntad indomable" (Gandhi) ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])