How to replace values in mysql? (because of Server migration)

Discussion in 'Server Operation' started by Pasco, Dec 22, 2006.

  1. Pasco

    Pasco Member

    Hi all

    I have a very newbie question :p!

    I've installed a new ISPServer and migrate now the websites from the old server. Some paths have changed because I manually set up the few clients. So for example client 13 is now client 6.

    So I took phpmyadmin and searched for %web13%. I found 328 hits in one datebase, I can't change them all manually :). Can you give me a hint how I can replace all values with %web13% to %web6%? I don't know the sql.. :-(

    thanks so much for your help :)!
    P@sco
     
  2. martinfst

    martinfst Member Moderator

    Bad idea

    This is probably a bad idea. The identifiers are not only used in the database, but they connect also to your filesystem where your home directories are. It's also used e.g. to identify users in the system passwd file. Either migrate 1-on-1 or setup every customer manually on your new server and only restore the home dir contents.
     

Share This Page