Welcome to WebmasterWorld Guest from 22.214.171.124
1. .sql files *are* text files. Export to .sql file from your DB1 and open it with NotePad or a text editor, and try to understand what's going on inside. Check out different .sql files that are created as a result of choosing different options. I had a real "a ha" moment the first time I did that.
2. create a duplicate temp database for playing and testing, exporting from DB1 and importing to DB1_test on the same machine, for example. Make sure you play with and understand the options, like "add 'drop table.'" Change some data in the tables, and upload again--understand how some data can be overwritten and some can't.
down the page it talks about "SELECT ... INTO OUTFILE" that is what you need to get the info out and then you can use load data infile to bring it back in.
If that doesn't work then you could write a script to get the data and write it to a file and then get a script to insert it as well.