Announcement

Collapse
No announcement yet.

mysql - how does it work

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    mysql - how does it work



    --Boundary_(ID_a8iVyuJCYD8zD6guVOf5zQ)
    Content-type: text/plain; charset=iso-8859-1
    Content-transfer-encoding: 7BIT

    How does the mysql option work in mm5? Does it replace the dbIII? Does it sync the info between the 2?

    Can I now write php pages to pull the product / order info onto static pages?

    =-=-=-=-=-=-=-=-=-=-=-=-
    David Perkowski
    Duvys Web Development
    (732) 905-0166
    (732) 901-0393 Fax
    [email protected]


    --Boundary_(ID_a8iVyuJCYD8zD6guVOf5zQ)--

    #2
    mysql - how does it work



    You have to choose whether you want it or not from the start,
    MM5 can't go from dbf to mysql currently. But yes, if you
    set up a MM5 store with MySQL back-end, you can hit it from
    any other application that can talk to MySQL to retrieve or
    manipulate the data as needed; just be careful when doing
    updates; you wouldn't want to add products without adjusting
    the related tables for example.

    David

    > -----Original Message-----
    > From: [email protected]=20
    > [mailto:[email protected]] On Behalf Of=20
    > David P - Duvys Web Dev
    > Sent: Monday, May 16, 2005 5:30 PM
    > To: [email protected]
    > Subject: [m5u] mysql - how does it work
    >=20
    > How does the mysql option work in mm5? Does it replace the=20
    > dbIII? Does it sync the info between the 2?
    >=20
    > Can I now write php pages to pull the product / order info=20
    > onto static pages?
    >=20
    > =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
    > David Perkowski
    > Duvys Web Development
    > (732) 905-0166
    > (732) 901-0393 Fax
    > [email protected]
    >=20
    >=20
    >=20


    Comment


      #3
      mysql - how does it work



      If it is set to use Mysql then will it not be using the dbf at all? Do I
      have to be concerned that some modules won't work with the mysql database?

      ==================
      David Perkowski
      Duvys Web Development
      (732) 905-0166


      ----- Original Message -----
      From: "David Hubbard" <[email protected]>
      To: "David P - Duvys Web Dev" <[email protected]>;
      <[email protected]>
      Sent: Monday, May 16, 2005 5:37 PM
      Subject: RE: [m5u] mysql - how does it work


      You have to choose whether you want it or not from the start,
      MM5 can't go from dbf to mysql currently. But yes, if you
      set up a MM5 store with MySQL back-end, you can hit it from
      any other application that can talk to MySQL to retrieve or
      manipulate the data as needed; just be careful when doing
      updates; you wouldn't want to add products without adjusting
      the related tables for example.

      David

      > -----Original Message-----
      > From: [email protected]
      > [mailto:[email protected]] On Behalf Of
      > David P - Duvys Web Dev
      > Sent: Monday, May 16, 2005 5:30 PM
      > To: [email protected]
      > Subject: [m5u] mysql - how does it work
      >
      > How does the mysql option work in mm5? Does it replace the
      > dbIII? Does it sync the info between the 2?
      >
      > Can I now write php pages to pull the product / order info
      > onto static pages?
      >
      > =-=-=-=-=-=-=-=-=-=-=-=-
      > David Perkowski
      > Duvys Web Development
      > (732) 905-0166
      > (732) 901-0393 Fax
      > [email protected]
      >
      >
      >


      Comment


        #4
        mysql - how does it work



        Yep... the modules have to be written for mm5.. the whole paradigm is
        different...
        mm4 modules wont' work until they are modified. Same thing happened back
        when Merchant
        went from uncompiled to compiled. The module makers just gotta match the
        api of the new way of doing thing..

        Kelly

        David P - Duvys Web Dev wrote:

        >If it is set to use Mysql then will it not be using the dbf at all? Do I
        >have to be concerned that some modules won't work with the mysql database?
        >
        >==================
        >David Perkowski
        >Duvys Web Development
        >(732) 905-0166
        >
        >
        >----- Original Message -----
        >From: "David Hubbard" <[email protected]>
        >To: "David P - Duvys Web Dev" <[email protected]>;
        ><[email protected]>
        >Sent: Monday, May 16, 2005 5:37 PM
        >Subject: RE: [m5u] mysql - how does it work
        >
        >
        >You have to choose whether you want it or not from the start,
        >MM5 can't go from dbf to mysql currently. But yes, if you
        >set up a MM5 store with MySQL back-end, you can hit it from
        >any other application that can talk to MySQL to retrieve or
        >manipulate the data as needed; just be careful when doing
        >updates; you wouldn't want to add products without adjusting
        >the related tables for example.
        >
        >David
        >
        >
        >
        >>-----Original Message-----
        >>From: [email protected]
        >>[mailto:[email protected]] On Behalf Of
        >>David P - Duvys Web Dev
        >>Sent: Monday, May 16, 2005 5:30 PM
        >>To: [email protected]
        >>Subject: [m5u] mysql - how does it work
        >>
        >>How does the mysql option work in mm5? Does it replace the
        >>dbIII? Does it sync the info between the 2?
        >>
        >>Can I now write php pages to pull the product / order info
        >>onto static pages?
        >>
        >>=-=-=-=-=-=-=-=-=-=-=-=-
        >>David Perkowski
        >>Duvys Web Development
        >>(732) 905-0166
        >>(732) 901-0393 Fax
        >>[email protected]
        >>
        >>
        >>
        >>
        >>
        >
        >

        Comment


          #5
          mysql - how does it work



          From: David P - Duvys Web Dev [mailto:[email protected]]=20
          >=20
          > If it is set to use Mysql then will it not be using the dbf=20
          > at all? Do I have to be concerned that some modules won't
          > work with the mysql database?

          If a module is not specifically written to use the
          mysql interface, it will still be able to use dbf
          databases. So you're not guaranteed that a module
          you install in a mysql-based MM5 store will have its
          specific data in mysql.

          David


          Comment


            #6
            mysql - how does it work



            David P - Duvys Web Dev wrote:
            >
            > If it is set to use Mysql then will it not be using the dbf at all? Do I
            > have to be concerned that some modules won't work with the mysql database?
            >
            > ==================
            > David Perkowski
            > Duvys Web Development
            > (732) 905-0166

            Modules will be written to use the mysql database. However, the
            module's own configuration data may be in a dbf. That dbf will work in
            most scenarios. If your store is in a load balanced environment, even
            then, most scenarios will be ok. I saved comments from David and Tim on
            this issue when they responded to question I had asked. You can read it
            at <A HREF ="http://www.emporiumplus.com/v5/loadbal.htm ">http://www.emporiumplus.com/v5/loadbal.htm </A>

            --
            Bill Weiland A2Z Emporium Plus <A HREF ="http://www.emporiumplus.com/store.mvc ">http://www.emporiumplus.com/store.mvc </A>
            Modules for eCommerce. Mail Mgr, Coupon, PayPal, Froogle/Yahoo feeds
            Rate This, Gift/Wish List, Wait List Mgr, EZ Batch, Shipping & more
            Online Documentation <A HREF ="http://www.emporiumplus.com/docs">http://www.emporiumplus.com/docs</A>
            Question <A HREF ="http://www.emporiumplus.com/mivamodule_wcw.mvc?Screen=SPTS ">http://www.emporiumplus.com/mivamodu...vc?Screen=SPTS </A>
            |


            Comment

            Working...
            X