4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 PHPMyadmin Error, Can Anyone shed any light?
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
Justin
4WebHelp Addict
4WebHelp Addict


Joined: 07 Jan 2002
Posts: 1060

PostPosted: Sun May 11, 2003 12:35 pm (14 years, 7 months ago) Reply with QuoteBack to Top

Just get this when trying to run off a backup :

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 3772416 bytes) in /var/www/html/phpMyAdmin-2.4.0/tbl_dump.php on line 397
OfflineView User's ProfileFind all posts by JustinSend Personal MessageSend email
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sun May 11, 2003 1:02 pm (14 years, 7 months ago) Reply with QuoteBack to Top

Sounds like the backup is just too large, or that your server is overloaded... I often get that error on a phpBB related site, never known why though.

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Justin
4WebHelp Addict
4WebHelp Addict


Joined: 07 Jan 2002
Posts: 1060

PostPosted: Sun May 11, 2003 1:08 pm (14 years, 7 months ago) Reply with QuoteBack to Top

According to support :

Quote:
Your backup is getting too large for PHP to handle. You will need to use SSH to run your backups now the DB has reached a certain size.


, it's only 3MB or so though, didn't think it would need SSH, but oh well.

I know the SSH command to restore DB's, but am not sure on the one to backup DB's, what is it?

Thanks
OfflineView User's ProfileFind all posts by JustinSend Personal MessageSend email
Daniel
Team Member



Joined: 06 Jan 2002
Posts: 2564

PostPosted: Sun May 11, 2003 1:25 pm (14 years, 7 months ago) Reply with QuoteBack to Top

Code:
/usr/local/psa/mysql/bin/mysqldump --host=HOST --user=USER --password=PASSWORD DATABASE |gzip > /path/database.sql.gz


That does it on Plesk, so it'll be something similar for Ensim...

________________________________
Image
OfflineView User's ProfileFind all posts by DanielSend Personal Message
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.048258 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme