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.?

@Haim, thanks for pointing me the right post. I like the find method with awk script. It works perfectly. Many Thanks. — codlib
– codlib, Commented Jan 25, 2012 at 9:08

Naveen Kumar · Accepted Answer · 2014-03-17 07:42:33Z

10

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

edited Mar 17, 2014 at 7:42

answered Jan 25, 2012 at 8:50

Naveen Kumar

4,6011 gold badge20 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:46:40Z

3

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.

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Jan 27, 2012 at 5:35

codlib

6482 gold badges12 silver badges28 bronze badges

Comments

hekep · Accepted Answer · 2017-04-07 09:55:23Z

1

Nowdays processors have many cores. To use all the cores:

for s in *.sql.gz ; do   gunzip -c  $s | mysql -u sql_user -p'password' database_name  &   done

This command opens background process for each sql-dump file.

answered Apr 7, 2017 at 9:55

hekep

315 bronze badges

Comments

sneaky · Accepted Answer · 2019-12-02 13:01:45Z

0

Or, with pv installed, you can see also the progress by using:

pv -p *.sql | mysql database

answered Dec 2, 2019 at 13:01

sneaky

4471 gold badge9 silver badges23 bronze badges

Collectives™ on Stack Overflow

Restoring SQL from multiple SQL files

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related