Skip to content

Instantly share code, notes, and snippets.

@majeedraza1

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

Last active March 21, 2023 09:23
Show Gist options
  • Save majeedraza1/fc3f5c3bae5fa2928ed2c25acf58346c to your computer and use it in GitHub Desktop.
Save majeedraza1/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