WordPress.org

Ready to get started?Download WordPress

Forums

Backup
[resolved] SQL file not backing up (35 posts)

  1. bn86
    Member
    Posted 1 year ago #

    Hello,

    I can't find the backup of the SQL file in either the local backup or the Google Drive backup. I have Database checked as per the default. I'm running Backup version 2.0 and the latest WordPress, also it's a very small database.

    Any ideas?

    http://wordpress.org/extend/plugins/backup/

  2. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Can you please paste the Backup log file here (usually found at wp-content/backup/backup.log)?

  3. WPwebbouw
    Member
    Posted 1 year ago #

    Same here,

    The log file says it created the database dump but it is not in the backup folder.

    Btw: great plugin if this issue is solved!
    Erik

    #Fields:	date	time	type	message<br />
    2012-06-21	15:27:49	NOTICE	Attempting to dump database to /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/dump.sql<br />
    2012-06-21	15:27:49	NOTICE	The database dump was completed successfully in 0.51 seconds.<br />
    2012-06-21	15:27:49	NOTICE	Attempting to create archive /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/1340292469.zip<br />
    2012-06-21	15:27:50	NOTICE	Attempting to dump database to /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/dump.sql<br />
    2012-06-21	15:27:50	NOTICE	The database dump was completed successfully in 0.08 seconds.<br />
    2012-06-21	15:27:50	NOTICE	Attempting to create archive /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/1340292468.zip<br />
    2012-06-21	15:28:19	NOTICE	Archive created successfully in 29.34 seconds. Archive file size is 26 MB<br />
    2012-06-21	15:28:19	NOTICE	Archive created successfully in 29.07 seconds. Archive file size is 26 MB<br />
    2012-06-21	15:28:19	NOTICE	Attempting to upload archive to Google Drive<br />
    2012-06-21	15:28:19	NOTICE	Attempting to upload archive to Google Drive<br />
    2012-06-21	15:30:05	NOTICE	Archive 1340292469.zip uploaded to Google Drive in 106.04 seconds<br />
    2012-06-21	15:30:06	NOTICE	Backup process completed in 136.94 seconds. Initial PHP memory usage was 14.75 MB and the backup process used another 2 MB of RAM.<br />
    2012-06-21	15:30:06	NOTICE	Archive 1340292468.zip uploaded to Google Drive in 106.89 seconds<br />
    2012-06-21	15:30:06	NOTICE	Backup process completed in 136.69 seconds. Initial PHP memory usage was 15 MB and the backup process used another 2 MB of RAM.<br />
    2012-06-21	15:46:42	NOTICE	Attempting to dump database to /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/dump.sql<br />
    2012-06-21	15:46:42	NOTICE	The database dump was completed successfully in 0.08 seconds.<br />
    2012-06-21	15:46:42	NOTICE	Attempting to create archive /home/vries24/domains/e-riktest.nl/public_html/aa/wp-content/backup/1340293602.zip<br />
    2012-06-21	15:46:57	NOTICE	Archive created successfully in 14.69 seconds. Archive file size is 26 MB<br />
    2012-06-21	15:46:57	NOTICE	Attempting to upload archive to Google Drive<br />
    2012-06-21	15:48:44	NOTICE	Archive 1340293602.zip uploaded to Google Drive in 106.51 seconds<br />
    2012-06-21	15:48:44	NOTICE	Backup process completed in 122.44 seconds. Initial PHP memory usage was 15 MB and the backup process used another 2 MB of RAM.
  4. WPwebbouw
    Member
    Posted 1 year ago #

    Here's the backup folder after making 3 manual backups. No dump.sql files.

    http://aa.e-riktest.nl/wp-content/uploads/2012/06/backup-folder-no-sql-dump.png

  5. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Hi,

    The sql dump is inside the zip archive.

  6. WPwebbouw
    Member
    Posted 1 year ago #

    Can't find it. I searched the zip for 'dump.sql' and '.sql' but nothing shows up. Where should it be in the zip archive?

  7. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    It should be in the root of the archive.

  8. WPwebbouw
    Member
    Posted 1 year ago #

  9. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Weird,

    Can't think of an explanation for that. Please tell me your OS, PHP and WP versions. Also, do you know if you have the PHP zip extension enabled?

  10. bn86
    Member
    Posted 1 year ago #

    Thanks for your support hel.io. I am also not seeing a dump.sql anywhere. My log seems to suggest it was created...

    2012-06-21	08:25:24	NOTICE	Attempting to dump database to /home/storm/public_html/wp-content/backup/dump.sql
    2012-06-21	08:25:24	NOTICE	The database dump was completed successfully in 0.04 seconds.
    2012-06-21	08:25:24	NOTICE	Attempting to create archive /home/storm/public_html/wp-content/backup/1340267124.zip
    2012-06-21	08:25:27	NOTICE	Archive created successfully in 3.45 seconds. Archive file size is 10 MB
    2012-06-21	08:25:27	NOTICE	Attempting to upload archive to Google Drive
    2012-06-21	08:26:01	NOTICE	Archive 1340267124.zip uploaded to Google Drive in 33.11 seconds
  11. WPwebbouw
    Member
    Posted 1 year ago #

    Windows XP, PHP 5.2.17, WP 3.4
    You can see the specs of the php install here
    http://aa.e-riktest.nl/phpinfo.php
    Thanx for your help!

  12. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    @WPwebbouw
    According to that page the server is running Linux, not Windows.

    @bn86
    Can you tell me your OS, PHP and WP versions as well please?

  13. bn86
    Member
    Posted 1 year ago #

    The server is Linux (64 Bit) with PHP 5.2.17 and WordPress 3.4. I don't know if I have the PHP zip extension, but your plugin is creating zip files just fine..

    I get no dump.sql either in the zip file or in wp-content/backup.

  14. bn86
    Member
    Posted 1 year ago #

    Any tests I can perform to help out, just let me know :)

  15. WPwebbouw
    Member
    Posted 1 year ago #

    Yes of course Linux on the server, XP is on my home PC :)

  16. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Could you guys tell me what you have set for the local folder?

  17. WPwebbouw
    Member
    Posted 1 year ago #

    wp-content/backup

  18. bn86
    Member
    Posted 1 year ago #

    wp-content/backup

  19. WPwebbouw
    Member
    Posted 1 year ago #

    I did some testing and made several backups with different settings in the Advanced panel. Here are the results:

    • With only Database checked dump.sql is in the backup
    • With Database AND Uploads AND/OR Plugins checked dump.sql is in the backup
    • With Database AND Content AND/OR WordPress checked dump.sql is NOT in the backup

    Hope this helps you debug this :)

  20. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    WPwebbouw, your last comment helped me figure out the problem. Will fix it ASAP.

  21. WPwebbouw
    Member
    Posted 1 year ago #

    Great. I think you made THE solution for WordPress backup me and my clients need. Where's that donate button? :)

  22. bn86
    Member
    Posted 1 year ago #

    You are a star hel.io! Donation incoming :)

    And thanks WPwebbouw for your fantastic testing!

  23. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Ok, so I implemented the fix and also fixed a lot of other small issues along the way.

    Please test the development version found here: http://downloads.wordpress.org/plugin/backup.zip

    You can make donations here. I appreciate your support.

    I still have new features and optimizations incoming.

  24. WPwebbouw
    Member
    Posted 1 year ago #

    Works!
    With Database AND Content AND/OR WordPress checked dump.sql is in the backup

    I noticed when you check WordPress it makes no difference whether the other three options Content, Uploads and Plugins are checked or not. In all cases the complete WordPress filesystem is backupped.
    Also when Content is checked, Uploads and Plugins are in the backup whether they are checked or not. So WordPress includes all other options and Content includes Plugins and Uploads.

    This could be obvious for those who are familiar with the WordPress file system, but it could be confusing for 'normal' users (like my clients).
    I think this functionality could be improved by auto-unchecking those options that are already included in another selection. So if one checks Content, Uploads and Plugins are automatically unchecked. And if one checks WordPress, all other options except Database are automatically unchecked. Furthermore this system could be clarified in the help.

    My donation is already in your bank by now I guess. I will certainly promote this plugin with my clients. I've been searching for a decent backup solution for some time and your's is by far the winner.

    Possible improvements / wishlist:
    - A restore function that streamlines the restore process. It analyses the backup archive and restores the WordPress install accordingly.
    - A function to convert a complete backup to another domain. At the moment I use a great script for converting WordPress databases that deals well with serialized data. You find it here http://interconnectit.com/124/search-and-replace-for-wordpress-databases/
    Ik would be really great if the convert function produces a converted archive of an existing backup archive. That way a complete WordPress install (files and database) would become truely portable across domains.

    Thanks a million for writing this plugin and keep up the good work.

    e-

  25. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Thank you for the donation.

    The reason selecting what to backup works like it does is because WordPress allows you to have the content, plugins and uploads directories in totally different places, so for example if my uploads directory sits outside the content directory and I wanted to backup both, I would need to select both.

    Thanks for the suggestions and support.

  26. shirleee
    Member
    Posted 1 year ago #

    I'm facing the exact opposite problem.

    ONLY the dump.sql is backed up (as long as it's checked in the settings). All other files are omitted, regardless of whether they're checked or not.

    Any suggestions?

  27. WPwebbouw
    Member
    Posted 1 year ago #

    Perhaps the plugin is unable to create the zip file. Is the PHP zip extension enabled?

  28. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Hi shirleee,

    Please paste the backup.log file here, and tell us about your setup.

  29. shirleee
    Member
    Posted 1 year ago #

    I've experimented a little, and here's what happens. The ZIP file isn't created unless "Database" is checked in the settings. If it is, only dump.sql is archived.

    The following backup attempts led to the attached bakup.log.

    1) DB+Content (10:36:35) -> ZIP file contains dump.sql only
    2) Content (10:55:45) -> ZIP file is not even created
    3) WordPress (10:56:50) -> ZIP file is not even created
    4) DB+WordPress (11:01:34) -> ZIP file contains dump.sql only.

    backup.log:

    2012-06-30	10:36:35	NOTICE	Attempting to dump database to '/crypt/srv/www/htdocs/******/wp-content/backup/dump.sql'.
    2012-06-30	10:36:35	NOTICE	The database dump was completed successfully in 0.65 seconds.
    2012-06-30	10:36:35	NOTICE	Attempting to create archive '/crypt/srv/www/htdocs/******/wp-content/backup/1341056194.zip'.
    2012-06-30	10:36:35	NOTICE	Archive created successfully in 0.17 seconds. Archive file size is 195 kB.
    2012-06-30	10:36:36	NOTICE	Attempting to upload archive to Google Drive.
    2012-06-30	10:48:37	NOTICE	Archive 1341056194.zip uploaded to Google Drive in 241.08 seconds at an upload speed of /s.
    2012-06-30	10:52:38	NOTICE	Backup process completed in 963.32 seconds. Initial PHP memory usage was 32.5 MB and the backup process used another 8.5 MB of RAM.
    2012-06-30	10:55:45	NOTICE	Attempting to create archive '/crypt/srv/www/htdocs/******/wp-content/backup/1341057345.zip'.
    2012-06-30	10:55:45	NOTICE	Archive created successfully in 0.01 seconds. Archive file size is .
    2012-06-30	10:55:46	NOTICE	Attempting to upload archive to Google Drive.
    2012-06-30	10:55:46	ERROR	The path '/crypt/srv/www/htdocs/******/wp-content/backup/1341057345.zip' does not point to a readable file. (not_file)
    2012-06-30	10:55:46	NOTICE	Backup process completed in 0.23 seconds. Initial PHP memory usage was 32.5 MB and the backup process used another 0 MB of RAM.
    2012-06-30	10:56:50	NOTICE	Attempting to create archive '/crypt/srv/www/htdocs/******/wp-content/backup/1341057410.zip'.
    2012-06-30	10:56:50	NOTICE	Archive created successfully in 0.18 seconds. Archive file size is .
    2012-06-30	10:56:50	NOTICE	Attempting to upload archive to Google Drive.
    2012-06-30	10:56:50	ERROR	The path '/crypt/srv/www/htdocs/******/wp-content/backup/1341057410.zip' does not point to a readable file. (not_file)
    2012-06-30	10:56:50	NOTICE	Backup process completed in 0.31 seconds. Initial PHP memory usage was 32.5 MB and the backup process used another 0.5 MB of RAM.
    2012-06-30	11:01:34	NOTICE	Attempting to dump database to '/crypt/srv/www/htdocs/******/wp-content/backup/dump.sql'.
    2012-06-30	11:01:34	NOTICE	The database dump was completed successfully in 0.12 seconds.
    2012-06-30	11:01:34	NOTICE	Attempting to create archive '/crypt/srv/www/htdocs/******/wp-content/backup/1341057694.zip'.
    2012-06-30	11:01:34	NOTICE	Archive created successfully in 0.14 seconds. Archive file size is 195 kB.
    2012-06-30	11:01:34	NOTICE	Attempting to upload archive to Google Drive.
    2012-06-30	11:13:36	NOTICE	Archive 1341057694.zip uploaded to Google Drive in 241.37 seconds at an upload speed of /s.
    2012-06-30	11:17:37	NOTICE	Backup process completed in 962.7 seconds. Initial PHP memory usage was 32.5 MB and the backup process used another 8.5 MB of RAM.

    It seems as if zipping my WP folders fails silently. All the the folders are readable though, and there are no space or quota issues.

    As to my setup, I'm using WP 3.4 and Backup 2.0.1, all the folders (wp-content, etc.) are in the standard WP hierarchy.

  30. hel.io
    Member
    Plugin Author

    Posted 1 year ago #

    Please tell me your OS type, PHP version and whether or not you have the zip extension enabled.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags