I am dealing with a large mifos Database. I have an archive in SQL that is almost 500MB in size.
In the past I have archived large DBs with msqldump -tab which exports each table separately and then import using mysqlimport. The advantage is dealing with smaller files. When I tried mysqlimport with the resulting dump - it failed due to foreign key constraints. I found some comments online that mysqlimport does not support ignoring these. Anyone have any ideas to enable mysqlimport or that would avoid enormous SQL text files for mifos archiving?
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
