Website and Database copy

[orchardapple]

Could anyone offer me some assistance with copying a WP site and database to another domain of mine, i'm in a complete muddle with backups, imports etc

Thanks Andy

 

[retired_member36]

PM Sent

 

[wonder_lander]

I use tsohost.co.uk and they've been kind enough to do this for me in the past. If you're stuck don't rule out asking your host for assistance!

 

[Murray]

I use tsohost.co.uk and they've been kind enough to do this for me in the past. If you're stuck don't rule out asking your host for assistance!

Tsohost moved a wordpress site to their hosting from Daily for me recently

Was free and appreciated their help as I wouldn't of known how to do it properly, having to change the config and what not.

The only thing is once it's moved check everything is working, including all the plugins.

I only realised a few days after the move the api key for wordfence security had stopped working and id had some spam put on the site

 

[PanzerWagon]

I would learn to do it manually as it can come in handy. Pretty simple to do, plenty tutorials rather than relying on the host.

Various ways to do it and some quicker but require more knowledge, this is by far the easiest:

Download full existing WP install from the public html folder via FTP

Export the existing MySQL database from phpmyadmin area in cpanel in gzip format

Upload the WP install via FTP to the new public html with your new host / different domain.

Create a new MySQL database via cpanel (make a note of the database name, username and password)

Once created import the gzip database you downloaded into using the import function.

Back to FTP and edit wp-config.php and replace the old db name, username and password with the new ones you just created. Host is usually localhost. But sometimes an IP address if you're on a cloud based system.

If you are moving domains like you said, then you will need to edit 2 lines in the wp_options table (site URL and home url I think they are called as I've forgotten off the top of my head) and replace the old domain name with the name domain name.

Site should load fine. I always login and resave permalinks in my desired format too.

 

[ian]

I would learn to do it manually as it can come in handy. Pretty simple to do, plenty tutorials rather than relying on the host.

Various ways to do it and some quicker but require more knowledge, this is by far the easiest:

Download full existing WP install from the public html folder via FTP

Export the existing MySQL database from phpmyadmin area in cpanel in gzip format

Upload the WP install via FTP to the new public html with your new host / different domain.

Create a new MySQL database via cpanel (make a note of the database name, username and password)

Once created import the gzip database you downloaded into using the import function.

Back to FTP and edit wp-config.php and replace the old db name, username and password with the new ones you just created. Host is usually localhost. But sometimes an IP address if you're on a cloud based system.

If you are moving domains like you said, then you will need to edit 2 lines in the wp_options table (site URL and home url I think they are called as I've forgotten off the top of my head) and replace the old domain name with the name domain name.

Site should load fine. I always login and resave permalinks in my desired format too.

Good set of instructions there and very similar to how I did it when manually transferring a site to a new host provider. Having said that, it was the same domain name, but the majority of it is the same. Also allowed me the opportunity to change from using 'admin' to something more specific to avoid an easy hack (this was discussed on here a while back)

 

[PanzerWagon]

Thanks, they are by no means thorough but should give OP an idea. I think when I first did it I just watched a YouTube video and had the hang of it in about 10 minutes.

Avoiding admin as a username is a good tip, I install Limit Login Attempts too on all WP installs so multiple failed attempts are locked out by IP address.

 

[ian]

Avoiding admin as a username is a good tip, I install Limit Login Attempts too on all WP installs so multiple failed attempts are locked out by IP address.

Me too, works very well.

 

[bedazzledaz]

If you have Wordpress installed on the new server then using the duplicator plugin makes it very easy

 

[martin-s]

Do you have cPanel access? If so you can use the backup and restore process.

 

[Helmuts]

$5 on fiverr.. that's it


Sent from my iPhone using Tapatalk