MivaSQL to MySQL converter for MM5

[James Harrell]

Re: MivaSQL to MySQL converter for MM5

from a mysql command line: grant all on miva2my.* to 'miva2my'@'localhost' identified by 'miva2my'

[Gilbert]

Re: MivaSQL to MySQL converter for MM5

James thanks.

I am getting this error though

#1142 - GRANT command denied to user 'miva2my'@'localhost' for table 'miva2my'

[d_host]

Re: MivaSQL to MySQL converter for MM5

You will need to contact your host to run this command for you - it doesn't look like you have permissions to use the GRANT command using your mySQL account.

[Gilbert]

Re: MivaSQL to MySQL converter for MM5

Yes indeed many thanks. Got it !

Your SQL query has been executed successfully (Query took 0.0003 sec)
SQL query: GRANT ALL ON miva2my . * TO 'miva2my'@'localhost' IDENTIFIED BY 'miva2my';

However when I attempt to load the script from the browser I am back to the initial error

Opening mivasql... OK.
Opening mysql... OOPS, BAILING!: Cannot open mysql:miva2my@localhost

[nixusr]

Re: MivaSQL to MySQL converter for MM5

James,

Thanks for the clarification, I will be sure to follow your suggestion once I actually try a conversion.

Hi Dave,

Glad to hear it was relatively quick for a small store. I would expect stores with bloated affsess and baskets databases to take the longest, so it may be prudent to pack and clean those up for active stores. Also stores with thousands of products would probably take a bit longer.

Nixusr, the instructions were copied straight out of the script - so it's meant to imply "edit the configuration items at the top of the script". This means setting your mysql username, database and password before compiling the script.

Best,
James

[mlouis]

Re: MivaSQL to MySQL converter for MM5

Is MySQL faster than MivaSQL?
I'm having trouble with my Miva site running slow. Every click take at least 5 seconds. Sometimes longer.
I'm trying to pin down the cause.
I set it up using MivaSQL. Is MySQL any faster?

[ILoveHostasaurus]

Re: MivaSQL to MySQL converter for MM5

Is MySQL faster than MivaSQL?
I'm having trouble with my Miva site running slow. Every click take at least 5 seconds. Sometimes longer.
I'm trying to pin down the cause.
I set it up using MivaSQL. Is MySQL any faster?

Yes it is, but on a fast server you generally won't notice the difference unless you exceed several thousand products; on a fast server with a low number of products you won't see a difference. Where MySQL really excels over mivasql is in scalability.

5 second page loads can be caused by a variety of reasons; do you have a lot of add-on modules or customization or has it always been slow? If always slow, typically it's a server issue, but I have seen customers load a store down with huge numbers of mods to make a site slow even on a very fast server.

[wcw]

Re: MivaSQL to MySQL converter for MM5

Is MySQL faster than MivaSQL?
I'm having trouble with my Miva site running slow. Every click take at least 5 seconds. Sometimes longer.
I'm trying to pin down the cause.
I set it up using MivaSQL. Is MySQL any faster?

MySQL is faster in very large stores. That said, you have MivaSQL. How often do you pack the databases under utilities? How often do you delete expired baskets? Those are maintenance functions that should be done at least once a week with a MivaSQL store. How many 3rd party modules do you load on each page? Are you using modules which count the pages and provide a navigation for the customer to jump to a certain page number? Some modules are more processor intensive than others. How many products do you have? Who is your host? What is the url to your store? This discussion should be in a different thread as it is only marginally related to the converter module.

[mlouis]

Re: MivaSQL to MySQL converter for MM5

It doesn't sound like MivaSQL is my problem. I have a little less than a thousand products.
The site is a basic install. No mods or customization. Not even live yet.

I don't want to hijack this thread. Time to go argue with my provider.
Thanks for the info.

[nixusr]

Re: MivaSQL to MySQL converter for MM5

I finally got to use this script for mm5 project. Everything went well until the required edit of the 'merchdb.dat' file.

After replacing the connection string with my DB details such as: mysql|mysql_username@mysql_database|mysql_username |mysql_password|

I get the following error when accessing Miva:
MIVA Merchant has not been initialized. Please use the MIVA Merchant Setup script to initialize the required data files.

Can I use something like:
mysql|mysql_username@mydomainsip|mysql_username|my sql_password|

Not sure why this is failing even though the script connected and converted just fine.

[nixusr]

Re: MivaSQL to MySQL converter for MM5

After some thought, I believe my server is not using the most recent mysql connector for empressa. Could this be my issue perhaps?

[James Harrell]

Re: MivaSQL to MySQL converter for MM5

I think the connection string in the readme may have a typo - somewhere in there you have to have a mysql server name and database name. Try this:

mysql|mysql_database@mysql_server_ip_or_localhost| mysql_username|my sql_password|

Anyone have this readily accessible? I'm at home...

james

[d_host]

Re: MivaSQL to MySQL converter for MM5

You got that right, James.

For mySQL server name, you may have to contact the host though to see how they have things set up. Sometimes you can use localhost, sometimes localhost.localdomain, sometimes 127.0.0.1

[nixusr]

Re: MivaSQL to MySQL converter for MM5

Thanks for the quick response you guys! I'm assuming that you are refering to the connection string with in the 'mivadata/merchdb.dat' file...or the actual conversion script?

The IP of the server is fine to use but still getting an error when trying to get Miva to use MySQL.

[nixusr]

Re: MivaSQL to MySQL converter for MM5

One more thing I should ask is, once the conversion script finishes running, will it give a 'success type' message or while it just stop when done?