CiviCRM Community Forums (archive)

If you want to reset ALL data - you can load the following two SQL scripts:

civicrm/sql/civicrm_41.mysql
civicrm/sql/civicrm_data.mysql (if you don't need "sample" data) OR civicrm_generated.mysql (if you want the sample data)

Loading these files WILL destroy any existing contacts, profiles, contribution pages etc. - so don't take this approach if that's NOT what you want to do.

You might want to elaborate a bit more on what you mean by "loading data"

If you mean civicrm sample data, check dave's forum post above. You can also reset the database as dave describes above. Loading your own data is a different ball game, and u need to use the import tool and/or write your own custom sql load scripts to match the civicrm schema

lobo
 

Two potential ways exist:

1. From the command line:

mysql -uYourDBUser -pYourDBPassword YourDBName < civicrm_41.mysql
mysql -uYourDBUser -pYourDBPassword YourDBName < civicrm_data.mysql

OR

2. You can use a program like PMA, check:

http://www.phpmyadmin.net/home_page/index.php

lobo