Forums | Mahara Community
Support
/
Need Help Mysql Database ?
05 January 2012, 15:54
i have looked at the Tutorial Video for Mysql Database but it does not show where the database is located in what folder so i can Import it thru PHP MyAdmin ??and the video did not show how the databse was added. [do you have a text install manual please?] or tell me where is the database located?
05 January 2012, 16:49
Hi Chris,
You need to create a blank database with preferably a user that is not root. The user needs to be able to create tables as well as all the other usual stuff.
You then look in the config.php file for something that looks like the following:
$cfg->dbtype = 'postgres8';
$cfg->dbhost = 'localhost';
$cfg->dbport = '';
$cfg->dbname = 'maharadev';
$cfg->dbuser = 'mahara';
$cfg->dbpass = 'putyourpasswordhere';
And change that to have the dbtype be "mysql5" and replace the credentials to be those for your new blank database.
The Mahara install script will connect to the database and helpfully build all the tables for you. You don't need to import them :)
https://wiki.mahara.org/index.php/System_Administrator%27s_Guide/Installing_Mahara has some instructions
Hope this helps,
Melissa