URL to your eFiction: ofelvesandmen.com
Version of eFiction: 3.5.5
Have you bridged eFiction, if so with what?: No
Version of PHP: 5.3.26
Version of MySQL: can be found out from your host
Have you searched for your problem: yes
If so, what terms did you try: transferring site, database dump, database import
State the nature of your problem:
We want to transfer to a new webhost. I backedup the database from the old site without any error. I have created a database in the new host (not sure it matters but it doesn't have the exact same database name and user name because the host doesn't allow it - I've edited the config file to the new names).
When I try to import the sql file I got from the old eFiction backup, I get an error:
"You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near "< br /> < b>Fatal error< /b>: Allowed memory size of 33554432 bytes exhausted (tri' at line 1)"
When I reported the error to the new host they replied this:
" It has been determined that the provided .sql file has incorrect content. Please ensure the file you try to import is appropriate and provide us with it."
Do you have a test account for us? Sure, at the old site (Test /Pw eFictionTest). At the new one, since it's not installed, no.
We'd really appreciate some help with this - we're stuck between a rock and a hard place. The old host has a shared environment and wants to kick us out and we can't get into the new one.
Thank you.
Allowed memory size of 33554432 bytes exhausted
pretty much says it all.
The backup is too large to be imported by the server, most likely because the memory limit is set too low. (32MB in this case.)
Best option would be to make a backup through phpMyAdmin, do it manual for all tables except chapters, then backup chapters in smaller chunks. (Like 1000 each)
Unless you have access to a command shell (ssh login), that would open whole other options.
Maybe somebody has a better answer, that's what I had to do once.
Actually, nope, that pretty much didn't say it all. The problem was that the database was empty. The error message we got with the dumping was the actual content of the database. I did find it odd that the backup was very fast, but eFiction never issued an error or warning. It wasn't also a limitation from the old host's part - I easily backed up the database from the CPanel.
Hope this helps other people who run into this problem.
Oops, ok, that is weird - _usually_ it really means what it says, so I was assuming is did in this case, too.
My bad.
I honestly don't exactly know how eFi 3 does backup, that's why I usually recommend using 3rd party tools, like phpMyAdmin (or cPanel where available).
Thanks, anyway, for giving it a go.
