Inserting gallery into page: not working II

When I get time tomorrow I’ll write up how I did it. There were the usual added
complications. And as I can’t seem to edit the last post which I wrote rather hastily I’ll say here that actually I used both parts of that page. The manipulation of the database in phpMySQL is crucial.

So MODS… DON’T marked this as solved yet. Or ever ideally; it’s a very annoying habit you all have.

I confused the issue a bit with the information about copying a site to localhost because I was trying to do that as well as change the ports to 80 and 3306.
Anyway it’s extremely easy to do the latter, and no re-installation of WP is required. So, assuming you DO have wordpress already installed locally, and working on ports 8888/9, set MAMP to the other ports. Open the start page and launch phpMyAdmin. Select the database in the left hand column (presumably you’ll only have one, and you probably remember the name of it from installing WP). On the drop down list select wp_options. Click the ‘Browse’ tab in the resulting window.
The first line should be siteurl with an option_value of https://localhost:8888.
Double click on it or click edit and change it to https://localhost
The database page runs over 2 pages. At the bottom go to page 2 and find option_name home and change that to https://localhost as well.
I’m using a mac so I don’t know if windows addressing is the same but as long as you get rid of the 8888 part I think it should work.
I had to clear the browser cache to get it to forget the 8888 but it was that simple.

If you are also cloning an active site to localhost I did it by using Updraft to backup to Dropbox (I couldn’t see a way to simply download to disc) and downloaded the files from Dropbox. I then used Updraft ‘upload backup files’ and selected the files that I downloaded. I also used Tools – Export (from the live site) and Import the resulting xml file (to the local site). Don’t know if this is really necessary but it’s easy enough. Then I went to phpMyAdmin in the control panel of the remote server. Selected the correct database (if you aren’t sure, try them until you find one with the same list of items as your local one) and, well just follow the instructions in this page referred to previously.
Going to your own phpMyAdmin from MAMP start page import the file.
If you make a new database you have to find and open wp_config.php in a text editor and change the name of the database on line 19 to the local one. Once things are up and running you can delete the old database. I think that’s all. I worked it all out using that link.

The only slight fly in the ointment is that the gallery thumbs are displaying with a Permalink below. How do you turn that off?