• Hi everyone,

    I am currently switching to a new wp theme from my old one. I was planning on creating a new subdomain so i can work on the new theme to make sure everything is working correctly and make a few minor changes (i don’t want to edit my site live). Does anyone know how I could access the materials from my database on my current site so i can see exactly what it will look like? Im also open to suggestions if there is a better way of working on my theme without going live.

    Thanks in advance

Viewing 5 replies - 1 through 5 (of 5 total)
  • hey there!

    for stuff like this, i usually go the route of using the wordpress export tools (Dashboard–>Tools–>Export) and export everything

    then over on the dev site i install the wordpress importer and select the newly generated export file

    during the import, choose to import all media too if prompted

    this should allow you to install the new theme and play with it with your real content.

    it’s not synced, so before launch you’ll either need to reimport or hand propagate your edits

    if you want me to delve into any pieces here just let me know!

    good luck!

    Thread Starter Midi__

    (@midi_)

    hey bernbe!

    Thanks so much for your comment. That actually makes perfect sense. I think ill go ahead and use that approach. I just want to make sure, if i export a wordpress are all of my settings kept the way that i had them originally? meaning any widgets i have or anything i stylize? Thanks again!

    Hey there

    Actually with the method I mentioned I don’t believe widget/appearance/plugin settings migrate, just content

    The quick way I can think of for this needs database access, do you have phpMyAdmin or mysql available to you?

    If yes, clone your existing database, thus preserving all those other settings, and set up a new user to access this database.

    In phpMyAdmin, you can use the copy database option on the operations tab after selecting your database. The new user can be set up on the new database’s privileges tab

    I know this is kinda brief so I apologize for the rabbit holes, but I am on my phone,saw this and wanted to get you something

    Good luck!

    Thread Starter Midi__

    (@midi_)

    Hey bernbe,

    Awesome i get most of that. the only thing i don’t understand is the need to get create a new user? I mean why do i need to? i can’t just access if from my current account or is that creating a separate database i can work from?

    The only reason i was worried about the appearance stuff is when i am done editing on my sub domain I’m not going to want to have to redo the whole thing you know?

    Thanks again.

    PS i do have phpmyadmin on my blue host account. we also have cPanel if that helps

    hey there

    the only reason for the new database use is just to isolate the installs. i usually give every wordpress it’s own install which just adds a little more security to the mysql instance, but you are totally right that it’s not required 😛 there would be nothing wrong with using your existing db user, but you would have to grant them perms on the new db

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

The topic ‘Adding subdomain to edit new wp theme (database access)’ is closed to new replies.