Usergroup: Customer
Joined: Jun 02, 2004
Total Topics: 32
Total Posts: 142
Posted 10/24/04 - 08:28 AM:
#1
I've been using the Create Backup option in the control panel for a while without a problem. Then today I got this error every time I try and back it up:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 184320 bytes) in /home/httpd/vhosts/gamelinks.com/httpdocs/conditionals.php on line 143
I can't imagine that my database is too big now for this to work. It's only 4+mb in size.
I'm using WSN Links 3.11 (there was no need to upgrade so I didn't want to risk something to stop working if I did).
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/24/04 - 07:34 PM:
#2
4 MB could easily be too big. You php limit on memory it can use during a script execution is 8 megabytes, it is telling you there, and the process of extracting the data combined with generating the backup could certainly exceed that. You'll need to use phpmyadmin.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/24/04 - 10:05 PM:
#4
The WSN Links import should accept any sort of phpmyadmin generated content, it's just sql. Of course, phpmyadmin works just fine for importing as well.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat
Usergroup: Customer
Joined: Jun 02, 2004
Total Topics: 32
Total Posts: 142
Posted 10/25/04 - 05:34 AM:
#5
I used the phpmyadmin default to back up, but the file it generated is smaller (3.6mb instead of 4.3mb). Why the difference is size for the backups? Am I perhaps not exporting all the data I need? I selected the enter database for export.
Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/25/04 - 10:56 PM:
#6
The difference is probably that phpmyadmin as you selected the options is more efficient. If you don't make it use complete inserts, for example, the file will come out considerably smaller.
_____________________
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat