vladax

Hi dwinden,

I’m not a PHP expert so I’m not sure why it works. But it works.

The fact is that if you read a long table at once you can get the memory overflow error.

However, returning a long string should be safe.

Yes, the BackWPup works in Multisite environment but the plugin can only be used as super admin from the network admin administration.

https://premium.wpmudev.org/blog/5-backup-solutions-for-wordpress-multisite-networks/

To fix the problem with DB backup you can try the solutions I have posted here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

To fix the problem with DB backup you can try the solutions I have posted here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

To fix the problem with DB backup you can try the solutions I have posted here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

To fix the problem with DB backup you can try the solutions I have posted here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

You can try the solutions I have posted here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

I have posted a solution to this problem here:
https://www.ads-software.com/support/topic/database-backup-error-cause-and-solution?replies=3

Solution #1: Skip the large tables

1. Install the WP-Optimize plugin:
   https://www.ads-software.com/plugins/wp-optimize/
2. Click on the WP-Optimize name on the left pane and then on TABLES on top.
3. Write down the names of tables with more than 10 000 records if you are sure that you don’t need those tables in the backup. Large tables are usually lists of hits that you generally don’t need in the backup.
4. Uninstall the WP-Optimize plugin or keep it – it is a handy plugin.
5. Download from your site this file:
   wp-content/plugins/better-wp-security/modules/free/backup/class-itsec-backup.php
6. Open the file in a text editor (not Notepad).
7. Locate the line 134:
   if ( in_array( substr( $table[0], strlen( $wpdb->prefix ) ), $this->settings['exclude'] ) === false ) {
8. Enter above this line a new line where wp_wassup is the name of the table you want to skip:
   if ($table[0] == "wp_wassup") continue;
9. Repeat step 7 for other tables you want to skip.
10. Upload the file from your computer to the server.

?
Solution #2: Fix the memory overflow

1. Download from your site this file:
   wp-content/plugins/better-wp-security/modules/free/backup/class-itsec-backup.php
2. Open the file in a text editor (not Notepad).
3. Locate the line 134:
   if ( in_array( substr( $table[0], strlen( $wpdb->prefix ) ), $this->settings['exclude'] ) === false ) {
4. Locate the line 165:
   $return .= PHP_EOL . PHP_EOL;
5. Change the code between those lines to:
   

   if ( in_array( substr( $table[0], strlen( $wpdb->prefix ) ), $this->settings[‘exclude’] ) === false ) {
   $from_result = 0;
   $num_results = $wpdb->get_var( ‘SELECT COUNT(*) FROM ‘ . $table[0] . ‘;’);
   while ($from_result < $num_results)
   {
   $result = $wpdb->get_results( ‘SELECT * FROM ‘ . $table[0] . ‘ LIMIT ‘ . $from_result . ‘, 1000;’, ARRAY_N );
   foreach ( $result as $row ) {
   $return .= ‘INSERT INTO `’ . $table[0] . ‘` VALUES(‘;
   for ( $j = 0; $j < $num_fields; $j ++ ) {
   $row[$j] = addslashes( $row[$j] );
   $row[$j] = preg_replace( ‘#’ . PHP_EOL . ‘#’, “\n”, $row[$j] );
   if ( isset( $row[$j] ) ) {
   $return .= ‘”‘ . $row[$j] . ‘”‘;
   } else {
   $return .= ‘””‘;
   }
   if ( $j < ( $num_fields – 1 ) ) {
   $return .= ‘,’;
   }
   }
   $return .= “);” . PHP_EOL;
   }
   $from_result += 1000;
   }
   }
   $return .= PHP_EOL . PHP_EOL;

6. Upload the file from your computer to the server.

?
Solution #3: Use another plugin
Disable the Database Backup feature and use another plugin. There are many plugins with DB Backup feature. I can recommend the BackWPup Free:
https://www.ads-software.com/plugins/backwpup/
?
I prefer solution #3. The BackWPup plugin allows you to backup all the files from your site too.

I think this will be a common problem for many users.

Therefore it will be useful to add a warning to the corresponding page in plugin settings:

Do not delete cookies. If you are unable to access the site, perform these steps…

After installing the v1.6, the View Latest System Logs button is working now.

It would be nice to have the Perishablepress: 5G Blacklist 2013 in the Better WP Security.

The title of this topic should be:

Space in <a title=" " makes incompatibility with Easy FancyBox

Last time: Forget the <strong> tag in the line of code above.