Getting Started

Deployment Deployment - Diagnose Migrations Staging

Site Management

Backups Client Reporting Passwords Plugin Automation Plugin Management - Global Plugins & Themes - Diagnose Plugins & Themes - General Plugins & Themes - Git Plugins & Themes - Logs Must Install White Label WordPress Updates

Caching & Performance

Caching Caching - Blogs/Articles Caching - Diagnose Caching - Git Caching - WooCommerce Redis Optimize & Scale

Security

Security Security - Firewall

SMTP, CDN & DNS

SMTP SendGrid CDN CDN - AWS CDN - Cloudflare CDN - Diagnose Domains & DNS

Server & Tools

Analytics & Logs CRON Jobs Database Debug Tool Git Monitoring PHP Settings Redirects SEO Tools Server Errors sFTP SSL

Staq Billing

Staq Billing > Account Staq Billing > Client Staq Billing > Setup

Media

Media Media - Diagnose Media - Optimize

Accounts & Billing

Accounts & Billing

General

WordPress Hosting Website Diagnose Troubleshoot - Other

Import a third-party SQL database over an existing website


On this page

    At Staq, we’re always working to provide solutions that streamline your web management tasks. Currently, we don’t have a direct SQL import function, but rest assured, this feature is in the pipeline. Moreover, the access to phpMyAdmin isn’t available by default. You would need to request this feature, but good news is that we’re working to make this a default feature in the near future.

    In the meantime, there are several alternative methods you can utilize to import your third-party SQL database over an existing website. Here’s a step-by-step guide:

    Method 1: Contacting Support

    1. Export the database from your third-party host and save it as an SQL file.
    2. Upload this file to a secure cloud storage service such as Google Drive or Dropbox.
    3. Contact our Support team at https://www.wpstaq.com/support/. In your message, make sure to include:
      1. Shareable link for the SQL file.
      2. the URL of the website so we can do a search/replace of the database.

    Our team will take over from here, download the SQL file from the link you provided, and carry out the import process on your behalf.

    Method 2: Using All-In-One WP Migration

    All-In-One WP Migration is a popular WordPress plugin that helps in migrating websites. You can use it to back up your database only, and then restore it on your Staq website.

    Here are the steps to follow:

    • Install the All-In-One WP Migration plugin on both your third-party website;
    • If you haven’t created the WordPress environment on Staq, use this KB to create a WordPress site even if it is an empty installation
    • On the old host, enter both:
      • the current URL
      • Staq hosted URL:

    • Open Advanced options
    • Select everything but leave Do not export database (sql) as unchecked:

    This will only backup the database only.

    Once it has completed, go to your Staq site and:

    • Install the All-In-One WP Migration plugin on your Staq site
    • free version:
      • go to All-In-One WP Migration > Import and upload
    • If you have the paid version:
      • Upload the database backup via sFTP to the /wp-content/ai1wm-backups/ path

    The plugin will now restore the database on your Staq website.

     

     

    Need some help?

    We all do sometimes. Please reach out to our support team by dropping us a support ticket. We will respond fast.