PHPMyadmin Error, Can Anyone shed any light?

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

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

Team Member Joined: 06 Jan 2002 Posts: 2564

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.

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

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

Team Member Joined: 06 Jan 2002 Posts: 2564

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...