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]
> 

Reply via email to