Transcript DatbaseToSQLScript

Exporting a database to a sql
script
1
Getting to the command-line in XAMPP. Go to All
Programs/XAMPP/XAMPP Control Panel. Click on
Shell.
2
Use the mysqldump command. I used the root user (u). I did not enter a password (-p), but it prompted
me for one. I named the database I wanted a script
for. I directed the results into a .sql file
mysqldump -u root -p classicmodels > c:\xampp\classicScript.sql
3
Prompted for password. Not much
seen here since results directed to file.
4
Right click on the C:\ icon to access the menu.
Mark (highlight), copy, and paste are under Edit.
5
In PHPMyAdmin, go to New on the left, enter a new
database name and click Create
6
Select new datadase on the left, go to the Import tab,
choose the sql script you made by clicking on Choose
File. Scroll down and click Go.
7
Result of script. Tables created. Data inserted.
8