Support » Plugin: EZPZ One Click Backup » [Plugin: EZPZ One Click Backup] No database backup – zero length file

  • Hi, I love the idea and concept of your backup solution. Did my first test today and although it recovered all my site files, the SQL file was 0 (zero) in length and it won’t restore the database. I did it via manual backup two times and have tried doing a restore, it doesn’t work.

    During the restore, it indicates it can’t access the database using the credentials. Curious as to what you think is creating this? Thanks

    Dean

    http://wordpress.org/extend/plugins/ezpz-one-click-backup/

Viewing 4 replies - 1 through 4 (of 4 total)
  • I should add, that during the manual backup process it says it backed up the database correctly.

    Thanks
    Dean

    Oh, I still had the screen open from the attempted restore. This is the result I get

    This application will attempt to restore your xxxxxxxxxx WordPress installation to the way it was on Saturday, January 28th, 2012 at 1:10pm.

    No files will be deleted during the restoration and a fresh database backup will be performed before restoration begins.

    Creating a backup of the current database. (EZPZ_RESTORATION_FILES/EZPZ_DB_DUMP.sql)
    Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘xxxxxxxxxxxxxx’@’myIPaddress’ (using password: YES) in /home/content/41/8215541/html/xxxxxxxxxxxxxxxx/EZPZ_RESTORATION_FILES/EZPZ_RESTORE.php on line 57

    Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/content/41/8215541/html/xxxxxxxxxxxxxxxxx/EZPZ_RESTORATION_FILES/EZPZ_RESTORE.php on line 59

    Warning: mysql_query() [function.mysql-query]: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/content/41/8215541/html/xxxxxxxxxxxxxxxxxx/EZPZ_RESTORATION_FILES/EZPZ_RESTORE.php on line 63

    Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/content/41/8215541/html/xxxxxxxxxxxxxx/EZPZ_RESTORATION_FILES/EZPZ_RESTORE.php on line 63

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/content/41/8215541/html/xxxxxxxxxxxxxxxxx/EZPZ_RESTORATION_FILES/EZPZ_RESTORE.php on line 64
    ✔OK
    Backing up the current xxxxxxxxxxxx file structure. (EZPZ_RESTORATION_FILES/xxxxxxxxxxxxxxxxxxxx.zip) ✔OK
    Restoring database to Saturday, January 28th, 2012 at 1:10pm. ✔OK
    Restoring file system to Saturday, January 28th, 2012 at 1:10pm. ✔OK

    For me, it was the MySQL password problem. I used the auto password generated by cPanel (when you create mysql user) and it contained characters EZPZ had trouble with.

    I changed the MySQL user pass and that fixed it.

    Yes, that seemed to work. I replace the password with something that didn’t include special characters and it worked fine. It backed up the database just fine. On recovery it didn’t successfully import the database back in, and didn’t through any errors but I was able to easily import the database file it had made it step one. Besides this small problem, the solution worked well.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: EZPZ One Click Backup] No database backup – zero length file’ is closed to new replies.