MivaSQL to MySQL converter for MM5

[albunix]

Re: MivaSQL to MySQL converter for MM5

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...
  1. 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]

Re: MivaSQL to MySQL converter for MM5

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

Best,
James

[albunix]

Re: MivaSQL to MySQL converter for MM5

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

I shall post upon success/failure in a while.

Thanks James.

[albunix]

Re: MivaSQL to MySQL converter for MM5

James,

all good.

...just a snippet

1. 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]

Re: MivaSQL to MySQL converter for MM5

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) 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]

Re: MivaSQL to MySQL converter for MM5

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]

Re: MivaSQL to MySQL converter for MM5

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]

Re: MivaSQL to MySQL converter for MM5

I'm getting the:

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

message.

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]

Re: MivaSQL to MySQL converter for MM5

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

Database type 'MySQL' is unsupported or not configured

[d_host]

Re: MivaSQL to MySQL converter for MM5

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]

Re: MivaSQL to MySQL converter for MM5

I was able to get it working. Thanks.

[tantus]

Re: MivaSQL to MySQL converter for MM5

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@localhost

Even when I compile the file with custom MySQL connection info it gives me the same error.

Any thoughts on what to try next?

[tantus]

Re: MivaSQL to MySQL converter for MM5

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]

Re: MivaSQL to MySQL converter for MM5

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]

Re: MivaSQL to MySQL converter for MM5

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?