PDA

View Full Version : setting up PowerCMS Importing database


admin140217
07-31-2009, 06:57 PM
I know I'm just going to feel not so smart after this question but I don't know much if anything about PHP or MySQL.

I'm setting up PowerCMS locally because I haven't purchased hosting for what I am doing. I'm following http://assets.webassist.com/how-tos/importing_sql.pdf to set up the database.

My not so intellegent question is, am I supposed to create a new database first and then paste the .sql into the SQL tab of PhpMyAdmin. If I don't I get an error after pressing GO.

If I do need to create a new database, am I supposed to name it CMS or anything, what are the variables I should set when creating the new database with PhpMyAdmin?

Be easy with me, remember I don't know much if anything about MySQL and PHP but will learn.

Thanks

John Langer
08-02-2009, 07:46 AM
Yes, create your database first, it doesn't matter what you call it, and then paste the database code into the SQL tab.

After that don't forget to fill in the relevant fields in the localhost.php file with your database name, username, and password.

Importantly, when you finally upload to your server, you will most likely have a new database name as supplied by your host, so don't forget to change the localhost.php file to the new database details.

admin140217
08-02-2009, 06:31 PM
John,

That helps greatly, I appreciate your help. These things tend to throw me off a little when I'm second guessing myself.

admin140217
08-03-2009, 07:04 AM
Working perfectly on the local side now John, thanks for the help.

John Langer
08-03-2009, 07:14 AM
Marvellous :)