logo
WSN Links PHP Directory Software
Features Showcase Reviews Demos Purchase Manual Support
 

Create Backup error

Version:


Create Backup error
Synozeer
Forum Regular

Usergroup: Customer
Joined: Jun 02, 2004
Total Topics: 32
Total Posts: 142
Posted 10/24/04 - 08:28 AM:
quote post
#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).

Adam

Edited by Synozeer on 10/24/04 - 08:31 AM

_____________________
GameLinks.com
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/24/04 - 07:34 PM:
quote post
#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
Synozeer
Forum Regular

Usergroup: Customer
Joined: Jun 02, 2004
Total Topics: 32
Total Posts: 142
Posted 10/24/04 - 07:44 PM:
quote post
#3
What settings should I have checked for backing up so that I can use the Wsnlinks import option if I needed to?

Default is to save as SQL.

Options Checked:
Add AUTO_INCREMENT value
Enclose table and field names with backquotes

Unchecked:
Add 'drop table'
Complete inserts
Extended inserts
Use delayed inserts

Export type: insert

Thanks,
Adam

_____________________
GameLinks.com
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/24/04 - 10:05 PM:
quote post
#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
Synozeer
Forum Regular

Usergroup: Customer
Joined: Jun 02, 2004
Total Topics: 32
Total Posts: 142
Posted 10/25/04 - 05:34 AM:
quote post
#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.

Thanks,
Adam

_____________________
GameLinks.com
Paul
Administrator
Avatar

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 56
Total Posts: 5844
Posted 10/25/04 - 10:56 PM:
quote post
#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
Search thread for
Download thread as


You don't have permission to post.

Please login or register.

Admin Control Panel

   
Home    |    Features    |    Showcase    |    Reviews    |    Demos    |    Purchase    |    Manual    |    Support
© 2008 Paul Knierim. All rights reserved.