[EMAIL PROTECTED] wrote: > Hi to all! > > I have to transfer copy of the one table from one to other database. > I was working with phpMyAdmin. I exported table in sql file but, when > tried to Import it to other database I got > Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to > allocate 806882 bytes) > Any idea how to do this? > > Thanks for any help > > -afan > Afan,
The error you see is coming from PHP, which allows to grow one instance only this big. Apparently your SQL dump is quite big and apparently phpmyadmin is buffering it all in memory before executing. The way I see it, there are are three solutions: 1.) You set the memory limits high enough in php.ini (You don't want to do that.) 2.) You split the SQL dump in enough pieces to stay within the memory constraints of PHP. You then have to import every part seperately. 3.) Instead of using phpmyadmin, you connect with a mysql client and import the sql dump with the client. If you ask me, option 3 seems like the most reasonable and is by far the easiest. I hope that helps. -Jorrit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
