to all guru
i have a data more than 500k and when i try to dump it i got this error out of memory (needeed 82223224 bytes)
how can i increase the memory in mysql?
tia
Are you sure it's not PHP that needs more memory? PHP wouldn't know if MySQL was out of memory, and that message looks like an approximation to a PHP error message.
You should try to avoid reading in all the data at once. Any chance you could read/write/handle it a line at a time? It seems to me that 8MB is plenty of RAM to handle a 500K file but I don't know what you're doing.
i just executed the sql via command line (im using windows xp WAMP) anyway
the error showed during execution of the script mysql -u root datbasename <file.sql
Hm. So you are using the exec/passthru/system commands to execute a command line invocation of the mysql CLI client. Have you tried executing the SQL file without using XAMP? That is to say, by typing it yourself from the command line?
jansky wrote:the error showed during execution of the script mysql -u root datbasename <file.sql
My mistake; I thought this had something to do with PHP.... 🙂
sneakyimp;10904258 wrote:Hm. So you are using the exec/passthru/system commands to execute a command line invocation of the mysql CLI client. Have you tried executing the SQL file without using XAMP? That is to say, by typing it yourself from the command line?
not using the passhtru system i executed to the command line
Have you tried the XAMP docs? I found this
