MivaSQL and MySQL

[Midrangeman14]

Hello,

I was thinking of converting from MivaSQL to MySQL because an add-on I purchased doesn't work unless MySQL databases are running.

My question is if I convert, will I import/update my products in the same manner? Will there be a table in the database that has all of this information that I can edit? I have read the posts on the forum, and they point to this being something my host would do for me. Is this true? Jumpline in my host.

I would hate to migrate, and somehow lose all of my info, or functionality. The big difference is speed am I correct? Are there any other advantages?

Sorry for the 20 questions..

[ILoveHostasaurus]

Re: MivaSQL and MySQL

Conversion will replicate all the data from every mivasql database into an equivalent mysql database table, then you just point the store at the mysql database instead of the mivasql databases and you're done; no loss of data, no changes, etc. only now you can use that module you wanted to use. Typically easiest to have your host do the conversion as most have done a lot of them and they can be tricky sometimes.

[Eric]

Re: MivaSQL and MySQL

Hi

The MySQL is also required for PA-DSS.

We do the conversion free for our customers and nearly every single store has been converted to MySQL.

[koala]

Re: MivaSQL and MySQL

If you have a Miva savvy host they will be able to do this for you and make it a pain-free process. It's definitely very important to move to MySQL

[Midrangeman14]

Re: MivaSQL and MySQL

Wow thanks guys! I guess I will contact jumpline and have them complete the task.

[Midrangeman14]

Re: MivaSQL and MySQL

Hum...Looks like they won't help me. Something I should try on my own? I have a very limited knowledge of databases. Could I pay Miva to do this?

Thanks again.

[koala]

Re: MivaSQL and MySQL

I truly do not mean to sound rude but if that was their response I believe it is time to find a new host. There are so many good ones here which are helpful and active. I'm sure everyone has their favourites-- we're with Morditech and Eric has always been great for us.

Believe me, the sooner you're with a Miva savvy host the better. We used to be with a Canadian company called Webserve and they were absolutely horrendous to deal with, and all of their tech. support was outsourced anyway.

It seems like the recurring thing with the good hosts is you always get a real, live person who is actually located on this continent, who seems to have a vested interest in actually helping you!

[Midrangeman14]

Re: MivaSQL and MySQL

Koala, you do have a point, but at a very bad time! My bill is do in a week, so I would have to scramble to get a new host..errgg. Guess I should have looked into this sooner!

Jumpline's tech support has been okay. Very quick responses from Americans, but I guess the fact still remains.

Thanks for the help.

[koala]

Re: MivaSQL and MySQL

I know-- it's a really tough position. We walked away from something like 7 months in hosting fees with Webserve-- but it was totally worth it (and no, they wouldn't refund any of it, even though when we signed up with them they offered a Miva service which they subsequently could not deliver on).

[Midrangeman14]

Re: MivaSQL and MySQL

Same thing with Jumpline...We didn't get updates for a long time because they had sold us a bogus license. Wish me luck!

[d_host]

Re: MivaSQL and MySQL

A week is more than enough time to switch hosts. Even if your current host has a very long DNS timeouts (ie: 48 hours or so) that is still more than enough time to make the switch, and the few good Miva hosts out there can all move your site for free, with zero downtime in most cases.

[ILoveHostasaurus]

Re: MivaSQL and MySQL

Hum...Looks like they won't help me. Something I should try on my own? I have a very limited knowledge of databases. Could I pay Miva to do this?

Thanks again.

If you wanted to try it, you could attempt the conversion yourself. Here's what actually occurs and why you could attempt it with no real risk:

1) First step, download the diag6.mvc file from:

https://support.mivamerchant.com/sup...itemid=1&nav=0

Upload that to your site, access it at www.domain.com/diag6.mvc and click the Installed Database Libraries link. What we're looking for is MySQL database support; if that's not available then you're stuck, there won't be a way to do the conversion. If MySQL support is there, continue. Delete the file either way, you're done with it.

2) Create a database in your hosting control panel with them; hopefully you can choose name, username and password but either way as long as you know those values you'll be fine.

3) You're going to need the Miva mysql conversion script; it can be downloaded from:

https://support.mivamerchant.com/sup...temid=51&nav=0

Now, if you feel like doing this part yourself, or for security of the mysql info, you're also going to need the Miva script compiler installed on your computer; it's free from http://www.mivamerchant.com/products/compiler/. What has to happen at this step is you add your database info that you created in step 2 into the file, then compile it (create an executable). If you didn't want to go through the hassle of this step, I'd be happy to built a conversion script and compile it for you and send it to you, but you'd have to send me the database info to use, so that's where the security issue would arise.

4) With a conversion script ready to go, upload that to your site same as you did with the diag6.mvc script.

5) Access it from a web browser and if there are no issues, it will go through every mivasql database and load the data into the MySQL database you prepared. Remember, no risk to your site a this point as you're just making a copy of the data.

6) If the conversion reached the end with an "OK" afterward, it was able to successfully load all the data into the mysql database. If it didn't, probably best to not go forward with the conversion as it really will require a hosts help.

7) Assuming it worked, download the file merchdb.dat from your site's mivadata directory, save it on your computer somewhere safe. It will have the contents something like the following:

mivasql|/Merchant5/mivamerchant.dbf|||

With that file safely tucked away, create a new text file with the following:

mysql|DBNAME@localhost|DBUSER|DBPASS|

You'll replace DBNAME with the database name you created, and the DBUSER and DBPASS with the database username and password you created.

Here's the first risky part to your site; upload this one over top of the merchdb.dat on the site. If everything works, your site is now running off mysql which you can confirm in the admin area. If your site is down, record whatever error displays and put that safe copy of the merchdb.dat you took earlier back in place on the server to get it back up and running on mivasql.

[Siamese-Dream.Com]

Re: MivaSQL and MySQL

Same thing with Jumpline...We didn't get updates for a long time because they had sold us a bogus license.

WWWHHHAAATTT???

Get rid of those clowns now!!! Any decent Miva partner hosting company on this forum will get you up and running in a day or two. You won't regret it.

For instance, I had a problem on one of my sites with a corrupted file that was preventing people from checkout. David from Hostasaurus replied to my ticket and fixed the problem in about five minutes.

That is why you pay a few dollars more for the hosting companies that contribute their help to this forum.

[Rick Wilson]

Re: MivaSQL and MySQL

You can pay us to do it, we charge $149 to do it for you, however before you do that, I would strongly encourage you to consider everything mentioned above.

I'm not sure what % of your income comes from your website, but it's likely much higher than Zero. I wouldn't trust a percentage of my income to someone who doesn't take my business seriously.

[Siamese-Dream.Com]

Re: MivaSQL and MySQL

I wouldn't trust a percentage of my income to someone who doesn't take my business seriously.

On that subject, isn't there a list on the Miva site of "official" partner hosting companies? I thought I remember seeing one sometime, but it could just be old age kicking in again...