Open the nf file usually located at ' C:\wamp\bin\apache\apache2.4.9\conf ' and find the below settings: Initially the virtual host inclusion is commented. ** Please note, do not copy the mysql db if you have it within your backup into the new MySQL directory because this will cause all sorts of issues. Setting up virtual host in WAMP server involves the below steps: Step 1: Enable the Virtual host configuration in Apache's nf file. Convert them to MyISAM across the board, make a copy of the file system, then move them into the new database directory, then change back to InnoDB if needed.MySQL dump the databases, then MySQL import.If you have InnoDB tables then this will be an issue because you can't simply copy them into a location, in this case what you would have wanted to do is: Step 1: setting permissions to allow other users to access your serverlink Step 2: Allowing connections to your server through your firewalllink Step 3. If they are MyISAM, copy the tables straight into the new MySQL database directory and this will work as long as the files have the correct read write permissions and ownership (mysql). InnoDB tables have the table name with the following suffixes: MyISAM tables have the table name with the following suffixes:
Before I start, I will say that I am not familiar with wampserver but I am familiar with MySQL and LAMP.įirst things first, are your tables within your databases MyISAM, InnoDB or a mixture of both? - You can tell on the file level by looking at the suffixes.
0 kommentar(er)
