Out of memory on hostgator

[RobertParticipant]

Hi,

This error has occurred during a restore:

Fatal error: Out of memory (allocated 99090432) (tried to allocate 72 bytes) in /wp-content/plugins/updraftplus/addons/migrator.php on line 412

UpdraftPlus Restoration: Progress
Final checks
Looking for db archive: file name: backup_xxx_8e07bb03ff68-db.gz
Archive is expected to be size: 390 Kb: OK
Looking for others archive: file name: backup_xxx_8e07bb03ff68-others.zip
Archive is expected to be size: 0 Kb: OK
Looking for plugins archive: file name: backup_xxx_8e07bb03ff68-plugins.zip
Archive is expected to be size: 19943 Kb: OK
Looking for themes archive: file name: backup_xxx_8e07bb03ff68-themes.zip
Archive is expected to be size: 4938 Kb: OK
Looking for uploads archive: file name: backup_xxx_8e07bb03ff68-uploads.zip
Archive is expected to be size: 37540 Kb: OK
Looking for wpcore archive: file name: backup_xxx_8e07bb03ff68-wpcore.zip
Archive is expected to be size: 135396 Kb: OK
Database
Will not delete the archive after unpacking it, because there was no cloud storage for this backup

Unpacking backup…

Restoring the database (on a large site this can take a long time – if it times out (which can happen if your web hosting company has configured your hosting to limit resources) then you should use a different method, such as phpMyAdmin)…
Backup of: https://www.xxx
Old table prefix: wp_
Site information: multisite = 0
New table prefix: wp_
Restoring table (MyISAM): wp_options
Search and replacing table: wp_options: rows: 375
Restoring table (MyISAM): wp_users
Search and replacing table: wp_users: rows: 2
Restoring table (MyISAM): wp_usermeta
Search and replacing table: wp_usermeta: rows: 40
Restoring table (MyISAM): wp_commentmeta
Search and replacing table: wp_commentmeta: rows: 0
Restoring table (MyISAM): wp_comments
Search and replacing table: wp_comments: rows: 2
Restoring table (MyISAM): wp_links
Search and replacing table: wp_links: rows: 7
Restoring table (MyISAM): wp_postmeta
Search and replacing table: wp_postmeta: rows: 815
Restoring table (MyISAM): wp_posts
Search and replacing table: wp_posts: rows: 309
Restoring table (InnoDB): wp_slim_browsers
Search and replacing table: wp_slim_browsers: rows: 100
Restoring table (InnoDB): wp_slim_content_info
Search and replacing table: wp_slim_content_info: rows: 81
Restoring table (InnoDB): wp_slim_outbound
Search and replacing table: wp_slim_outbound: rows: 130
Restoring table (InnoDB): wp_slim_screenres
Search and replacing table: wp_slim_screenres: rows: 81
Restoring table (InnoDB): wp_slim_stats
Database lines processed: 50 in 1.53 seconds
Database lines processed: 100 in 3.56 seconds
Search and replacing table: wp_slim_stats: rows: 15017

Cheers,

[udadminKeymaster]

Hi Robert,

It’s an out of memory error. It means that WordPress has requested more memory than your host is configured to allow.

The amount of memory – 99090432 bytes – is 94Mb; and that’s really low; according to our statistics, only the bottom 3% of web hosting companies allocate that much memory or less. Can you ask Hostgator for an increase?

Failing that, you could try de-activating all your plugins and move to the default theme before trying to restore, as that may reduce memory usage. Or manually edit the db.gz database file backup and cut out that very large table’s data (wp_slim_stats) – from the name, presumably it’s just a log of visits and isn’t essential?

David

[RobertParticipant]

Hostgator can’t change the limit unless I upgrade to VPS, stripped out the tables and restored went well.
cheers.

[Author]

Posts