Joining .sql files

Hi, I got a automated backup of my database of my site...

It is all in a .zip file and when I open it I get the files on the screenshot below...



My question now is: How do I join all these sql files into 1 sql file or 1 gzip file?


Thanks for the help

Peace

 

I expect the application you exported from would import from the zip file. If you need it to be one file for some other purpose you can cut and paste the content of each file into a single file manually or write some code to do it.

 

1. unzip files
2. type *.sql > all_in_one.sql

 

I assume you run that from a command prompt but I get a blank file or an error when I try variations of your step 2.

 

I haven't done *nix file handling for ages, but how bout

cat *.sql > all_in_one.sql

Code (markup):

 

OK thanks, worked