Skip to content

Instantly share code, notes, and snippets.

@a1exlism

a1exlism/mysql_import.md

Last active December 31, 2019 02:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save a1exlism/5f73933a7a09e9d07c75f3e9a4056349 to your computer and use it in GitHub Desktop.
Save a1exlism/5f73933a7a09e9d07c75f3e9a4056349 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql_import.md
  1. mysql terminal import
    1. CREATE DATABASE dbname;
    2. mysql>USE dbname;
    3. mysql>SET NAMES utf8
    4. mysql>SOURCE /absolute/path/YOURs.sql;
  2. terminal import

    $mysql -uUSERNAME -p DBNAME < DBNAME.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment