I want to move my entire website from site A to site B.
I think you mean to say “from path A to path B”, and that would mean you must now edit the new wp-config.php to use the imported SQL data (including database name, table_prefix, SQL username and password) after it (the database) has been updated to the new URL (path):
cPanel > phpMyAdmin SQL
note: Edit ‘pref’ (three places below) to your own table_prefix and change ‘http://www.olddomain.com’ and ‘http://www.newdomain.com’ as required (three places each and with no trailing slashes)
UPDATE pref_options SET option_value = replace(option_value, 'http://www.olddomain.com', 'http://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE pref_posts SET guid = replace(guid, 'http://www.olddomain.com', 'http://www.newdomain.com');
UPDATE pref_posts SET post_content = replace(post_content, 'http://www.olddomain.com', 'http://www.newdomain.com');
thank you but I can’t find that.. is there a video ?
What are the steps in transferring from path a to path b ?
Maybe I did something wrong from the beginning .. 🙁
I have the php admin on 1and1.com
What are the steps in transferring from path a to path b ?
Maybe I did something wrong from the beginning .. 🙁
Everything you have done so far looks fine to me…but here are some links where you can double-check, if you wish:
https://codex.wordpress.org/Moving_WordPress
https://www.google.com/search?q=moving+wordpress
I have the php admin on 1and1.com
That is where you go with the code I have posted after making the necessary edits. Go to phpMyAdmin and find your database, then run the edited coded as “SQL” from the tab near the top of phpMyAdmin.
note: Always, always first download a backup copy of all tables prior to making any changes.
MySQL said: Documentation
#1146 – Table ‘db589056962.pref_options’ doesn’t exist
Can I give you my login credentials so you can do it for me ?
We never make solicitations here in these forums, and we never even offer to help anywhere other than here.
What kind of errors did you get?
edit: Ah, I see!
You did not edit “pref” to your own table_prefix…
'db~~~62.pref_options'
#1146 – Table ‘db589056962.pref_options’ doesn’t exist
when I entered your code at the SQL :
#1146 – Table ‘db589056962.pref_options’ doesn’t exist
You did not edit “pref” to your own prefix…
db~~~62.pref_options'
note: You should never post your database name or table_prefix publicly since every hacker in the world will be able to know it without having to try to figure it out. So after all of this is done and you have things working, we can next also deal with that!
Sorry about that, I did not know.
How do I edit pref ?
Sorry for all the questions
You would edit ‘pref’ the same way you must edit the old and new URLs in that code, and I do that with NotePad++. However, you can do that with any plain-text editor as long as it truly is plain-text and does not add any kind of formatting.
Sorry for all the questions
No problem at all. It is far better to ask than to guess-and-poke!
