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.