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.
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.
Thanks, anyway, for giving it a go.
