I'm a beginner - but can't you also use mysqlimport?
Not in the case when you have made a backup using mysqldump while using the default options. mysqlimport is a front end for LOAD DATA INFILE (http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html)
It is usefule when you have data in a flat file (for example rows seperated by newlines and columns seperated by comma or tabs). If you need data in this format, you have to specify different options to mysqldump (more specifically -T option and --fields-terminated-by=... --fields-enclosed-by=... --fields-optionally-enclosed-by=... --fields-escaped-by=... --lines-terminated-by=... )
see http://dev.mysql.com/doc/mysql/en/mysqldump.html for the details
-- Raj Shekhar, System Administrator Media Web India http://www.netphotograph.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
