Need Database Related Help..

Discussion in 'Databases' started by webaffiliate, Dec 20, 2010.

0
  1. #1
    Hey Guys,

    I want to move my wordpress blog on another hosting... But don't know how can i use Database..

    I mean i want every thing on that server where i wish to move to blog.

    How i can get each and every thing .. like post, cetegories, tag..

    Please Help
     
    webaffiliate, Dec 20, 2010 IP
  2. maneetpuri

    maneetpuri Active Member

    Messages:
    152
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Hi,



    Here are the steps that you may follow to accomplish the same: -



    a. Take the backup of the MySQL database from the existing Server.

    b. Take the backup of the Scripts from the existing Server.

    c. Stop the existing website by putting a under maintenance page on it

    d. Upload the Scripts on the new server

    e. Upload the MySQL database on the new server

    f. Change the configuration of the scripts on the new serve to include the login details of MySQL on the new server

    g. Change the name servers of your domain to point to the new server



    And you are done, your blog is now on the new server.



    Cheers,



    ~Maneet
     
    maneetpuri, Dec 20, 2010 IP
  3. prptl709

    prptl709 Guest

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I want to know about how the stored procedures and triggers are written and when we have to create it?
     
    prptl709, Feb 23, 2011 IP