Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save thanhn1012/a4923cd308b0fd263933f3906a5e8798 to your computer and use it in GitHub Desktop.
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
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"`
@thanhn1012
Copy link
Author

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"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment