1
I'm test-driving a piece of MySQL backup software that first downloads all the individual tables from a MySQL database as separate text files and thereafter only downloads those tables that have changed.
Each text file looks similar to this:
#-- deleting current 'profession' table
drop table if exists profession;
#-- export table structure for 'profession'
CREATE TABLE `profession` (
`prof_id` int(4) NOT NULL auto_increment,
`prof_name` varchar(100) NOT NULL default '',
PRIMARY KEY (`prof_id`)
) TYPE=MyISAM;
The software manages backups and restores to the original on-line database, but I also want to be able to populate a local MySQL database from the latest backup, in case I need to do any substantial work on the site off-line.
My problem is I can't see a way to import 30 or so separate SQL table files in PHPMyAdmin, other than doing so one at a time.
Does anyone know if there's a utility that would concatenate them into one SQL file?
A thread is for life. Not just for Christmas.