MivaSQL to MySQL converter for MM5

[James Harrell]

Hi folks,

The MivaSQL to MySQL converter has arrived!

See attached source (.mv) and compiled (.mvc) files. The compiled version can be used by those without a compiler, though the target mysql username, database and password are hardcoded. If you use the binary version, run the conversion, then change the database name, username and password before running online. Hardcoded values for target mysql db:
- database: miva2my@localhost
- username: miva2my
- password: miva2my

Instructions:
| How to convert Miva Merchant 5 from MivaSQL to MySQL:
| ---------------------------------------------------------
| 1) Edit the configuration section below. Provide your MySQL database, username
| and password.
|
| 2) Compile (http://www.mivamerchant.com/products/compiler/)
|
| 3) Set your MivaVM/Empresa timeout to zero.
|
| 4) Place the compiled script (mivasql2mysql.mvc) at the root of your httpdocs
| directory, and load it with a web browser. ex:
| http://www.yoursite.com/mivasql2mysql.mvc
|
| 5) Grab a cup of coffee.
|
| 6) Assuming all went well, all of your MivaSQL database table structures,
| indexes, and data have been transferred to MySQL. Now just change your
| mivadata/merchdb.dat file to run your store from the MySQL database:
| - copy merchdb.dat to merchdb.mivasql.dat as a backup
| - merchdb.dat probable looks like this: mivasql|mivamerchant.dbf|||
| - edit merchdb.dat, replace the connection string with:
| mysql|mysql_username@mysql_database|mysql_username |mysql_password|


Enjoy!
James

[ILoveHostasaurus]

The timeout to zero implies it will be doing the conversion in one large step? Is there a rough idea of how long it takes per X products since the web server timeout will likely also have to be raised enough to let it not close the connection and terminate emprsea.

[James Harrell]

Hi Dave,

Yes, the entire conversion runs in one page load. Please report back on your conversion time observations. ;)

If your Empresa timeout is zero, the Miva Empresa script will continue to run in the background even after 5 minutes (typical web browser timeout), and on some servers even after 10 minutes (typical web server timeout). I've seen scripts run much longer - it just depends if your server will actually kill the CGI program or if it will just disconnect from it and let it keep running.

Best,
James

[ids]

Hi folks,

The MivaSQL to MySQL converter has arrived!

See attached source (.mv) and compiled (.mvc) files. The compiled version can be used by those without a compiler, though the target mysql username, database and password are hardcoded. If you use the binary version, run the conversion, then change the database name, username and password before running online. Hardcoded values for target mysql db:
- database: miva2my@localhost
- username: miva2my
- password: miva2my

Instructions:
| How to convert Miva Merchant 5 from MivaSQL to MySQL:
| ---------------------------------------------------------
| 1) Edit the configuration section below. Provide your MySQL database, username
| and password.
|
| 2) Compile (http://www.mivamerchant.com/products/compiler/)
|
| 3) Set your MivaVM/Empresa timeout to zero.
|
| 4) Place the compiled script (mivasql2mysql.mvc) at the root of your httpdocs
| directory, and load it with a web browser. ex:
| http://www.yoursite.com/mivasql2mysql.mvc
|
| 5) Grab a cup of coffee.
|
| 6) Assuming all went well, all of your MivaSQL database table structures,
| indexes, and data have been transferred to MySQL. Now just change your
| mivadata/merchdb.dat file to run your store from the MySQL database:
| - copy merchdb.dat to merchdb.mivasql.dat as a backup
| - merchdb.dat probable looks like this: mivasql|mivamerchant.dbf|||
| - edit merchdb.dat, replace the connection string with:
| mysql|mysql_username@mysql_database|mysql_username |mysql_password|


Enjoy!
James

hmmm....

Obviously I haven't done this yet. I probably won't need to so far. But, this doesn't seem like an operation just anyone should do. Who is the target for actually running the conversion? Just mentioning, to change the timeout; If an end user had access and could do it, and did it wrong, what would the implication be on that particular server? How would all the sites on that server be protected? Is there any danger of overloading the server?

Seems like the best advise would be for endusers get their host involved. But, that's why I'm asking.

[James Harrell]

I would say the target audience of this utility would be someone technical enough to understand how to set a timeout, compile, set up mysql databases, database permissions, etc. I almost put unix commands (cp, vi, etc) in the instructions. :) End users should definitely get in touch with their host or developer.

I also recommend running this offline - perhaps on a development server or even Miva Mia, though Mia (and MySQL on a Win32 desktop) is notoriously slow.

Setting a timeout to zero doesn't have any security implication - but it could allow a rogue Miva Script to bog the server down for a long time significantly slowing performance.

Nothing from this conversion takes effect in the live store until step 6. So if you botch a conversion and don't change your Miva Merchant connection string, you're still running on the MivaSQL database.

Best,
James

[Gilbert]

Just read, not technical at all. However do you recommend doing it ... in other word are you "dumping" MivaSQL ?

[James Harrell]

Hi Gilbert,

No, we are not planning to discontinue MivaSQL. Many folks have asked for a way to change from MivaSQL to MySQL after running their store for a period of time. This utility simply provides a means of doing so.

Best,
James

[Eric]

James,

This is great news and a big help for large stores that were setup on mivaSQL on mm5. MivaSQL is great for smaller stores but very large stores with a large number of products run best on the MySQL backend.

James,

Any news on the delete shopping baskets bug while inventory is enabled when running MySQL not mivaSQL. Their is a deadlock issue on a table lock that marianne was working on we have a large number of stores affected by this but we have customized some indexes to get around it for them until the patch comes out. I can PM you if you cant read the pm's back and forth with marianne.

Thanks!
Eric

[James Harrell]

I think I have PM disabled - please email me (jharrell) a detailed description of the issue, this is the first I've heard of it.

Best,
James

[Eric]

James,

No problem I emailed it to you

Thanks!
Eric

[Hostasaurus]

Just ran this, but it was a small store so took about 2s.

Now I have a whole directory still full of .dbf and .mvx files though, how do we clean those up? Can Merchant5/ be emptied (excluding third party mod directories)?

Jen

[nixusr]

I'm not quite sure what was meant by "1) Edit the configuration section below." There was nothing specifically just below that line. Are you refering to step 6?

Thanks


Hi folks,

The MivaSQL to MySQL converter has arrived!

See attached source (.mv) and compiled (.mvc) files. The compiled version can be used by those without a compiler, though the target mysql username, database and password are hardcoded. If you use the binary version, run the conversion, then change the database name, username and password before running online. Hardcoded values for target mysql db:
- database: miva2my@localhost
- username: miva2my
- password: miva2my

Instructions:
| How to convert Miva Merchant 5 from MivaSQL to MySQL:
| ---------------------------------------------------------
| 1) Edit the configuration section below. Provide your MySQL database, username
| and password.
|
| 2) Compile (http://www.mivamerchant.com/products/compiler/)
|
| 3) Set your MivaVM/Empresa timeout to zero.
|
| 4) Place the compiled script (mivasql2mysql.mvc) at the root of your httpdocs
| directory, and load it with a web browser. ex:
| http://www.yoursite.com/mivasql2mysql.mvc
|
| 5) Grab a cup of coffee.
|
| 6) Assuming all went well, all of your MivaSQL database table structures,
| indexes, and data have been transferred to MySQL. Now just change your
| mivadata/merchdb.dat file to run your store from the MySQL database:
| - copy merchdb.dat to merchdb.mivasql.dat as a backup
| - merchdb.dat probable looks like this: mivasql|mivamerchant.dbf|||
| - edit merchdb.dat, replace the connection string with:
| mysql|mysql_username@mysql_database|mysql_username |mysql_password|


Enjoy!
James

[James Harrell]

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

[James Harrell]

As far as the mivasql databases in place, yes, once you transfer, you can remove them. IF the 3rd party databases were in MivaSQL (rather than 4x style XBASE3), they were synchronized to MySQL as well. They would only be transferred IF the developer was using the same MivaSQL "global merchdb.dat" connection (ex: all SQL queries were against the database "Merchant"). Note that this is more or less a generic mivasql to MySQL transfer utility - the only thing that makes it merchant specific is that it reads merchdb.dat to get your mivasql connection information.

So IF they made their own mivasql or XBASE3 databases, the metadata for these tables wouldn't have been in mivamerchant.dbf (from merchdb.dat). Therefore they would not have been synchronized to MySQL and you must leave those dbf/dbt/mvx files in place. Contact your developers for specifics!

I would also leave the directory structures in place. Some modules export to the store directory, vendor modules probably export to their own data directories, etc.

Good luck!
James

[Gilbert]

Hello James

I have run into trouble while using the attached compiled (.mvc) file with the Hard-coded

- database: miva2my@localhost
- username: miva2my
- password: miva2my

I am getting this error

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

Though I created from within Plesk the database as follow

- database: miva2my
- username: miva2my
- password: miva2my

(@localhost is not allowed + I had to use a workaround as Plesk does not allow the user-name and password to be the same. I have created the database under a different user-name and then change it to miva2my)

Best

[James Harrell]

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

[Gilbert]

James thanks.

I am getting this error though

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

[dotCOM_host]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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

[dotCOM_host]

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]

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]

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?

[nixusr]

The connection string may not be the issue anymore. After I made the change and tried to access the merchant storefront instead of the admin, I got a more descriptive message that states...
Description:
/lib/i686/libc.so.6: version `GLIBC_2.3' not found (required by /usr/local/mivavm/lib/databases/mysql.so)

So I will need to inspect the box for this required library file.

[brucejbrown]

When the conversion completes, does it issue a message? When I ran it, it went through 29 steps, the last of which was converting basketoptions.dbf. All of them said OK.

I tried changing merchdb.dat. The instructions look pretty simple, but none of the variations I tried worked.

The instructions say to change the string to:
mysql|mysql_username@mysql_database|mysql_username |mysql_password|

(I'm not sure if the space between username and | is significant.)

So, let's say my database was called DB, username STORE and password STORE , I tried:
mysql|STORE@DB|STORE |STORE

When I tried to connect to the store, I got:

Error Code: MER-DBA-MYS-00001
Description: Unable to connect to database: Unknown MySQL server host 'DB' (1)
Other Information:

Obviously, the database is there otherwise the conversion program wouldn't have worked.

What am I missing?

Thanks,

Bruce

[ILoveHostasaurus]

The instructions say to change the string to:
mysql|mysql_username@mysql_database|mysql_username |mysql_password|

(I'm not sure if the space between username and | is significant.)

So, let's say my database was called DB, username STORE and password STORE , I tried:
mysql|STORE@DB|STORE |STORE

When I tried to connect to the store, I got:

Error Code: MER-DBA-MYS-00001
Description: Unable to connect to database: Unknown MySQL server host 'DB' (1)
Other Information:

Obviously, the database is there otherwise the conversion program wouldn't have worked.

What am I missing?

Thanks,

Bruce

Get rid of the space, that should not be there, unless your username actually contains a space, which I don't think mysql allows. The other issue is that "DB", your format is wrong, should be:

mysql|mysql_database@mysql_server|mysql_username|m ysql_password|

So you need to udpate the database@server portion and drop the space form after the username.

[brucejbrown]

I tried using the same values for database, username, and password as I had in the conversion code.

So, this time my string looked like:

mysql|DB@216.218.134.251|STORE|STORE|

To keep the example simple, I'm using DB as the mysql database, and STORE is the username and password.

I got to the admin.mvc page without a problem. When I tried to log in, I got:
Runtime error in lib/db.mvc @ [0000014e:0000002a]: lib/dbprim/users.mv: Line 148: MvOPENVIEW: mysql_stmt_prepare: Table 'DB.Users' doesn't exist

Sorry. But I don't understand how to resolve this.

As I said in my prior post, the conversion ended at step 29, but didn't give any message saying it was done (nor did it give any error messages). So, did the conversion fail and is that the reason I'm having troubles logging in or am I missing something else?

Thanks,

Bruce

[ILoveHostasaurus]

I tried using the same values for database, username, and password as I had in the conversion code.

So, this time my string looked like:

mysql|DB@216.218.134.251|STORE|STORE|

To keep the example simple, I'm using DB as the mysql database, and STORE is the username and password.

I got to the admin.mvc page without a problem. When I tried to log in, I got:
Runtime error in lib/db.mvc @ [0000014e:0000002a]: lib/dbprim/users.mv: Line 148: MvOPENVIEW: mysql_stmt_prepare: Table 'DB.Users' doesn't exist

Sorry. But I don't understand how to resolve this.

As I said in my prior post, the conversion ended at step 29, but didn't give any message saying it was done (nor did it give any error messages). So, did the conversion fail and is that the reason I'm having troubles logging in or am I missing something else?

Thanks,

Bruce

Sounds like the conversion failed; the Users table is where all the logins to the admin side of the store are held, so if that table is missing, the conversion didn't create it like it should have. I'd probably wipe out the tables in DB and start it over again, see if it completes next time.

[brucejbrown]

Yes, that was the problem. I deleted baskets, packed the store and re-ran the conversion utility. This time it went through 143 tables (instead of 29) and said "DONE!" when it completed.

Thanks for your help!

Bruce

[Gazungle]

Would you have to re-install any plugins after doing this ?

[ILoveHostasaurus]

Would you have to re-install any plugins after doing this ?

You don't.

[brucejbrown]

I ran the MivaSQL to mySQL converter. It completed without any errors and said "done" at the end. I also changed the merchdb.dat file.

I wasn't able to log into admin using https, but was able to get in using http. The Main admin page showed that it was running mysql. It had this error:
Runtime error in lib/db.mvc @ [00000145:0000002a]: lib/dbprm/store.mv: Line 233: MvOPENVIEW: mysql_stmt_bind_results: Using unsupported buffer type: 246 (parameter 27).

I'm running Redhat 5. I tested the conversion on a slightly older version of the store on a server runnning Redhat Linux ES 4 and it worked there.

Any ideas on what's causing this error or how to troubleshoot it?

Thanks,

Bruce

[ILoveHostasaurus]

I'm running Redhat 5. I tested the conversion on a slightly older version of the store on a server runnning Redhat Linux ES 4 and it worked there.

Any ideas on what's causing this error or how to troubleshoot it?

Thanks,

Bruce

RHEL 5 uses MySQL 5 which Merchant only theoretically runs on using the beta release version 2.0 MySQL connector but I think it actually doesn't run reliably with that connector so MySQL 4.1 is the only viable version at this point.

[dotCOM_host]

EDIT: David beat me to it. Yes, RHEL 5 will not work for you if you use mySQL 5. With or without the new beta connector. It appears to be still a little too buggy for production use. Switch to RHEL4 with mySQL 4.1.2x or see if you can install that older version of mySQL on your RHEL5 system (I haven't tried that route so I don't have first hand experience whether this will work).

[James Harrell]

Have you tried with the MySQL Beta connector v2.102 I released late last week? This should be stable on MySQL v5. Of course, still not advised for production use as it is BETA.

Regards,
James

[Gazungle]

Where can we can download the latest version ?

[brucejbrown]

We got changed back to mysql 4.1 but stayed on RHEL5. Everything seems to be working now. Just in the nick of time too. We converted on Saturday and we had our busiest day on Sunday. Thanks for your help.

[brucejbrown]

Nope. We'll wait for something that's ready for production.

[albunix]

Hello,

we compiled the mivasql2mysql.mvc script from source as we needed
to alter a few directives, namely the Mysql server + user/password ones.

Once we run the script we are given the following error. We are running
Mysql 4.0.27-log. Please advice with any solutions

-----------------------------------------------------------------------
mivasql2mysql running...


Opening mivasql... OK.
Opening mysql... OK.
Opening raw database OK.
Reading mivasql tables and converting...
Table: AdminSessions = File: adminsessions.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... OK.
Selecting and inserting... Runtime error in mivasql2mysql.mvc @ [00000000:00000d04]: mivasql2mysql.mv: Line 255: MvQUERY: mysql_real_query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server versio OOPS, BAILING!: :INSERT INTO AdminSessions SET session_id= ?, user_id= ?, lastupdate= ?, remoteaddr= ?

------------------------------------------------------------------------

[James Harrell]

Miva Merchant requires MySQL 4.1 and will not work properly on 4.0.

Best,
James

[albunix]

ahhh..i was very much hoping for such :)

I shall post upon success/failure in a while.

Thanks James.

[albunix]

James,

all good.

...just a snippet


Table: UserXStore = File: userxstore.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... OK.
Selecting and inserting... OK.
Creating indexes...
- Create Index: UserXStore_1:userxstore/1.mvx:store_id:0 OK.
- Create Index: UserXStore_2:userxstore/2.mvx:user_id:store_id:0 OK. OK. DONE!

Thanks, let's see how it'll work and how much the client will
like it.

[newguyintown]

This is an interesting thread and I appreciate all the information. Question,though, for someone new to the MivaSQL/MySQL scene - could I get feedback on the pro's and con's of each? I understand that the conversion is basically aimed at large stores with large inventory. What is meant by "large" - is there a size range (product-wise) that a store should begin considering the switch? The store I am updating (www.farmlandtractor.com (http://www.farmlandtractor.com)) has sat on a few hundred products for some years - just didn't have the know-how or time to dedicate to the site. Now that I am here, it is growing quickly. We currently have a couple thousand products and will continue to grow - lots of different parts on a tractor! Anyway, what benefits (aside from speed) will we see once a conversion is done? How big do we need to be to really benefit from it?

Thanks for your input - greatly appreciated!

[Ben @ eMediaSales]

Hello,

Certainly - MivaSQL is based on the original Miva xbase (dbf/mvx) "flat file" database structure. While certainly an improvement over the original xbase3 implementation, MivaSQL can suffer some of the same problems such as performance issues on large databases and on NFS based file systems, etc. But what I believe to be one of the most problematic drawbacks of MivaSQL is that you must use MivaScript to access and manipulate the data reliably.

MySQL, on the other hand is a very solid client-server RDBMS. It scales much better, and provides much improved performance as both load and database sizes increase. You can access MySQL data from almost any programming language and there are a LOT of utilites available such as phpMyAdmin for direct access to the data.

MySQL provides a lot of benefits - for example if you're running MivaSQL and you want to change your "starting order number", you must either understand Miva provisioning, know how to program mivascript, purchase a utility to do this for you, hire someone to help, etc. However, if you have MySQL and phpMyAdmin - just use a web browser to edit the store key database value for Orders. (ex: s01_StoreKeys)

A lot of stores by default were (and continue to be) installed as MivaSQL. As a store grows or as the store owner's need to access the data becomes important, a switch from MivaSQL to MySQL may be in order!

We have lots of other things to discuss with you for the growth of your online business. I have sent you a private message. Please respond to that in order to get the ideas on growing your business.

[perla ravi]

Hi,

I am trying to convert our store database from MIVASQL to MYSQL as your steps in the following link by using mivasql2mysql tool..

http://extranet.miva.com/forums/showthread.php?t=11078

while trying to convert i am getting following error, could you please help me regarding this error...

mivasql2mysql running...
--------------------------------------------------------------------------------
Opening mivasql... OK.
Opening mysql... OOPS, BAILING!: Cannot open mysql:root@localhost

I have installed MYSQL and MIVA Empresa also properly....


Please suggest me regarding this.....

Thanks & Regards,
P.L. RAVI KANTH

[mlouis]

I'm getting the:
Opening mivasql... OK.
Opening mysql... OOPS, BAILING!: Cannot open mysql:mivadb@localhostmessage.

I can connect from the bash command line just fine.
I have tried 'localhost', 'localhost.localdomain', '127.0.0.1' etc.
I have looked over my assignments of g.mysql_username and g.mysql_password hoping to find a typo and they look correct.

I am running out of ideas. Any suggestions?

[mlouis]

I modified the script to print out the actual error which seems to be :

Database type 'MySQL' is unsupported or not configured

[dotCOM_host]

I modified the script to print out the actual error which seems to be :

Database type 'MySQL' is unsupported or not configured
Contact your host to install the mySQL database library on your domain.

[mlouis]

I was able to get it working. Thanks.

[tantus]

I have Miva Mia and MySQL 5.1 installed and running and I installed the connector library and linked it in the Mia properties section.


<MvASSIGN NAME = "g.mysql_database" VALUE = "miva2my@localhost">
<MvASSIGN NAME = "g.mysql_username" VALUE = "miva2my">
<MvASSIGN NAME = "g.mysql_password" VALUE = "miva2my">

When running the tool I get


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

mysql:miva2my@localhostEven when I compile the file with custom MySQL connection info it gives me the same error.

Any thoughts on what to try next?

[tantus]

Got it working. In my particular case I had to update the library in Mia AND restart my machine. Just restarting Mia didn't work

[Nerd Boy Inc]

Dear All,

Getting this error on a fully updated 5.5 store. I have looked and there is no file listed that is is looking for. Did the name get changed? Has anyone ran this on a 5.5 store?

mivasql2mysql running...

--------------------------------------------------------------------------------

Opening mivasql... OK.
Opening mysql... OK.
Opening raw database Runtime error in mivasql2mysql.mvc @ [00000003:0000002a]: mivasql2mysql.mv: Line 398: MvOPEN: Error opening 'Merchant5/mivamerchant.dbf': No such file or directory OOPS, BAILING!: Cannot open raw xbase: Merchant5/mivamerchant.dbf

[ILoveHostasaurus]

A mivasql store should have a mivamerchant.dbf file in the Merchant5/ directory, are you sure the permissions, etc. are correct and the file is there?

[Nerd Boy Inc]

Dear David,

As far as I can tell all is right other than not seeing this file. The site is up and running and was upgraded to the latest stream last night.

I just sent you a PM as well.

[MatMcN]

I am getting the following error when trying to convert a mivaSQL to mySQL; I have completely removed the cbs shipping supermod, cleaned the store; packed the data and I am still seeing this error. Can anyone help me?

Opening mivasql... OK.
Opening mysql... OK.
Opening raw database OK.
Reading mivasql tables and converting...
Table: AdminSessions = File: adminsessions.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... OK.
Selecting and inserting... OK.
Creating indexes...
- Create Index: AdminSessions_1:adminsessions/1.mvx:session_id:remoteaddr:4 OK.
OK.
Table: cbs_cbslic = File: cbs/cbslic.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').

[CybrHost]

The script is "OOPS, BAILING!:" on the following datafile.

Table: EBusi_EBusilic = File: ebusi/ebusilic.dbf
Opening database... OK.
Fields... OK.
Generating SQL... OK.
Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').



Did anyone see this before?




--
Thank you,
Gary Hodder
Support
--
CybrHost Corp. - http://www.cybrhost.com/ - info@cybrhost.com
+1-866-300-MIVA - Professional Miva & E-Commerce web hosting services.

[Laura Schindler]

I'm getting the same error, but referencing a different module:

Table: MivaCentral_ID_PCINET = File: mivacentral/id/pcinet.dbf
* Opening database... OK.
* Fields... OK.
* Generating SQL... OK.
* Creating table... Runtime error in mivasql2mysql.mvc @ [00000000:000009c2]: mivasql2mysql.mv: Line 221: MvQUERY: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').
OOPS, BAILING!: mysql_stmt_prepare: For float(M,D), double(M,D) or decimal(M,D), M must be >= D (column 'mod_ver').


I'm going to try to contact James offlist. I'll post here when I hear from him.