Skip to content

Instantly share code, notes, and snippets.

@sayful1

sayful1/import-mysql-data-from-sql-file.sql

Last active March 21, 2023 09:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sayful1/fc3f5c3bae5fa2928ed2c25acf58346c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sayful1/fc3f5c3bae5fa2928ed2c25acf58346c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import-mysql-data-from-sql-file.sql
# First switch to database
USE db_name;
# replace file name with full file path.
SET autocommit=0; source the_sql_file.sql; COMMIT ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment