Backup is to big
-
My whole site with uploads folder is about 700mb but when a backup is created it has 1,3GB and it looks like the whole site is backed up and aditionally the file from upgrade folder created by backup plugin is attached to it and the zip file is 1,3.
-
Sounds like it’s failing to delete. Do you know how to access via Shell or FTP and, if so, can you go see if the zip is stuck in the wp-content/upgrades/ folder? If so, you can delete that. If not, let me know your domain and, if you’re on DreamHost, I can have a look.
The funny thing is that sometimes it goes ok to the bucket – it has about 700mb, but the problem is that it doesn’t attach the sql file.
Your database is 700 Megs?
Are you on a shared server?
Sory for not beeing specific enough – the data from wp-content is about 700mb. The sql data is about 110 mb. I’m on a VPS (1 core 3,4 GHz, 1GB ram (2GB burst)).
Okay, two topics is confusing the HELL out of me. I’ve closed https://wordpress.org/support/topic/sql-backup-is-not-created
1) Your SQL isn’t backing up
2) Your backup is ‘too big.’
Theory: The SQL backup is failing for some reason and not deleting itself.
Do you know how to access via Shell or FTP and, if so, can you go see if the zip is stuck in the wp-content/upgrades/ folder? If so, you can delete that.
You never answered that so I do need to know 🙂
Now we need to test a couple things:
1) Backup JUST wp-content. Does that work?
2) Backup JUST sql? Does that work? We know it doesn’t:
[2015/08/20 10:06:15] SQL file created: /xxx/public_html/wp-content/upgrade/19908052e99c67f321f4b3f8dde6d71a.sql ().That should have had a size in the DB. It doesn’t which makes me wonder how your SQL DB is set up? Is it localhost? Can you command-line do a DB export of it?
Does anything interesting happen if WP_DEBUG is set true?
The tl;dr is that it can see your database but it can’t MAKE the SQL dump, so it’s choking. I tested this on DreamHost servers and my own home-brew setup, but obviously I can’t check every kind of set up :/
Yes – I can log in and I did remove the file in the upgrades folder.
The wp-content works ok. The size of the files ziped is ok.
I’m using an other plugin to do a DB backup (BPS Pro) and it works fine.
On this setup I have also used https://wordpress.org/plugins/backwpup/ and it also worked ok.
I will try the WP_DEBUG and report.
Is your db on the same server (i.e. Local host?) and did you happen to define the home and site rules in WP-config? I’m not asking you to Do that, I’m just asking if you happened to already. Please don’t go add it, just tell me yes or not 🙂
Hello!
It took a while but here is the debug output (my second post as the first one isn’t shown and I don’t know why)
[09-Sep-2015 19:11:43 UTC] PHP Strict Standards: Non-static method DHDO::getURL() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/settings.php on line 30 [09-Sep-2015 19:12:03 UTC] PHP Strict Standards: Non-static method DHDO::getURL() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 28 [09-Sep-2015 19:12:04 UTC] PHP Strict Standards: Only variables should be passed by reference in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 73 [09-Sep-2015 19:12:14 UTC] PHP Strict Standards: Non-static method DHDO::getURL() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 28 [09-Sep-2015 19:12:14 UTC] PHP Strict Standards: Only variables should be passed by reference in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 73 [09-Sep-2015 19:13:16 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [09-Sep-2015 19:13:17 UTC] PHP Notice: Undefined index: page in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/lib/dhdo.php on line 81 [09-Sep-2015 19:13:17 UTC] PHP Notice: Undefined index: page in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/lib/dhdo.php on line 81 [09-Sep-2015 19:13:17 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::backup() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 579 [09-Sep-2015 19:13:17 UTC] PHP Strict Standards: Non-static method DHDO::rscandir() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/lib/dhdo.php on line 204 [09-Sep-2015 19:13:17 UTC] PHP Strict Standards: Non-static method DHDO::rscandir() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/lib/dhdo.php on line 129 [09-Sep-2015 19:16:16 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [09-Sep-2015 19:16:17 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [ 09-Sep-2015 19:17:11 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [09-Sep-2015 19:17:11 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [09-Sep-2015 19:17:12 UTC] PHP Notice: Undefined variable: NoDupes in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/bulletproof-security/includes/firewall-autopilot.php on line 503 [09-Sep-2015 19:17:12 UTC] PHP Notice: Undefined variable: NoDupes in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/bulletproof-security/includes/firewall-autopilot.php on line 507 [09-Sep-2015 19:17:12 UTC] PHP Strict Standards: call_user_func_array() expects parameter 1 to be a valid callback, non-static method DHDO::cron_schedules() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-includes/plugin.php on line 213 [09-Sep-2015 19:17:37 UTC] PHP Strict Standards: Non-static method DHDO::getURL() should not be called statically in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 28 [09-Sep-2015 19:17:38 UTC] PHP Strict Standards: Only variables should be passed by reference in /home/virt106208/domains/winternecie.info/public_html/wp-content/plugins/dreamobjects/admin/backups.php on line 73Non of those are reasons it shouldn’t run…
You never answered about how SQL is set up. Is it local host?
The hosting support just told me that it is local host.
Do you have access to your WP-config.php file?
Yes
Okay, in that file is the db URL listed as localhost or something like MySQL.example.com? Also do you have a home or siteurl defined in that file?
Please don’t post the contents of the file 🙂 that has passwords that should be kept private!
Hello:
// ** Ustawienia MySQL-a - możesz uzyskać je od administratora Twojego serwera ** // /** Nazwa bazy danych, której używać ma WordPress */ define('DB_NAME', 'xxxxxxxxxx'); /** Nazwa użytkownika bazy danych MySQL */ define('DB_USER', 'xxxxxxxxxx'); /** Hasło użytkownika bazy danych MySQL */ define('DB_PASSWORD', 'xxxxxxxx'); /** Nazwa hosta serwera MySQL */ define('DB_HOST', 'localhost'); /** Kodowanie bazy danych używane do stworzenia tabel w bazie danych. */ define('DB_CHARSET', 'utf8mb4'); /** Typ porównań w bazie danych. Nie zmieniaj tego ustawienia, jeśli masz jakieś wątpliwości. */ define('DB_COLLATE', '');The only additional settings are:
/** BEGIN BPS Pro ini_set Settings **/ @error_reporting(E_ALL|E_STRICT); @ini_set('log_errors','On'); @ini_set('error_log','/xxxxxxxxxx/wp-content/bps-backup/logs/bps_php_error.log'); // add the path to your php error log @ini_set('log_errors_max_len','1024'); @ini_set('memory_limit','128M'); @ini_set('session.cookie_httponly','On'); @ini_set('session.use_only_cookies','On'); @ini_set('session.cookie_secure','Off'); @ini_set('ignore_repeated_errors','On'); @ini_set('ignore_repeated_source','Off'); @ini_set('allow_url_include','Off'); @ini_set('define_syslog_variables','Off'); @ini_set('display_errors','Off'); @ini_set('display_startup_errors','Off'); @ini_set('implicit_flush','Off'); @ini_set('magic_quotes_runtime','Off'); @ini_set('max_execution_time','30'); @ini_set('mysql.connect_timeout','30'); @ini_set('mysql.trace_mode','Off'); @ini_set('report_memleaks','On'); /** END BPS Pro ini_set Settings **/ /** Absolutna ścieżka do katalogu WordPressa. */ if ( !defined('ABSPATH') ) define('ABSPATH', dirname(__FILE__) . '/'); /** Ustawia zmienne WordPressa i dołączane pliki. */ require_once(ABSPATH . 'wp-settings.php');I can’t see any other settings in that file 😉
@ini_set('max_execution_time','30'); @ini_set('mysql.connect_timeout','30');THOSE bother me. Can you comment them out and try? A 30 second timeout may be the cause of things here.
- The topic ‘Backup is to big’ is closed to new replies.
