This could be a case where your dump files are not split in such a way so that they honor the max_packet_length setting of the recieving server. Make sure you tell mysql dump what the maximum size of an INSERT statement will be for the server you want to read the dump into or it will put all of the data for the entire table into a single INSERT statement.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine matt_lists <[EMAIL PROTECTED]> wrote on 01/27/2005 01:13:21 PM: > Having repeatable problems doing restores, 4.1.8 and 4.1.9 both do the > same error > > Is there some setting I'm missing? > > mysqldump -u username-pPassword --all-databases --quote-names > > /intranet/backup/backup.sql > > > E:\intranet\backup>mysql -u xotech -pDaredevil22 -f < backup.sql > ERROR at line 2153: Unknown command '\m'. > ERROR at line 2153: Unknown command '\m'. > ERROR at line 2153: Unknown command '\m'. > mysql: Out of memory (Needed 626767192 bytes) > mysql: Out of memory (Needed 626763096 bytes) > > E:\intranet\backup> > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >