How do I import my Magento database? (memory errors)
December 22, 2012 1:16 AM Subscribe
I am trying to import a Magento database in phpMyAdmin but keep getting an exhausted memory error.
posted by Unhyper to Computers & Internet (2 answers total)
I am in MySQL hell.
I had a Magento CE 1.5 installation, and I am now trying to use my webhost's automated system to install Magento CE 1.7, and then replace the newly created database's contents with the SQL backup file made of the 1.5 database.
I tried to just import the old sql base files into the new database, but apparently phpMyAdmin can't just "replace" existing data with new data, so I wiped all the tables and am trying to use Import to bring in the gzipped backup.
However, I keep getting this error:
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 214237 bytes) in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/csv.php on line 356
I don't have access to the file the error message quotes.
This is from my attempt at importing in CSV, the same happens if I try the SQL format version.
The database unzipped is 300 MB, and its gzipped version is 40 MB.
The tools at my disposal are FTP and phpMyAdmin. I don't know if have SSH access, and I'd be all thumbs with it if I did because I have never used it. Is this an out of memory type situation due to such a large database? What can I do?