Restoring a database
Permalink
Trying to restore my database. (Just performed a clean install)
I get this error
Warning: chmod() [function.chmod]: Operation not permitted in /var/www/vhosts/mommyandidesigns.com/httpdocs/concrete/controllers/dashboard/system/backup_restore/backup.php on line 90
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 9392526 bytes) in /var/www/vhosts/mommyandidesigns.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 56
I changed the permission on my concrete folder to 777 to test and my php.ini to the following values to no avail:
memory_limit 512M
post_max_size 512M
upload_max_filesize 512M
Thanks all
I get this error
Warning: chmod() [function.chmod]: Operation not permitted in /var/www/vhosts/mommyandidesigns.com/httpdocs/concrete/controllers/dashboard/system/backup_restore/backup.php on line 90
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 9392526 bytes) in /var/www/vhosts/mommyandidesigns.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 56
I changed the permission on my concrete folder to 777 to test and my php.ini to the following values to no avail:
memory_limit 512M
post_max_size 512M
upload_max_filesize 512M
Thanks all
Try increasing the memory.
The physical or the php file?
Sorry, the phpini file.
Do you have access to phpmyadmin?
Yes, I do
If you have access, you should try restoring (uploading) your database using it.
Something else is going on. That didn't work either
Do you know if safe mode is supposed to be on or off?
Do you know if safe mode is supposed to be on or off?
That should not matter. You are getting this error when uploading the database through phpmyadmin?
I've run into this before when restoring a database on a site that had statistics running... it caused lots of memory timeouts because of the sheer amount of data.
I simply opened the .sql file in wordpad, removed the stats database portion (pretty easy to spot if you know what your looking for), and re imported through phpmyadmin.
I simply opened the .sql file in wordpad, removed the stats database portion (pretty easy to spot if you know what your looking for), and re imported through phpmyadmin.
We have also seen this same type of issue wih stats and large data bases. Increasing max_execution_time in php.ini seems to solve the issue.
Ok, now I am really stuck. I started over because I didn't remember what changes I had made anymore
Found the "moving a site" instructions on this site. One of the first steps is to simply move all the content over. Previously when I did that, I was able to see the content, just not the eCommerce items since that requires a DB connection. Now, I connect tohttp://www.sitename and it gives me an error saying it cannot connect to the DB.
Does the DB need to be functioning before you can see home page content? (Wasn't like that before which is why I ask)
I was planning on using the DB restore function directly in C5, but obviously I can't get there either
Thanks for all the help thus far
Found the "moving a site" instructions on this site. One of the first steps is to simply move all the content over. Previously when I did that, I was able to see the content, just not the eCommerce items since that requires a DB connection. Now, I connect tohttp://www.sitename and it gives me an error saying it cannot connect to the DB.
Does the DB need to be functioning before you can see home page content? (Wasn't like that before which is why I ask)
I was planning on using the DB restore function directly in C5, but obviously I can't get there either
Thanks for all the help thus far
If you would not mind giving us access to the server, we can save you some time and see if we can get it up and running for you.
The reason the page still loaded for you is because it was more then likely saved in your browser cache.
If you would like some assistance send us a PM.
The reason the page still loaded for you is because it was more then likely saved in your browser cache.
If you would like some assistance send us a PM.
What's your email address?
Can you help me as well? I have a failed database restore and my site is messed up.
If you are going to reach out and ask like that, I can sure try :)
Please PM me your site details.
Please PM me your site details.
PM sent
What was the issue here? I just attempted to restore an intranet and received the same "unexpected error" that is attached. Now the site won't display at all...not good for this business!
