Last active
January 20, 2021 11:16
-
-
Save ErMandeep/8afdbc4db75ffc7665d2866eb479e7fb to your computer and use it in GitHub Desktop.
how to import large sql file in xamp by a command
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| there is two command | |
| before run command increase the size of | |
| max_allowed_packet to 1072731894 | |
| or | |
| SET GLOBAL max_allowed_packet=1072731894 | |
| for linux | |
| ========= | |
| mysql -uroot -p1 cwebco_herdispenser_vxy_actual < mastercontrol_new.sql | |
| ========== | |
| ./mysql -u root -p cwebco_herdispenser_vxy_actual < cwebco_herdispenser_vxy_actual.sql | |
| /Applications/XAMPP/xamppfiles/bin/mysql -u root -p cwebco_herdispenser_vxy_actual < cwebco_herdispenser_vxy_actual.sql | |
| press enter | |
| if not password for xamp user again press enter | |
| Done | |
press enter
if not password for xamp user again press enter
Done
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
there is two command
before run command increase the size of
max_allowed_packet to 1072731894or
SET GLOBAL max_allowed_packet=1072731894./mysql -u root -p cwebco_herdispenser_vxy_actual < cwebco_herdispenser_vxy_actual.sql
/Applications/XAMPP/xamppfiles/bin/mysql -u root -p cwebco_herdispenser_vxy_actual < cwebco_herdispenser_vxy_actual.sql