Hi MyCodetree team, Ryan,
Please allow me to explain how the process happened to me using numbered steps + remarks, and finally I’ll post my Question:
1. – using WP Complete Backup I have backed-up correctly/successfully: database and files.(zipped-file size: 78MB)
> reason for backup: WordPress intended upgrade to version 3.5, but the upgrade continued to fail using automatic upgrade. FTP-ing WordPress 3.5 also didn’t work because it didn’t connect to the database corectly, but that’s another post I guess. I subsequently went into phpmyadmin: deleted the database and succesfully got WordPress 3.4.2 up-and-running again, it:
2. – being a BASIC CLEAN WORDPRESS 3.4.2 INSTALLATION only.
3. – I then Installed WP Complete Backup again.
4. – Next I Tried to restore the Backup using Method 1: (Restore Backup From Upload: on my PC)
Result: failed and WP gave Error 500 Message. I assume Database size was (probably) too large (78MB)
No problem though, try Method 2:
5. – So I Tried to restore the Backup using Method 2: (Restore Backup From Server)
Use FTP attempt to UPLOAD the database to the folder location: /wp-content/plugins/wp-complete-backup/storage/
Result: FTP continues to be unsuccessful….
MY TIP – on how-to avoid item 5 above) >>>
– Use FTP Program to RENAME the Folder “Storage” to > “Storagee”.
– The FTP Upload is successful.
– Use FTP again to Rename the “Storagee” folder back to original name “Storage”.
Yessss, WP Complete Backup reckognizes the Backup from Server now !!!
6. – I select it and Push Restore button
RESULT: Completing the Restoration now: RESTORATION SUCCESSFUL !!!
7. – Restart WordPress accordingly.
The USERGUIDE one extra step to UNZIP the 78MB database file. I execute as following:
8. – Unzipped the Backup file.
9. – go into folder \wp-content\plugins\wp-complete-backup\storage\** 1357043553** and locate file database.sql
10.- I start phpmyadmin and try to use the ‘Import’ function as instructed, filename from inside unzipped backup: database.sql.
– Character set: utf8
– sql compatibility mode: None
11.- RESULT: Error SQL-query:
” DROP TABLE IF EXISTS wp_commentmeta;
MySQL retourneerde: Documentatie
#1046 – No database selected “
Final backup Note: I did have a ‘traditional’ Complete FTP Backup Copy of the whole website incl. all subfolders, but simply overwriting the public_HTML folder doesn’t really do the trick using WordPress, regretfully.
QUESTION: Could you provide any support on what I am doing wrong/missing ?
I now regret not having Exported my phpmyadmin database beforehand…
I’m keeping my fingers crossed hoping you can shed some light on this.
Appreciate your help in advance,
Rgds,
Hans ( http://www.lifebalance.pt )