Needed to change password after MySQL DB import?

  • mrpooh

    (@mrpooh)


    13 years, 1 month ago

    I transferred (really just COPIED) a blog from one host and one URL to another host with another URL.

    It seems to have worked, but I noticed that I needed to use the password from the original URL in order to access the WordPress Administration dashboard for the new URL.

    Question: Does that make sense? Is there some way to do the transfer that will allow using the new password? Is there some file that has the password that can be accessed (via FTP) and edited?

    Here are the steps I took:

    1. Exported the DB from the original blog using PhpMyAdmin in the Cpanel.
    2. Created a fresh WordPress install for the new blog with the new host — BlueHost.com, using their automatic install
    3. Copied over wp-content from old to new
    4. Imported the DB from the original blog
    5. Changed two records in wp_options table called siteurl and home for the new blog.

    Another Question:

    Generally speaking, in terms of getting all the important pieces of the WP Database, does it make a difference if I export and import the database using the following choices:

    1. PhpMyAdmin, which generates an SQL file
    2. The Export function in the Tools menu, within the WordPress Dashboard, which generates an XML file
    3. The WordPress Database Backup Plugin (which I installed), used within the WordPress Dashboard, which generates an SQL file
Viewing 1 replies (of 1 total)
  • bh_WP_fan

    (@bh_wp_fan)

    13 years, 1 month ago

    If you imported your original users, then you can login with them but, as long as the new user/password exists, you should still be able to use it also.

    Either way, you can always create/edit your user/password using the Users option in the WordPress admin area.

    There isn’t really any best way to backup and import an sql file. I think using the XML file makes it simple. But if you lost structure, it would be nice to have the SQL backup too, just in case.

Viewing 1 replies (of 1 total)
  • The topic ‘Needed to change password after MySQL DB import?’ is closed to new replies.