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(a)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(a)wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/wikitech-l
______________________________________________________________________
Post your free ad now!
http://personals.yahoo.ca