DONATE:How to import with mysqldump

From Openitware
Jump to: navigation, search
Place the donate_Create_Insert.sql,Donate_Create_DB_And_User.sql, and Donate_Create_Tables.sql files in the directory
\xampp\mysql\bin
Open a new cmd window and navigate to this folder
F:\xampp\mysql\bin
Type the following commands in myswl to lead the files. Note that the files must be loaded in the following order

SOURCE Donate_Create_DB_And_User.sql SOURCE Donate_Create_Tables.sql SOURCE Donate_Create_Insert.sql

Login to mysql using the mysql -u root -p command
check the Mysql database
mysql> show tables;

If it works, these tables should be present

Tables_in_donate
donation
donor
event
individual
organization

5 rows in set (0.03 sec)