A Question About Database Restoration

Discussion in 'Site & Server Administration' started by nhatle84, Apr 28, 2010.

  1. #1
    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
     
    nhatle84, Apr 28, 2010 IP
  2. henkie

    henkie Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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.
     
    henkie, May 1, 2010 IP
  3. sysadmin

    sysadmin Peon

    Messages:
    111
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    take an sql dum to your linux sever ,,
    # mysqldum yourdb> yourdb.sql
    # replace 'xxxx.com' 'zzzzz.com' -- yourdb.sql
    Now restore this db
     
    sysadmin, May 2, 2010 IP
  4. crashus

    crashus Active Member

    Messages:
    90
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    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
     
    crashus, May 4, 2010 IP