Results 1 to 3 of 3
Jan 25, 2012, 02:34 #1
Restoring SQL from multiple SQL files
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.?
Jan 25, 2012, 09:13 #2
- Join Date
- Feb 2005
- Burlington, Canada
- 89 Post(s)
- 6 Thread(s)
Do you still have access to the database holding these records? If so you can download MySQL Workbench and export the database as a single file, which you can then either import or execute as a script?
Jan 25, 2012, 17:06 #3
Try this one:
1. Go to Google, and type import mysql by ssh.
2. Then use some tool rename file to sql1 to sql400.sql
3. Write a loop on PHP or Perl to run that command import or just simple:
open notepad, type the command:
then copy and paste it on your SSH , enter, they will run line by line for you automatic.