I used to have a lot of problems trying to concatenate the data files from the SQL dumps using Windows XP as an OS but thanks to Brion Vibber and other I figure it out.

What I did to solve it is use Cygwin:

Download and install Cygwin.

Open Cygwin by clicking on the icon from your desktop and go to the location of your hard drive where the split files are situated.

To concatenate multiple files into a single file you could do: $ cat xaa xab xac xad xae > old_table.sql.bz2 or $ cat xa? > old_table.sql.bz2

The name �old_table� is an arbitrary name and has no real importance.

To extract the file you can use Bzip2 with this command: $ bzip2 �dc old_table.sql.bz2 > old_table.sql

To perform both tasks in one command you can do: $ cat xa? | bzip2 �dc > old_table.sql

Claudio

--- Timwi timwi@gmx.net wrote:

Stuart Ayre wrote:

...

What can I use to join the SQL dump files?

In Linux/Unix: cat (e.g. cat xa xb > target_file.sql)

In Windows/DOS: copy (e.g. copy xa+xb target_file.sql)

Timwi

---

Wikitech-l mailing list Wikitech-l@wikimedia.org

http://mail.wikipedia.org/mailman/listinfo/wikitech-l

______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca

On Mon, 2 Aug 2004, Timwi wrote:

Stuart Ayre wrote:

...

What can I use to join the SQL dump files?

In Linux/Unix: cat (e.g. cat xa xb > target_file.sql)

In Windows/DOS: copy (e.g. copy xa+xb target_file.sql)

Under Windows, use the /b switch to ensure that no funny cr-lf translation will occur:

copy /b xa+xb+xc target.sql

Alfio