Setting up local project/database

How to import and export database using XAMPP and phpMyAdmin

You can easily create MySQL databases in your localhost.

If you don't have a server or you want test/configure build in local system. You can install XAMP, XAMP is a free and open source 
cross-platform web server solution stack package.

1) Start MySQL using XAMPP control panel.
2) Open your web browser and navigate to phpMyAdmin (http://localhost/phpmyadmin/).
3) Click the database tab. Enter the 'database name' and click 'create'.
4) Click the 'import' tab and browse to your database and click 'GO'.
5) You will get success message if successfully imported your database.

Exporting a database to a sql file click on the export tab and follow directions.

Thank you InsiteFX - that was a big help.

Is there anything different that needs to be added to database.php if working locally?

At present I have this...

Code:

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'acctest_myhomest';
$db['default']['password'] = 'Z6JxVJa+u_.$';
$db['default']['database'] = 'acctest_myhomestories';
$db['default']['dbdriver'] = 'mysql';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = FALSE;
$db['default']['db_debug'] = FALSE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;