Quote
-1) Export every database from mysql through phpmyadmin export database as sql file (shown on youtube) and write down all usernames and passwords that my websites use to access these databases.
0) Full backup of C:\wamp folder (with www folder inside) I decided to just copy it to D:\wamp
...
7) Same procedure for D:\wamp\bin\apache\Apache2.2.11\conf\extra\httpd-vhosts.conf and C:\wamp\bin\apache\Apache2.2.17\conf\extra\httpd-vhosts.conf
...
What was left was to import databases:
9) Created every database manually and imported tables, structure, data with from the exported sql file
10) Created appropriate users for every database with same name and password as before.
I kept thinking about posting the steps but...
Anyway, you guys can do it much faster and less hassle, ie. avoid those steps quoted above, if planning right from beginning, ie. setup Backup right after installed Wampserver successful
To setup Backup, follow this
[
blog.jlbn.net]
To restore from corruption, just simply sync from backup location. To restore from upgrade, follow these steps:
1. Sync wamp folder to backup location before doing anything
2. Backup user privileges and save as sql file
3. Uninstall wamp, remove wamp folder, restart PC
4. Install new wamp
5. Sync from backup location to update these: folder www except file index.php, folder data in new mysql folder except folder mysql, file httpd-vhosts.conf
6. Restore backup user_privileges.sql and since this is a backup file, it will auto assign specific users and passwords and privileges to associated databases...
7. Through wamp tray icon, enable Apache modules and/or PHP extensions. If dont remember, compare old and new file httpd.conf and php.ini. Also enable httpd-vhosts.conf in file httpd.conf
Have fun,
FREE One A DayFREE PhotoFREE GamesFREE WebsitesFREE Portable GPSFREE WAMP Guides