Hi, Now I found this line the MySQL Manual:
" If you run mysqldump without the --quick or --opt option, mysqldump will load the whole result set into memory before dumping the result. This will probably be a problem if you are dumping a big database. As of MySQL 4.1, --opt is on by default, but can be disabled with --skip-opt. " So, I got to import the data with the following mysqldump line: mysqldump --skip-opt --add-drop-table --default-character-set=latin1 dbname > dbname.sql thanks, Ronan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]