What concretely happens on import?

Support
1

I need to export a LocalWP site to give the archive to outsource developer, and than get the archiv from him to import it.

What happens on import a site from zip? Are the site and database overwritten completely? Or only differences? Or will I get the second site in my LocalWP, like my_site(1)?

2

Hi @EvgeniyO! When you reimport the site with the zip file again it will essentially create a new copy of the site as you noted. You’ll have to slightly edit the Site Name or edit the original as you can’t have two sites with the same name (local domain) in the app.

1 Like
3

@Nick-B
I have further questions to importing routine:

  • Is there a way to rewrite/update the initial site on import, automatically or manually?
  • Is this even possible, if an export was done in MariaDB environment, and import should be into MySQL? My outsource developer was running into error: 'Can't connect to MySQL server on '::1' (10061)' on trying to select MySQL on import, with MariaDB he had no issues.
  • In best case, is it possible to manually rewrite only some files and db tables in existing site, without to mess settings? If I extract the zip, which should be imported, take needed plugin files and corresponding db tables, and just overwrite those of the initial site - can I break something on this way?

I’m very sorry for this bunch of questions - I have pretty fragile setup, where in the context of the initial site run two databases, one of WP, another standalone, which is populated by external crawler and is synced by SQL event to the WP’s db. LocalWP is synced by wp migrate to the hosting. It would be a nightmare to mess things up with a not accurate update.

This update (coming from outsource developer) is the last substantial task before going live. After going live I plan to write here a how-to article about my setup, pitfalls and hints.

4

Hey @EvgeniyO

  • Is there a way to rewrite/update the initial site on import, automatically or manually?

Could you clarify what you mean by this? What would be an example of something you’d try to change?

  • Is this even possible, if an export was done in MariaDB environment, and import should be into MySQL? My outsource developer was running into error: 'Can't connect to MySQL server on '::1' (10061)' on trying to select MySQL on import, with MariaDB he had no issues.

That “Can’t connect” error could indicate that he had conflicting processes on his device. Sometimes a simple reboot or checking the task manager and clearing out all the processes and restarting will do the trick. If he has further issues he can try reaching out here separately with more device details and logs for us to look at.

  • In best case, is it possible to manually rewrite only some files and db tables in existing site, without to mess settings? If I extract the zip, which should be imported, take needed plugin files and corresponding db tables, and just overwrite those of the initial site - can I break something on this way?

I may need a little clarification on this as well. Are you talking about manually extracting the items from your Local site to update your live site? Or is this a different way of exchanging updates you’re trying to do with your developer?

Feel free to include any other additional details, screenshots or even a short Loom video to help illustrate anything here and we’ll be happy to take a further look.

5

So, the best case:

  1. extract archive,
  2. select needed plugin files
    2.1 overwrite them in /~Local Sites/initialSite
  3. take local.sql from archiv,
    3.1 select queries, which correspond with plugin,
    3.2 insert into db of initialSite

Archiv was created with LocalWP and MariaDB, initialSite is on MySQL.

6

Hi @EvgeniyO

It sounds like instead of you both trying to import and export back and forth, what you and your dev are doing might work better as a Git-based workflow utilizing a hosted development environment where you have a Staging/Development environment you can interact with. It might be worth the time long term to set this up and avoid potential headaches and other issues.

You can certainly only manually extract and import specific pieces of your site, without touching other items, but this of course can get tricky. I’d also recommend setting up a backup system where you are taking frequent backups especially before any major changes, either with a plugin, full site export, or using our Cloud Backups Add On. So that way your work is covered before doing any major changes.

Cloud Backups

Export a Site

7

I considered Git, but this outsource is an absolutely single unique task, will never happen again.
Would you say, it worth considering, instead of LocalWP export/import to use something like WP Migrate?

8

With this being a “one and done” project I’m not sure that would save you much time but that might be dependent on the timeline for this endeavor and how long you’ll be collaborating.

9

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.