MYSQL

IMPORT SQL FILES IN MYSQL

(quick guide & examples)

Open the command line and run mysql -u USER -p PASSWORD < PATH/FILE.SQL

COMMAND LINE IMPORT

01

MYSQL WORKBENCH

02

Install & launch MYSQL Workbench, add your database to the connections list.

Connect to your database > Server > Data Import > Choose your SQL file.

PHPMYADMIN WEB MANAGER

03

Unzip into your "HTTP" folder, access phpMyAdmin in your browser.

Select your database > Import > Select your SQL file.