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