February 28, 2015 in Feedback
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.
How are you copying the database ? You're not copying the raw db files are you ? Would be best to backup and export / import via either phpmyadmin (if its a tiny db) or via command line or a tool such as bigdump perhaps.
I think a 'change' script might be needed for this, I recall it being mentioned in a topic a week or so ago this might also assist.
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.
Delete the contents of /datastore
Tried that no luck...
Same error and the new datastore only built a partial of about 10 files and stops.
If its your wampserver on your own local machine then you can just drop to the Windows command line and do it.
Create the new empty database first, then take a backup of the db to move. Lets say its called sitebackup.sql and the database is called newdb
Now navigate to where your sql directory is (not essential but easier) and copy the db into it then:
Now you can import it (I'm assuming no root pass on your local)
mysql.exe -u root newdb < sitebackup.sql
If you have a password its -u (username) -p (password)
There is an example of this in my 'QA Lab: Converting and upgrading InvisionFree to IPS4' topic, on 'Step Three: Importing the database'
No it is....
And Thanks I will give this a try and see where it goes....
For the next time Wamp goes south on me in RED
mysqldump command can be executed from mysql prompt. For all the code for mysqldump commands bellow, database is the name of the database.
mysqldump database > backup-file.sql;
mysql database < backup-file.sql;
mysqldump --opt database | mysql --host=remote_host -C database
Where remote_host indicates a remote server where you want to take backup.
mysqldump --databases database1 [database2 ...] > backup_of_databases.sql
mysqldump --all-databases > backup_of_all_databases.sql
Also (same author) apparently my method should have worked. http://www.w3resource.com/mysql/mysql-backup-and-restore.php
DescriptionIn this page we are going to discuss how to take backups of MySQL databases and restoring them.Take backup by copying table filesYou can simple copy the table files of a MySQL database to a separate location and accomplish a backup. Later, when necessary, you simply copy them back to the original location to restore the database.If you are using WAMP server for MySQL, then you can find table files within wamp > bin > mysql > mysql5.1.36 > data > databaseName. Where databaseName is a folder whose name is same as your database.If you have installed MySQL manually, then you can find table files within Program Files > MySQL >MySQL Server 5.0 > data > databaseName. Where databaseName is a folder whose name is same as your database.Remember in mysql5.1.36 and MySQL Server 5.0, 5.1.36 and 5.0 indicates the version of the MySQL, which differs if you are working on a different version of MySQL.
In this page we are going to discuss how to take backups of MySQL databases and restoring them.
You can simple copy the table files of a MySQL database to a separate location and accomplish a backup. Later, when necessary, you simply copy them back to the original location to restore the database.
If you are using WAMP server for MySQL, then you can find table files within wamp > bin > mysql > mysql5.1.36 > data > databaseName. Where databaseName is a folder whose name is same as your database.
If you have installed MySQL manually, then you can find table files within Program Files > MySQL >MySQL Server 5.0 > data > databaseName. Where databaseName is a folder whose name is same as your database.
Remember in mysql5.1.36 and MySQL Server 5.0, 5.1.36 and 5.0 indicates the version of the MySQL, which differs if you are working on a different version of MySQL.
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....
check your htaccess and make sure the path is correct there too -
On a localhost I don't bother with .htaccess. Don't like back doors... LOL!!!!
yes but that's where the mod rewrite rules are
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.
Tried Andy's Command line theory, Ocean West's .htaccess and ForeverPontiac's Idea here http://community.invisionpower.com/topic/408044-copy-live-board/?do=findComment&comment=2528726....
Not getting why this is not cutting it here on the local... Now just get the error Oops Something went wrong....
Well it is gettiing better than the 500 error Access Denied.
This topic is now archived and is closed to further replies.
Started 39 minutes ago
Started 11 hours ago
Started 6 hours ago