We have a hosted Miva 9 storefront. What type of database is this built on and do we have permission to access the database with the hosted plan?
Announcement
Collapse
No announcement yet.
Miva 9 database access
Collapse
X
-
Re: Miva 9 database access
Yes you have full access to the database. Miva is built on a MySQL database. You should have a website control panel (most likely PLESK) where you can use PHPMyAdmin to view the database.
The only limitation of a shared hosted plan (vs a dedicated server) is you don't have SSH access to the server.
-
Re: Miva 9 database access
Originally posted by tleah1 View PostWe have a hosted Miva 9 storefront. What type of database is this built on and do we have permission to access the database with the hosted plan?
HOWEVER, unless you are very familiar with the Merchant data relationships, its not advisable to manually change data.Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
Comment
-
Re: Miva 9 database access
Thanks! I am not planning on changing any of the data, I just want to be able to read some of the data directly from the database. Where is the information about how to get to phpMyAdmin or look at the database? I do not see this in the main Miva control panel (admin.mvc) or on the Hosting Information Sheet we got after signing up, but maybe I am missing something.
Comment
-
Re: Miva 9 database access
If you are hosted with us, which sounds like you are, the link should be in the hosting pdf you got when you signed up.
However you can get to it by adding :8443 to the end of your domain:
https://www.domain.com:8443
This should redirect you to your PLESK control panel.
Comment
-
Re: Miva 9 database access
Yes but I would strongly recommend against it. If you have a php file directly connecting to the database, that means you need your database username/password (unencrypted) saved in the php file. This is a bad security practice because if your FTP credentials got compromised, someone could get full access to your database. This will also get you in trouble with PCI.
Miva has a suite of tools available which allow you to import and export any data from Miva without directly connecting to the database. This is going to be a much safer and secure option. Contact our sales team if you are interested in learning some more about whats available.
Comment
-
I believe Tool Belt has the ability to do MySQL queries (which would be the easiest). You could also do it by creating a module and using either the Miva API calls or your own to do queries, but that's not an 'easy' option.
We have a DB "Reader" module if you just want to look at the databases and see format and values. Contact me off list if this is all you need. (bruce a_t phosphormedia.com)Bruce Golub
Phosphor Media - "Your Success is our Business"
Improve Your Customer Service | Get MORE Customers | Edit CSS/Javascript/HTML Easily | Make Your Site Faster | Get Indexed by Google | Free Modules | Follow Us on Facebook
phosphormedia.com
Comment
-
Correct tool-belt allows to run non-destructive queries on the database.Andreas Toman
PCINET, LLC
Miva Merchant Design, Development, Integration & Support
We built over 200 Miva Merchant stores!
Miva shopping cart design & integration service and see our Portfolio!
e-mail: [email protected]
web: www.pcinet.com
LinkedIn: Andreas Toman
phone: (786) 250-2056 (Miami, FL)
Comment
Comment