close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How to connect an existing PowerStore to a new Database

Thread began 2/05/2014 3:44 am by Lee | Last modified 2/05/2014 12:15 pm by Jason Byrnes | 401 views | 5 replies |

Lee

How to connect an existing PowerStore to a new Database

Because of a remote server failure my PowerStore database was lost - and my backups do not restore it. All of my html files are intact, so I would like to set up a new MySQL datablase and connect the files to it. Where can I find instructions on how to make the connection?

Sign in to reply to this post

Jared Lui

Hi Lee,

I created a dummy database awhile back filled with data that I use temporarily to test and demo new stores as I build them so I have to essentially do what your talking about a lot.

Find the "Connections" directory in your site and the file called "PowerStoreConnection.php"

Then edit the follow details as needed as they correspond to your new database:
$hostname_PowerStoreConnection = "localhost";
$database_PowerStoreConnection = "xxxxxx";
$username_PowerStoreConnection = "xxxxxx";
$password_PowerStoreConnection = "xxxxxx";

That should do the trick. The other option is to simply give the new database the same name and login info when you create it.

Hope this is what you wanted.

Sign in to reply to this post

Lee

Thanks, Jared, for the quick response. The connection to the new database worked great.

But, the new database is a bare cupboard. It does not have the tables needed to continue.

Can you suggest how to regenerate the typical PowerStore database structure so that I can populate it?

Sign in to reply to this post

Jared Lui

I'm sure there's a better way and maybe Jason or Ray will chime in and correct me. But what I would do off hand is create a temp folder on your server (name it DELETE ME or something you'll know to get rid of when your done) and then copy all of your powerstore files (from your original zip) into it and run the install again. This will create the tables in the DB for you. Then simply delete that folder. The data won't be there of course but you'll have the table and structure.

Sign in to reply to this post

Lee

Thanks, again. We'll give this a try and see how it looks.

Sign in to reply to this post

Jason ByrnesWebAssist

Jared's suggestion of running the install script to create the database is the correct way to go, the install script will create the database and setup the supper admin user.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...