Skip to content

Instantly share code, notes, and snippets.

@anugrahbsoe

anugrahbsoe/importdb .sql

Created March 1, 2017 08:00
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 anugrahbsoe/82f28a33dc0cec79352e38a66618e105 to your computer and use it in GitHub Desktop.
Save anugrahbsoe/82f28a33dc0cec79352e38a66618e105 to your computer and use it in GitHub Desktop.
Download ZIP
cara import big data on mysql
Raw
importdb .sql
BIG DUMP
Download the latest version of Big Dump http://www.ozerov.de/bigdump.zip
Open up bigdump.php and configure: Server, database name, username, password, and the file name.
Upload both your SQL file and bigdump.php to your server
Browse to bigdump.php and click import
MANUAL
mysql -u database_user_name -p -D database_name < complete_file_path_with_file_name_and_extension
Here :
u stands for User
p stands for Password
D stands for Database
---DON'T FORGET TO ADD < SIGN AFTER DATABASE NAME---
Complete file path with name and extension can be like
c:\folder_name\"folder name"\sql_file.sql
---IF YOUR FOLDER AND FILE NAME CONTAINS SPACE THAN BIND THEM USING DOUBLE QUOTE---
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment