import-db

Simple script for automatic MySQL database import from rshop dumps.

Installation

brew tap riesenia/utils
brew install import-db

Configuration

After installation, ~/.import-db.conf is automatically created.

Usage

import-db [OPTIONS] <database> <url>

Arguments:
  database              Target MySQL database name
  url                   Path URL to the first (ending 1.sql) file

Options:
  -u <user:password>    Basic authentication credentials
  -h                    Show help message

Run the script with the database name and URL to the first file (name ending 1.sql):

import-db mydb https://example.com/export/db-x.1.sql

The script will automatically run post-import queries after the import (if configured).

Post-import queries

You can define post-import queries in ~/.import-db.conf using POST_IMPORT_QUERIES. These will be automatically executed after the database import completes.