shankar-bavan/import-mysql-database-windows.md

Last active December 25, 2022 14:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/shankar-bavan/9fd19c65e55245cf48344ebe59c636c9.js"></script>
Save shankar-bavan/9fd19c65e55245cf48344ebe59c636c9 to your computer and use it in GitHub Desktop.

import a mysql database using cmd prompt in XAMPP for Windows

Raw

    Locate the mysql executable (C:\Programs\xampp\mysql\bin\mysql.exe )
Copy the path in the clipboard as you will need it in the next step.
To import a database we just need to execute the following command with the following arguments:

mysql -u {DATABASE_USERNAME} -p {DATABASE_NAME} < "path/to/file/database-to-import.sql"