What can I use to join the SQL dump files?
many thanks
Stu
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
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
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
Claudio V wrote:
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
Note that UnxUtils also has cat and bunzip2, which may be more convenient than Cygwin for some people:
http://unxutils.sourceforge.net/
-- Tim Starling
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
wikitech-l@lists.wikimedia.org