- Install MS Packages required
- Install wampserver -AS ADMINISTRATOR-
- Import .sql file (downloaded from client’s GoDaddy)
- Run 3 queries (below) to correct the URLs in the database
- Copy wp files to wamp64 folder
- Edit config file for localhost
- Turn on Apache Headers Module
- Wamp64, tools, default DB, ->invert to make MySQL default
The last step I was stuck on for 2 nights, until I saw this comment:
If using wamp server the default db is MariaDB i fixed it by changing the default db to MySQL Go to wamp tray -> tools -> select Invert default dbms it should now be set to MySQL
https://wordpress.stackexchange.com/questions/211662/wampserver-can-t-select-database
Run 3 Queries
- UPDATE wp_fs3cjwtx9z_options SET option_value=replace(option_value, ‘https://xxx.com’,’http://xxxx.localhost’) WHERE option_name=’home’ OR option_name=’siteurl’;
- UPDATE wp_fs3cjwtx9z_posts SET post_content=replace(post_content,’https://gooddogs4life.com’,’http://gd4l.localhost’)
- UPDATE wp_fs3cjwtx9z_postmeta SET meta_value=replace(meta_value,’https://gooddogs4life.com’,’http://gd4l.localhost’)
UPDATE on 12/6/20:
Earlier in the year I tried to setup a second website on localhost (accohio) but as soon as I tried the import. I started receiving an error on gd4l:
1143 – SELECT command denied to user ‘mysql.infoschema’@’localhost’ for column ‘default_collation_id’ in table ‘character_sets’
No matter where I turned inside of phpMyAdmin, I could not access the databases tab. I finally ran this query to resolve it:
GRANT ALL PRIVILEGES ON mysql.* TO ‘mysql.infoschema’@’localhost’;
After running that query, I can now see the database tab in phpMyAdmin.
