A Question About Database Restoration

I've just finished a complete backup of my database www.XXXXX.com/forum.

I accomplished the restoration on my NEW DOMAIN www.ZZZZZ.com/forum, but everytime I visit www.ZZZZZ.com/forum it automatically redirect me to www.XXXXX.com/forum instead.

I believe it's possible to change the corresponding domain in phpMyAdmin & editing .httaccess in vbseo correct?

If I'm correct please show me how this is done - Thanks!
-Minh

 

You can search in phpmyadmin for these kind of settings. They usually deisgn the database with a url_setting table or something, and use the Search button and search for these kind of settings. Use the following to search %url% in all tables.
This searches for the term url in the database. Also check you .htaccess file for redirecting to the root domain, it could contain a redirect to xxxxx.com when browsing the site.

 

take an sql dum to your linux sever ,,
# mysqldum yourdb> yourdb.sql
# replace 'xxxx.com' 'zzzzz.com' -- yourdb.sql
Now restore this db

 

No need in dumping\restoring whole DB, just search for xxxx.com keyword and you will see like 1-2 entries in 'settings' table, simply change it