did you get this to work? I've never seen the "could not allocate" message, so I'd like to know the solution please.
As for the "no database selected" means that at the start of the script should be a USE XDATABASE; This is common as a mysqldump does not specify the database, so you need to specify that at the start. Michael Dinowitz wrote: > I've got a sql dump for a mysql database and I don't seem to be able > to import it. I'm using the mysql workbench and whenever I try to run > the sql script, I get > could not allocate 536870912 bytes to read file "c:\temp\gcd.sql" > > I tried to import from disk and I always get > error 1046 (3d000) at line 22: No database selected > > I know that the sql file is good as I downloaded it from a reputable > source. Any idea where I'm going wrong. > > Thanks > > -- > Michael Dinowitz > Lead Author - Adobe Coldfusion Anthology > http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3357 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
