WPBakery Page Export Import

—

### ✅ **Method 1: Use WordPress Native Export/Import Tool**
This works well for **individual pages** built with WPBakery.

#### **Step 1: Export the Page**
1. Go to **Tools → Export** on the original site.
2. Choose **“Pages”**, then filter to export **just the one page** you want.
3. Click **Download Export File**.

#### **Step 2: Import the Page**
1. On the new website, go to **Tools → Import**.
2. Choose **WordPress**, install the importer if needed.
3. Upload the export `.xml` file.
4. Assign author and check the box to **“Download and import file attachments”** if needed.

> ✅ This will preserve the WPBakery shortcodes and layout.

—

### ✅ **Method 2: Use WPBakery’s Template Feature**
Good for **reusing layouts** across multiple sites.

#### **Step 1: Save Page as a Template**
1. Edit your page with WPBakery.
2. Click the **“Templates”** icon (top of the editor).
3. Click **“Save current page as template”**, name it, and save.

#### **Step 2: Export Template**
1. Go to **WPBakery → Templates** in the admin menu.
2. Locate your saved template and click **“Export”**.

#### **Step 3: Import on New Site**
1. On the new site, go to **WPBakery → Templates**.
2. Click **Import Templates** and upload the `.json` file.
3. Now, when creating a page, use **Templates → Add Template → Your Template**.

> 🔁 This method gives you clean reusable layouts without affecting existing pages.

—

### 🧠 Pro Tip: For full fidelity
– Make sure both sites have:
– The **same theme**
– **Same WPBakery version**
– **Same plugins** used in the original page (e.g. sliders, add-ons)

—

Do you want help automating this process or including images/media with it too?

—

## ✅ Exporting a Specific Page in WordPress

### 🧩 Step 1: Identify the Page
Make sure you know the **exact title** or slug of the page you want to export.

—

### 🧰 Step 2: Go to Export Tool
– In your WordPress Dashboard:
– Go to **Tools → Export**
– Choose **“Pages”**
– Use the **filter** to select a specific page by:
– **Author**
– **Date**
– Or use the **Title** filter (if available)

✅ If your site doesn’t offer filters, select “Pages” and export **all pages** — you can edit the XML later if needed.

– Click **Download Export File**
– You’ll get an `.xml` file with the content and WPBakery shortcodes included

—

## ✅ Importing the Page into Another WordPress Site

### 📥 Step 1: Use the WordPress Import Tool
– Go to **Tools → Import**
– Select **WordPress** (install the importer plugin if not already)
– Upload the `.xml` file

### ⚙️ Step 2: Configure Import
– Assign to an existing user or create a new one
– ✅ Check **“Download and import file attachments”** (this will pull in images/media)
– Click **Submit**

—

## 🔄 After Import: Update & Review

– Go to **Pages → All Pages**
– Locate your imported page
– Click **Edit with WPBakery Page Builder**
– ✅ Review all sections, images, and links

—

## 🧠 Pro Tips

– If you only want one page from an `.xml` file that contains many, open the `.xml` in a code editor and remove the other “ blocks.
– For **reusable layouts**, use **WPBakery Templates** (explained in my previous reply).
– For **bulk export/import** of pages, use a plugin like:
– [All-in-One WP Migration](https://wordpress.org/plugins/all-in-one-wp-migration/)
– [WPvivid Backup](https://wordpress.org/plugins/wpvivid-backuprestore/)
– [WP All Export / WP All Import](https://www.wpallimport.com/)

—

Want help writing a quick script or command to isolate just one page from the exported `.xml` file?

—

## ⚠️ Before You Begin
– Always **backup both databases**.
– Both source and destination WordPress installations should use **compatible themes, plugins (especially WPBakery)**.

—

## ✅ Manual SQL-Based Export/Import of a Page

### Step 1: Export Page Data from `wp_posts`
Find the page in your database:

SELECT * FROM wp_posts WHERE post_type = 'page' AND post_title = 'Your Page Title';

Once you find it, **note the `ID`**, e.g. `123`.

Now export the post row:

SELECT * FROM wp_posts WHERE ID = 123;

—

### Step 2: Export Related Meta from `wp_postmeta`

SELECT * FROM wp_postmeta WHERE post_id = 123;

This will include WPBakery shortcode data and other page metadata.

—

### Step 3: Export Any Attached Media (Optional)
If you want to migrate images used on the page:

SELECT * FROM wp_posts WHERE post_parent = 123 AND post_type = 'attachment';

Also grab their meta:

SELECT * FROM wp_postmeta WHERE post_id IN (
  SELECT ID FROM wp_posts WHERE post_parent = 123 AND post_type = 'attachment'
);

—

### Step 4: Import Into New Site

On the new WordPress database:

1. Insert the `wp_posts` row:
– Ensure the `ID` you use doesn’t conflict with an existing post.
– If it does, update the ID and update related `postmeta` to match.

2. Insert `wp_postmeta` using updated post ID.

3. (Optional) Insert attachments and their meta if you exported those too.

—

## 🧠 Pro Tips

– **Auto-increment ID conflict**: Make sure imported rows don’t overwrite anything.
– **Fix GUIDs**: Update the `guid` field if needed (though WP usually regenerates permalink structure).
– **Fix post_parent** for media attachments if you change the page ID.

—

## ✅ Quick Example (Exporting & Reimporting)
Here’s an export example (using `mysqldump` for ID `123`):

mysqldump -u root -p your_db wp_posts --where="ID=123" > page.sql
mysqldump -u root -p your_db wp_postmeta --where="post_id=123" >> page.sql

Then import into your new database:

mysql -u root -p new_db < page.sql

—

Do you want a PHP script or MySQL query pack to automate this for a given page title or ID?