Migration Problems

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: migration, server, Transfer

Author

Posts
September 28, 2015 at 2:52 pm #54841

Jen Thomson
Buyer

Post count: 145

I’ve just transferred my site to it’s new domain from the development server and I have lost all of my custom place settings, prices, listing form.

I backed up the database, changed the urls, exported it, changed the urls that hadn’t been changed and imported it so I though that would have worked ok.

Any ideas on how to fix this? I don’t want to have to go through the whole setup process again if possible.

September 28, 2015 at 2:53 pm #54842

Jen Thomson
Buyer

Post count: 145

This reply has been marked as private.

September 28, 2015 at 9:29 pm #54915

Guust
Moderator

Post count: 29970

I guess you ran all the GD Tools, and have checked your permalinks at GD > Permalinks and Settings > Permalinks?
Your permalinks do not seem correct:
https://wpgeodirectory.com/docs/basic-installation/#postnames

If you need us to have a look, post your WP admin details.

https://codex.wordpress.org/Moving_WordPress#Changing_Your_Domain_Name_and_URLs

September 28, 2015 at 9:41 pm #54920

Paolo
Site Admin

Post count: 31211

Hi,

how did you cahnge the URL.

My procedure to get this right at 1st attempt is:

1) Backup all files and transfer to new server
2) Export the db to transfer
3) Import it in the new database
4) Upload this scirpt via FTP in the root of your website (where wp-admin, wp-content and wp-includes folders are)
5) Run the script to find and replace the old domain with the new domain.

Following this procedure you can’t go wrong.

Let us know if you still have problems.

Thanks

September 28, 2015 at 9:46 pm #54922

Jen Thomson
Buyer

Post count: 145

This reply has been marked as private.

September 28, 2015 at 11:18 pm #54949

Paolo
Site Admin

Post count: 31211

Hi,

your WordPress permalinks settings where wrong.

Let us know if you still see problems.

Thanks

September 28, 2015 at 11:28 pm #54952

Jen Thomson
Buyer

Post count: 145

This reply has been marked as private.

September 28, 2015 at 11:48 pm #54955

Paolo
Site Admin

Post count: 31211

I’m sorry, I confused the 2 website. It looks like the main CPT is gone. I don’t know Sequel Pro, I’ve never used it, but I fear it could have broken some serialized option.

Could you please try reimporting the backup following the procudure I gave you? That is what I’d try to do.

Thanks

September 29, 2015 at 11:24 am #54983

Jen Thomson
Buyer

Post count: 145

That worked! Thank you Paolo.

September 29, 2015 at 1:09 pm #54998

Paolo
Site Admin

Post count: 31211

🙂

December 22, 2015 at 2:49 pm #64891

Jen Thomson
Buyer

Post count: 145

Hello. Sorry to revisit an old thread but I am trying to do this in reverse, so that I can back up and update plugins locally. Following your instructions Paolo…

1) Backup all files and transfer to new server
2) Export the db to transfer
3) Import it in the new database
4) Upload this scirpt via FTP in the root of your website (where wp-admin, wp-content and wp-includes folders are)
5) Run the script to find and replace the old domain with the new domain.

When I get to step 3 I get an error message saying

Error

SQL query:
INSERT INTO wp_geodir_attachments VALUES(“”,””,””,””,””,””,””,””,””,””,””,””);

MySQL said: Documentation
#1062 – Duplicate entry ‘0’ for key ‘PRIMARY’

Any ideas?

December 22, 2015 at 6:27 pm #64939

Paolo
Site Admin

Post count: 31211

Hi,

is the new database where you are trying to import an empty database?

Let us know,

Thanks

December 22, 2015 at 6:50 pm #64950

Jen Thomson
Buyer

Post count: 145

Yes it is.

December 23, 2015 at 5:14 pm #65120

Stiofan O’Connor
Site Admin

Post count: 22956

Hi Jen, This is a common issue when transfering DB’s, there are many solutions depending on what stage you are at, please find the one most appropriate from stackoverflow: https://www.google.co.uk/search?q=Duplicate+entry+‘0’+for+key+‘PRIMARY’

Thanks,

Stiofan
Author

Posts