kathygriffin

Actually I did that wrong It will look like this. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other16">something15</field> <field name="other16">something16</field> <field name="other18">something17</field> <field name="other18">something18</field> <field name="other18">something19</field></doc> </add>

Well that still doesn't explain why it only queried half of the items. Because it did keep on querying.But on the old stuff..So that one I have yet to figure out. It works now and I am happy. Is there any log anywhere that might say? thank you

Its the same exact query that I am sure of. Its 5.1.73 For some reason when I added another 20,000 items it never queried everything. Only the old stuff. So I deleted the even then readded it. Any suggestions or ideas where to look or what to do besides upgrading mysql? Thanks

Thank you for letting me. Ok Here is what I am dealing with. Only its about 200,000 items. <?xml version="1.0" encoding="UTF-8"?> <add> <doc><field name="id">something</field> <field name="other1">something2</field> <field name="other3">something3</field> <field name="other4">something4</field> <field name="other5">something5</field> <field name="other6">something6</field> <field name="other7"><![CDATA[something7]]></field> <field name="other8"><![CDATA[something8]]></field> <field name="other9"><![CDATA[something9.jpg]]></field> <field name="other10a"><![CDATA[<p></p>]]></field> <field name="other10">something10</field> <field name="other11">something11</field> <field name="other12">something12</field> <field name="other13">something13</field> <field name="other14">something14</field> <field name="other15">something15</field> <field name="other16">something16</field> <field name="other17">something17</field> <field name="other18">something18</field> <field name="other19">something19</field></doc> </add>

Wow thats exactly what it was. Turns out whenever you add more rows of data you have to go in and delete the old event then add it again. I am using 5.1 something i believe. Is this a bug or is this how mysql events are suppose to be ?

I went ahead and deleted the event then added in a new one... I will keep eveyone posted.

ok so I had this database of 20,000 items. My part numbers I had to add a gg in front of all them then add them into the same database. So I had the old part numbers that looked like this 33344 and new part numbers that looked like this gg33344. Now for some reason it is only totaling up the old numbers and not the new numbers. The same exact query with a recently new database was built and seems to have no issue with the letters being in front. So my guess is that if you insert new items into database you have to readd the event? Anyone have any ideas or input? example of new database after query ran for total my query is something like this total = (stock ny+ stock nc ) part number - stock ny - stock nc - total 33344 5 6 11 gg33344 5 6 0 34344 5 6 11 gg34344 5 6 0 36344 5 6 11 gg36344 5 6 0 thanks

bump

bump

Sorry.. Heres what I am working with USE things; LOAD XML LOCAL INFILE 'C:/Users/computer/Documents/items.xml' INTO TABLE everything ROWS IDENTIFIED BY '<doc>'; /g Now in the xml file I have more than one field name that is named the same thing. For example I have 3 stuff2 and 4 stuff3s In my mysql table with the code I am using about it inserts only the first field of stuff2 and first field of stuff3s. So I setup stuff2 then stuff2a then stuff2b how would I get it setup to into the mysql column names that do match.

How would I extract xml to go into the correct rows where the xml stuff1 is in there 4 times. I can't use stuff1 in mysql column because it will not allow me to use the same name... Any suggestions?

Actually I just tried USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load ROWS IDENTIFIED BY '<doc>' ; /g I will find out in about 4 hours if it worked..

I did look at what you sent you but I am a bit confused here so if I have it right I would have to use it like this >>> USE stuffdb; LOAD XML LOCAL INFILE 'C:/Users/computeruser/Desktop/stuff.xml' INTO TABLE stuff_load (stuff1,stuff2, stuff3, stuff4, stuff5, stuff6, stuff7, stuff8, stuff9) ROWS IDENTIFIED BY '<doc>' /g Correct?

A. Some files are 100 mb some others are about 200 mb. Some part numbers contains more data then others. B. I'm not seeing row anywhere. I have provided a example below. Thanks <doc><field name="id">22439789</field><field name="prtnmbr">22439789</field><field name="subprtnmbr">22439930</field><field name="mannmbr">00955tr</field><field name="listprc">370.95</field><field name="updatedate">2014-01-01T01:56:03Z</field><field name="iname"><![CDATA[TIRE 190/55 ZR17 PILOT ROAD3 B]]></field><field name="vname"><![CDATA[MICHELIN]]></field><field name="atrribute"><![CDATA[BIAS / RADIAL, RADIAL]]></field><field name="atrributevalueid">11</field><field name="atrribute"><![CDATA[SPEED RATING, (W)-&GT;168 MPH]]></field><field name="atrributevalueid">118</field><field name="atrribute"><![CDATA[LOAD INDEX, 75-853 LBS]]></field><field name="atrributevalueid">154</field><field name="producttype"><![CDATA[TIRES]]></field><field name="atrribute"><![CDATA[FADE, REAR]]></field><field name="atrributevalueid">464</field><field name="atrribute"><![CDATA[TUBE TYPE, TUBELESS]]></field><field name="atrributevalueid">556</field><field name="atrribute"><![CDATA[TIRE INNER DIAMETER, 17 INCH]]></field><field name="atrributevalueid">561</field><field name="atrribute"><![CDATA[WIDTH, 190 MM]]></field><field name="atrributevalueid">588</field><field name="atrribute"><![CDATA[ASPECT RATIO, 55]]></field><field name="atrributevalueid">593</field><field name="atrribute"><![CDATA[PURPOSE, STREET]]></field><field name="atrributevalueid">608</field><field name="atrribute"><![CDATA[TIRE LINE, PILOT ROAD]]></field><field name="atrributevalueid">677</field><field name="atrribute"><![CDATA[TIRE BRAND, MICHELIN]]></field><field name="atrributevalueid">689</field><field name="atrribute"><![CDATA[VERSION, LOADED/TWO-UP]]></field><field name="atrributevalueid">692</field></doc>

bump....

Thank you.. I just ended up making a timezone cheat sheet for easy cross refrence. Thanks though

Ok just bare with me on this question. In phpmyadmin Is there anyway to change the last_execution time to my eastern standard time? Instead of showing the UTC time? Can I change the time zone in system to say like eastern or what would it be UTC - 5 instead of saying system? Is something like that even possible? Thank you

No your not being a ass. I think we are just on two separate pages. I did forget to mention I was using a different version because I did upgrade to a higher version. I will double check everything and post back. Thanks for all your help so far.

Yes I have the superuser. Actually I am running everything as root@local Is there any possible way I can take of system time and put in eastern time? I know I am probably missing something stupid.

Actually they are executing at the incorrect time...

Yea I like for things to be less confusing.. As for the time_zone there is a column that ays time_zone abd it shows system. I am wondering if I changed that to eastern it would change...

You have any suggestions or does anyone else have any suggestions on what version doesn't have any bugs? I upgraded to 5.1.73 but that didn't fix anything.

Dang.. Yea that looks like thats it. I even went into /etc/my.cnf and tried to put in the default-time-zone and it didn't seem to go... Thank you very much. How did you look up that bug so quickly?

I just double checked.. its 5 hours ahead actually.. Sorry I my math was wrong... yea maybe another setting somewhere in mysql or something? Is there any time in just mysql that runs differently then the server itself?

I use phpmyadmin and go to mysql > events then browser and in column last_executed. I am using lamp centos 6.4 when I run etc/sysconfig/clock it shows America/New_York which would be eastern time. When I put in date as the command its showing the correct.. Is there maybe something else for mysql somwhere else? As for my timezone it is showing system when I run SELECT @ @ Global.time_zone, @ @ session; Thanks