Support » Plugin: WordPress Backup and Migrate Plugin - Backup Guard » [Plugin: Backup] SQL file not backing up

  • Resolved bn86

    (@bn86)


    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/

Viewing 15 replies - 1 through 15 (of 34 total)
  • iclanzan

    (@helio-1)

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

    WPwebbouw

    (@wpwebbouw)

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

    (@wpwebbouw)

    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

    iclanzan

    (@helio-1)

    Hi,

    The sql dump is inside the zip archive.

    WPwebbouw

    (@wpwebbouw)

    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?

    iclanzan

    (@helio-1)

    It should be in the root of the archive.

    WPwebbouw

    (@wpwebbouw)

    iclanzan

    (@helio-1)

    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?

    bn86

    (@bn86)

    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
    WPwebbouw

    (@wpwebbouw)

    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!

    iclanzan

    (@helio-1)

    @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?

    bn86

    (@bn86)

    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.

    bn86

    (@bn86)

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

    WPwebbouw

    (@wpwebbouw)

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

    iclanzan

    (@helio-1)

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

Viewing 15 replies - 1 through 15 (of 34 total)
  • The topic ‘[Plugin: Backup] SQL file not backing up’ is closed to new replies.