Created
July 13, 2023 14:09
-
-
Save thanhn1012/a4923cd308b0fd263933f3906a5e8798 to your computer and use it in GitHub Desktop.
Cách import file sql dữ liệu lớn vào mysql xampp
This file contains 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
| 1. Bật xampp | |
| 2. Chọn Shell để mở của số command | |
| 3. Run `mysql -u root -p db_name < "C:\folder_name\db_name.sql"` |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
mysqldump -h wwdjapan-prd-rds-dbcluster.cluster-ro-cjs2dzbewol4.ap-northeast-1.rds.amazonaws.com -u wwdjapan -p wwdjapan_com > wwdjp.sql
mysqldump -h wwdjapan-prd-rds-dbcluster.cluster-ro-cjs2dzbewol4.ap-northeast-1.rds.amazonaws.com -u wwdjapan -p wwdjapan_com > wwdjp.sql
mysqldump -h wwdjapan-prd-rds-dbcluster.cluster-ro-cjs2dzbewol4.ap-northeast-1.rds.amazonaws.com -u wwdjapan -p wwdjapan_com wp_posts --where="id < 3000" > wp_post.sql
mysqldump -h wwdjapan-prd-rds-dbcluster.cluster-ro-cjs2dzbewol4.ap-northeast-1.rds.amazonaws.com -u wwdjapan -p wwdjapan_com wp_postmeta --where="post_id < 3000" > wp_postmeta.sql
mysql -u root -p wwd < "C:\xampp2\wp_post.sql"
mysql -u root -p wwd < "C:\xampp2\wp_postmeta.sql"