Well its not like going to a dentist so it won't hurt to add .htaccess and give it a try as well... And the last 4 that needed pulling I did myself... Less painful and saved myself $1200.00. The wife and kids say I'm nuts.... I say Why give unto others that I can do myself cheaper. Also for the hell of it will try running command line on the database as Andy suggested. Again what can it hurt.
Also (same author) apparently my method should have worked. http://www.w3resource.com/mysql/mysql-backup-and-restore.php I will still give the command line a run and see if this works..... Sheryll is getting ready to cut my beard off. I think she is getting tired of picking up the hair after I start pulling....
For the next time Wamp goes south on me in RED Take backup using mysqldump mysqldump command can be executed from mysql prompt. For all the code for mysqldump commands bellow, database is the name of the database. Take backup of a database mysqldump database > backup-file.sql; Restore a database mysql database < backup-file.sql; Copying data from one server to another mysqldump --opt database | mysql --host=remote_host -C database Where remote_host indicates a remote server where you want to take backup. Dump several databases with single command mysqldump --databases database1 [database2 ...] > backup_of_databases.sql Dump all databases using --all-databases option mysqldump --all-databases > backup_of_all_databases.sql
The DB is just shy of 4gig... and yes copying the raw file due to this version of Wamp falling on it face even though all settings are set to a bit of an extreme as to cover all bases... I have never attempted doing this via command line I will have to read up on the methods. Can't be much different than using putty.
As the title may point out there is a bit of hell to pay if you attempt these. Example: Try to duplicate a directory in Wamp D:\wamp\www\test-1 to D:\wamp\www\test-2. Now go into D:\wamp\bin\mysql\mysql5.6.17\data and duplicate the mysql directory test-1 to test-2. Now go back to the new root directory D;wamp\www\test-2 and change the conf_global.php with the new information. Go into the browser http://localhost/test-2/ and You get nothing but a big 500 error... Nothing in the error log to say what is in error...
Click on Try again. Now the following image is an old one I didn't bother with another screenshot that duplicates this one.
This has been consistant through out all the betas and RC's This is going to cause some serious issues should a hosted server go down like my experiences with this version of wampserver2.5-Apache-2.4.9-Mysql-5.6.17-php5.5.12-32b with all IPS beta and RC's they will not come back and are lost to redo from scratch. In 3.4.7 and earlier you would do the same as above go into the ACP and correct all the URL's to point to the new ones and so on.... Seeing this on a contiuous bassis in Wamp worries me on what will or may happen to my live board if anything like this were to happen on my server or if I decide to move to another server. This is driving me insane to recreate a new fresh testboard from the original backup file everytime I want the last testboard saved.
I agree this is where all you need for the upgrade after the initial board setup is your public and uploads directories as well as your conf_global.php to start the upgrade in which afterwards you can drop the public directory.... The rest are unneeded. But if you also have downloads and nexus you need to keep the downloads and screenshots directories even after the build.
I can't say for sure without digging on where that upgrade falls into place. But when all else fails I have downloaded a fresh copy from the clients center... Corrupt downloads will screw up the works. For me I believe I am having on occasion a file transfer issue between me and IPS Called Time Warner... Because everytime I do this and rebuild a new test site the problem upgrading seems to clear... So now before I even start to get ENRAGED! I just hit the clients center for a fresh copy then send TWC my bill..... LOL!!!
Thinking to tell a little white lie to some people... Due to being Hired by IPS I can no longer support them due to conflict of interests... Sounds better than no more free ride or I don't care anymore...