Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerStore › Powerstore General / Announcements › database import issues

database import issues

Thread began 5/10/2016 6:16 am by thinkdolphin | Last modified 5/10/2016 5:15 pm by Ray Borduin | 673 views | 4 replies |

5/10/2016 6:16 am | #1 thinkdolphin

database import issues

I set up my store locally and exported the database. I have PS installed on my live server and I tried importing but it's not working. It's telling me the tables already exist. I've imported databases in the past with little issue so I'm frustrated that this isn't working.

Any suggestions on the easiest way to import the database? I really, really don't want to add all of these products again! TIA

5/10/2016 9:44 am | #2 Ray BorduinWebAssist

You should be able to export and import from phpmyadmin without issues. You can choose to drop the tables if they exist in the export script so that they will be completely overwritten.

Did this help? Tips are appreciated...

5/10/2016 10:42 am | #3 thinkdolphin

There is no advance option to select to overwrite existing tables. I wonder if I can delete the whole database and just import the local one?

5/10/2016 11:25 am | #4 Ray BorduinWebAssist

Yes you can do that.

Did this help? Tips are appreciated...

5/10/2016 12:26 pm | #5 thinkdolphin

Got it! And was able to login to admin! Thanks for all of your help!

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.