Please verify this process for me

  • brotherjoe

    (@brotherjoe)


    16 years, 1 month ago

    I have a WP site up on a subdomain (dev.mysite.com) and I need to launch it on http://www.mysite.com. I think I understand the process but would like someone to corroborate before I try it.

    1) Archive all the files in the dev.mysite.com directory.
    2) Copy and unarchive them in the http://www.mysite.com directory.
    3) Download the DB and do a Find/Replace to replace “dev.mysite.com” with “www.mysite.com”
    4) Upload the DB through myphpadmin (or do I create a new DB at this point?)
    5) Go into the WP-Admin on the dev.mysite.com site and change the site index to http://www.mysite.com.
    6) Change the name of index.html on the current http://www.mysite.com so that index.php becomes visible.

    My main question is on step 4 – do I just create a new database so that the live and the dev sites can both keep running?

    Thanks,

    Joe

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter brotherjoe

    (@brotherjoe)

    16 years, 1 month ago

    Also, mysite.com is just a fake name. I don’t have anything to do with the ACTUAL mysite.com….

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    16 years, 1 month ago

    You could do that or you could just do this: http://codex.wordpress.org/Moving_WordPress

    You can keep your DB, just change a setting and move the files.

    Thread Starter brotherjoe

    (@brotherjoe)

    16 years, 1 month ago

    Thanks!

    Question: if I do that, will I still be able to use the dev.mysite as a working site?

    I was thinking that I needed to essentially clone the site over in order to have the dev and the live site both active but not connected.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    16 years, 1 month ago

    If you need both sites, then you’ll need two databases (or one database with two WP prefixes… you can run multiple blogs off one DB) and two installs of WP, yeah.

    fangfoo

    (@fangfoo)

    16 years, 1 month ago

    A normal part of db restore is to create an empty db on the new server with the same name as the old database. Then import the db file into the new database.

    I know this process works as I just did it.

    example commands (mySql command window)

    CREATE DATABASE oldBlog;
    GRANT USAGE ON oldBlog.* to db_user@localhost IDENTIFIED BY ‘db_passwd’;
    GRANT ALL ON oldBlog.* TO db_user@localhost IDENTIFIED BY ‘db_passwd’;

    Then from a command prompt (in the bin directory is easiest) type:

    mysql -u username -p dbname < blogSQLbackupfile.sql

    (This assumes not compressed, file is in the same directory as where you are executing the command)

    I do not use MyPhpAdmin so I don’t know if you need to also create an empty DB before running the import tool or if it will do it for you.

    hth

    O

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Please verify this process for me’ is closed to new replies.