Database Name Change. Possible?

  • Resolved tfkm

    (@tfkm)


    15 years, 1 month ago

    Hi there,

    I am currently running four WordPress sites all on separate hosting, but bringing them under the same roof. The sites will still operate and appear as if they are completely separate, but they will share one hosting account and one set of MySQL databases.

    Unfortunately, three of my databases all have the same name “xxxx_wordpress” (where xxxx is the login name of the hosting account). Is is possible to change the name of the databases so that all of them can be restored to, and used under, the new hosting setup, or am I stuck with picking one to continue using the xxxx_wordpress name and starting new databases for the others, thus losing the old blog posts etc?

    Many thanks, in advance,
    David

Viewing 2 replies - 1 through 2 (of 2 total)
  • MichaelH

    (@michaelh)

    I’d backup all your databases at ‘old’ host.

    Create four new databases at the new host.

    Restore each database using phpMyAdmin to its respective new database.

    Update DB_NAME (database name) and other info as appropriate in each of your four wp-config.php files.

    Thread Starter tfkm

    (@tfkm)

    Thanks MichaelH,

    That seems more straightforward than I expected. I’ll give it a try.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Database Name Change. Possible?’ is closed to new replies.