'wp' as the database name – migration problems

  • Resolved artildo

    (@artildo)


    11 years, 8 months ago

    Hi guys!

    I run a WordPress site on localhost. Unluckily, I named my database as ‘wp’. Now I need to create a copy of the site on localhost and soon I’ll have to do the same in the web.

    I used to export database as a .sql file and then manually change all ‘database name’ and the folder rout. It worked when the site was not that big. Now I cannot intelligently change all these ‘wp’ as a database name and route name without damaging different files and tables which have ‘wp’ in its names.

    What could be done? Maybe a plugin or some smart know-how to change right ‘wp’ in the sql export? Note that i cannot just change ‘/wp’ to ‘/something’ – in SQL file there are many routes like ‘/wp-content/…’

    Thanks

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

  • Can you export a copy of the database from phpMyAdmin to your computer? If so, create a new database with a different name and then import the database into that.

    Thread Starter artildo

    (@artildo)

    Kristina, yeah, I did it. Actually, I checked on a wordpress with another DB name – there is only one instance of the DB name, at the beginning.

    I forgot to mention, that route to the site is C:\xampp\htdocs\wp. I think – this is the problem. I have to change ‘wp’ out of this path without damaging ‘wp-content’ and other names.

    Thread Starter artildo

    (@artildo)

    Pardon, Krishna, not Kristina

    Thread Starter artildo

    (@artildo)

    Guys, thanks to those who read this

    I walked through my sql file, changing /wp/, /wp’, /wp”, \wp/ to something less confusing. And of course, manually changed the DB name in the sql file.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘'wp' as the database name – migration problems’ is closed to new replies.