Duplicate the MYSQL Database
Our initial database is named drupal_live
Dump out the database as sql.
cd ~
mysqldump -u root -pPASSWORD drupal_live > drupal_live.sql
In phpMyAdmin create database drupal_dev. We can either grant all privileges to our new database to a user of the old database or generate a new user specifically and grant them the required privileges.
Then import the dump into the new database.
mysql -u root -pPASSWORD drupal_dev < drupal_live.sql
Duplicate the Drupal Installation Files