Name: Import banyak sql file
Rating: 4.1 (2528 reviews)
Author: ekopriyanto

Import banyak sql file

Eko Priyanto - Feb 1 -

- Dev Community

Buka CMD

mysql -u root --password=""



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\prov\*.sql) do mysql -u root --password= lentera < "%f"



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kab\*.sql) do mysql -u root --password= lentera < "%f"



for %f in (G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kec\*.sql) do mysql -u root --password= lentera < "%f"

# untuk sub foldernya
for /r G:\IDEA\wilayah_boundaries-main\wilayah_boundaries-main\db\kel %f in (*.sql) do mysql -u root --password= lentera < "%f"