Restoring SQL from multiple SQL files

Question

I have a database backup with 400+ sql files. foreach table there is a separate sql file. Is it possible to import all this files together to a database? If so could you tell me how to do this?

Also the backup is a gzipped tar file. Is there a way to restore from a compressed file.?

Answer 1

If you are using linux Concatenate all the sql files using and

cat *.sql > fullBackup.sql

then you can restore the database using this backup file

Answer 2

I have found the answer for my question here. Import Multiple .sql dump files into mysql database from shell

find . -name '*.sql' | awk '{ print "source",$0 }' | mysql --batch works perfectly. Thanks for @Haim to pointing out the correct post.