close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


Local Install copied to Live Server

Thread began 2/25/2010 4:36 am by jon392819 | Last modified 3/01/2010 10:50 am by Jason Byrnes | 1979 views | 15 replies |


Local Install copied to Live Server


Is it possible to copy a local server install of powerstore 3 to a live sever. I am trying to get around the mysql user privilege problem with my hosting company. Its such a simple solution I am expecting a big NO, but no harm in asking!



Sign in to reply to this post


Yes, I have just managed it after four days and endless attempts of installs. It is so simple to achieve, but nowhere on the WebAssist website does it mention the ability to do so.

So, install it on your local testing server; look in the wa_settings table of the database and there you will see something like:

Root URL: sitename/

Local Root: /username/sitename/

Remote Root: /username/sitename/

On the basis the site is sitting at the top level of the live domain, you need to change the above to:

Root URL:

Local Root: /

Remote Root: /

You might also need to change the Google API Key

I have uploaded my local files to my remote server via DW, and literally within the last hour dumped my local testing server and uploaded it to the remote server, then changed the above settings... BINGO!

If it wasn't for Dani on here, I wouldn't have known to do that. I just had to ask the right question in order for that info to materialise which is a shame.

So, there you go WebAssist team... I appreciate that this was built with the novice in mind, but there are a good deal of people on here who want to be able test first, and then upload. But without the above info, it becomes almost impossible to figure out and do that. It would be great to have this as part of the documentation instructions as I would've understood that straight away rather than go round in circles for days on end.


Sign in to reply to this post


Local to remote

Thanks so much for the quick reply. Thats super! My inital thought was how do I get around my hosting comanies reluctance to give the privilege required to the mysql user to run the install wizard. I didnt want to use another company as I'm otherwise very happy with them.

It took minutes to install locally here and now you have set the bar I will test and tweak here before uploading to remote.

I agree, the web assist documention is poor at times. However, this forum always seems to come up with the answers.

Thanks again.

Sign in to reply to this post

Office Guy-172461

Keep in mind that bypassing the installation program's check for create view privileges does not remove the need for them on the remote host.

The purpose of the check is to make sure you have everything on your host to insure that the store will run properly.

Sign in to reply to this post


Office Guy, I assume you are referring to the cURL and GD library checks etc that the first page does?

I must admit, I hadn't considered that, but, I knew my host caters for that. However, if a host doesn't have things like that installed, then they surely are a poor hosting service. I guess one way of being sure beforehand is to do the phpinfo check.

Sign in to reply to this post

Office Guy-172461

I was just pointing out that if any of the checks fail while running the installation program, it means that the host doesn't have what is required to run PS3 properly.

The only thing the installation program needs is PHP so it isn't an issue with getting around the install process. It is checking the requirements for PS3.

There seems to be an impression that it is a problem with getting the install program to run and that's not the problem. The create view privilege is needed for the coupon system, not the install program.

Sign in to reply to this post


Power Store 3 and customization!

I have been strugling with this whole concept of how Web Assist markets all these products
eg, Power Store 3, And the ability to customize using the web extensions. and Dreamweaver. Yes its easy to setup either at your ISP or local testing server, with a few tweaks for the local setup. My problem was I setup first at my ISP, Great worked fine.
Now I want to customize using DreamweaverCS4 and CSSMenu Writer or Ecart, and all the extensions that are designed for this application.
typically, you FTP your site to your local machine after setting up testing server, I use xaamp, Then I exported the MySql database from my ISP and imported it to local data base.
All is well, tables are all there, and I can connect to database, changing the connection.php for the local site, Also modified the wa_settings to reflect the local root name user and password. The problem starts when you try to view live in DW, or through browser, Also had added treexml.xml to replace current in CSS Menu home.
add added the other fixes that were show in the forum. You get all these errors, MySql, connections and on and on. So I have given up on trying to customize a site that was already setup at your ISP. and after reading this post, I may try this instead.
What did you do about the database at your ISP? did you export from your local MySql server? to your ISP MySql, using phpadmin?

I wish Web Assist would draft a procedure that details how to customize Power Store 3 using Dreamweaver along with the extensions. on using a remote site what problems you may run into.

They leave to all of us to work out these details, like everyone has done here.
And post many questions just trying to get it to work right!

Sign in to reply to this post


Thanks Office Guy & MRS. I was indeed just trying to bypass the install problem failing the privilege test. You make a good point.

Is it just the coupons that will fail to function without the correct mysql privilege?

Thanks again


Sign in to reply to this post

Jason ByrnesWebAssist

yes, the view is only used for coupons.

Here is the work flow I would suggest for installing PowerStore on the remote host and your local computer to make edits:

1) Upload the files to the remote host and run the installer.

2) After the installer has finished, set the privileges on the Connections/PowerStoreConnection.php file to read only. This step will prevent dreamweaver from overwriting the connection settings.

3) Create a new Dreamweaver site for PowerStore. On the testing server tab, configure it to use your local testing server.

Set the Remote Info section to use FTP to connect to the remote host and upload to the same directory you installed PowerStore to.

4) Extract the PowerStore files to the root of your Dreamweaver site, the run the installation wizard on your local computer.

You can now make changes in Dreamweaver, test them locally, then upload them to the live site.

Sign in to reply to this post


Thank you James. Can I confirm that Powerstore will function ok without the View privilege with the only exception been the coupons.

For future powerstore sites I will use 1 and 1.

Anyone know an Irish based hosting company that can fully support powerstore? I'm trying to keep things Irish, our great little nation is such a bad way I fear ever euro is needed at home!!! :)

Thanks again all for the time spent on the replies!


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





Ease of use


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...