I import data into MySQL over and over again. Always from .sql scripts. I have tried over and over to come up with a script that will
- Ask for a database name
- Sign into MySQL
- Drop the Database named in step 1
- Create a new database as named in step 1
- Import the file I right-clicked on (like source /home/me/Desktop/database.sql)
Any help would be appreciated.