Thread Starter
b4wt
(@b4wt)
This backup was made at a different host, and i am moving away from them to another host.
I have imported through phpmyadmin and when i try acess this site, its redirecting to the OLD SITE, i assume this is because the admin CP still has the OLD url configured in the DB.
How and where do i change this to point to my new site?
thats in the docs:
http://codex.wordpress.org/Changing_The_Site_URL
theres 2 values, theyre both inside your options table.
Thread Starter
b4wt
(@b4wt)
`SQL query:
# WordPress MySQL database backup
#
# Generated: Monday 27. October 2008 09:41 UTC
# Hostname: myhost.com
# Database: mydb
# ——————————————————–
# ——————————————————–
# Table: wp_comments
# ——————————————————–
#
# Delete any existing table wp_comments
#
DROP TABLE IF EXISTS wp_comments ;
MySQL said: Documentation
#1046 – No database selected
I tried to take another backup and restore on top of the old one i imported already, as it was few days older.
How to fix this one?
This would be a more basic tutorial
http://www.tamba2.org.uk/wordpress/restore/
couple this with whooami’s given link:
http://codex.wordpress.org/Changing_The_Site_URL – read this, there is an easy quick fix at the beginning