Still not good at Migrating WordPress websites

Hi Kevin,

Where I get stuck is the point where I've imported the sql file and have to edit the config file. When I tried again today, wp_login showed up but wouldn't accept the new user details. So something is wrong in my process but I can't be sure what,

I did notice that I had to edit my imported sql file so phpmyadmin on my server could actually import the backup database. I had to change the username detail in the database towards the top. Zac didn't have to do that.

The domain add on is accessible as a folder in my server so that exist. The child directly is a cgi-in. The Wordpress files go alongside (not inside) that folder.

Also I get the feeling I'll need an alternative to the search and replace plugin once I've got in. :-)

What did you change exactly? That might be why you can't log in.

And to clarify, an add on domain is like having myfirstsite.com and mysecondsite.com on the same hosting account, but completely separate domain names. You're describing putting wordpress in a subfolder of your main domain in your first post, which is not an addon. I just want to clarify what your goal is.

My web host calls them domain addons. They're like sub domains only they're a second level to the root directory and have their own suffixes. They share my space allocation with the root and have their own ftp information to login, of I can access them directly from the root. You can see this if you click my first link. As I write this now, it contains one cgi-bin folder,

I can't tell you precisely what I changed as I'm away from the computer after a long day but I simply changed the reference to the localhost username to the username I set up via my web host. I had to do this twice before phpmyadmin would import the file..

But it's in that folder/add-on I wan to put Wordpress

-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Dec 08, 2015 at 06:35 PM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `localwp`
--
**CREATE DATABASE IF NOT EXISTS `localwp` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `localwp`; **

This is the bit where I changed the information in the localwp.sql... exported and imported in phpmyadmin.

One thought is that if I have to change the site URL in config.php... Do I not need to do the same for the sql file?

I may have figured out what's been going wrong.

I was unsuccessful, again in migrating the site over to my server. but I noticed this time that some of the files from wp-admin and some from the wp-includes haven't actually transferred over. Filezilla say it's a critical disk error - disk, full which I find very odd because there is plenty of space on my folder. I didn't notice this yesterday, whether it's because it didn't happen or I missed it, I'm not sure but it makes sense.

Also I was able to import the sql file first time without having to change it, and with fewer sql queries this time.

So right now, yet again this is all that's showing up on the site. http://www.wordpress-jonniegrieve.jonniegrieve.co.uk/

**Etiam Mollis Sit Gratt Spore.

Maecenas sed diam eget risus varius blandit sit amet non magna. Nullam quis risus eget urna mollis ornare vel eu leo. Nulla vitae elit libero, a pharetra augue.

and a list of broken images**

If I'm understanding your last question your SQL user you created on your host is how wordpress has credentials to update the wordpress.

When you log in via wp-admin, you're actually logging in with the credentials inside of the database. There are two different sets of credentials there. One you use, and one wordpress uses.

I may need a little more practice then. I've got a proper note of the username and password I use to login but I can't really remember how I got that password and username in the first place. phpmyAdmin might have something to do with it. Once I'm up to date here I'll have a practice with another website.

There's one more question I have though if I haven't tried your patience enough already :)

I've run a search and replace plugin on the site twice now but my basic navigation still isn't working. I think it's still looking for index.php on my localhost. I've tried running the plugin on all tables in the database. I used Better Search Replace 1.2.9 by Expanded Fronts.

Many many thanks again!

I don't know how, or why, but the links on my main navigation are now working!!!.

I did look at my Search/Replace plugin one more time but I did dry runs that told me the tests I was making wouldn't have made any changes anyway. But right now, my websites links are all working and this saga is finally over. :D

Thanks again.