You can copy a MySQL database to a website using a tool such as phpMyAdmin or by using the MySQL command line. Create a new target database, export the data from the source database and import it ...

If you are not so familiar with Drupal or you want to test some modules on localhost, this post will show you how to install Drupal using WAMP on Windows or localhost.