• Rainbow Forge

    (@rainbowforge)


    Hello there!

    I’m trying to build WP sites locally using Studio WP, but I didn’t realize that it uses SQLite instead of mySQL. Because of this, my usual method of migrating sites (backup plugins such as updraftplus and AIOWPM) are not working.

    I was wondering if anyone here might know how to migrate a site built locally using Studio WP to a hosting provider other than wp.com?

    Thanks in advance!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter Rainbow Forge

    (@rainbowforge)

    Correction: I was able to migrate using AIOWPM but not using Updraftplus.

    That’s great to hear, the migration was done! Therefore, here is the manual way of migration without any plugin:

    You can migrate your Studio WP site (which uses SQLite) to a regular MySQL-based host by manually exporting and importing your content. First, go to your local Studio WP site’s dashboard and navigate to Tools → Export, then choose “All Content” to download an .xml file containing your posts, pages, media, and menus. Next, set up a fresh WordPress installation on your hosting provider, go to Tools → Import, install the WordPress importer if prompted, and upload the .xml file. After that, manually reinstall your theme and any plugins you used on your local site, as these won’t be included in the export. Finally, to ensure your media files (like images) transfer correctly, copy the contents of the /wp-content/uploads/ folder from your Studio WP site and upload them to the same directory on your live site using FTP or your host’s file manager.

    This process doesn’t rely on migration plugins and works well for moving content from a SQLite environment like Studio WP to a MySQL-based host.

    Thread Starter Rainbow Forge

    (@rainbowforge)

    To anyone reading this thread at a later date, do not do what @wpfy suggests. This would not preserve any customization and changes you’ve made via your theme or via a site builder afaik, and you’d still likely have to run Media sync to get the uploads to show up in your media folder. I already knew that, but I tested the process anyway just to make sure.

    I know WordPress importer exists, and I also know how incapable of handling most things it is. There’s a reason migration plugins exist in the first place. I asked a question regarding converting a SQLite database to MySQL using Updraftplus or other plugins such as All in One WP migration (which works far better than your suggested method). Your response is not answering my question.

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

The topic ‘Studio by WordPress To Hosting Migration’ is closed to new replies.