If not i suppose i could do.

 
Tarter: I am writing a script to import this data into mysql table, and the table that has item_id and value_id has 15k records so far and its nowhere near finished, and also, I need to update this data every so often

Tiedemann: I am unsure how best to iterate the data and update it for example, in that reallllly long list of IDs, what if another gets added?

Ehresman: It is harder to detect deletes

Hollinshed: Is it a case of just a long CRON job ?

Brydges: Or do I do some PHP matching

Caldero: Intersect or something

Minnerly: DELETE FROM valyes WHERE item_id = X; INSERT all items in a loop

Warson: INSERT all values in a loop

Lichorat: So drop the data and re-add ?

Koller: Because this data will be used on a live site

Woodlock: Boleware, there shouldn’t be deletes, only adds

Rasnic: The “dictionary” table now has 30k records, taking a while to do a lot of inserts

Fullen: Damn i am inserting them all wrong

Condiff: Boleware, I wasn’t doing a bulk INSERT I was doing 70000 single INSERTS so no wonder it was slow. Your idea of truncate and re-insert is good

Macy: Whats the best way to check the query history ?

Bachinski: Sam-lap: enable the general query log or the binary logs

Bachinski: Sam-lap: https://dev.mysql.com/doc/refman/5.6/en/server-logs.html

Bachinski: Sam-lap: only the error log is on by default

Mosier: This weekend I am going to be upgrading from MySQL 5.1 to 5.5, are there any major gotchas that I should be on the lookout for while doing this so I can hopefully keep the time this takes under control?

Roesser: Mr_Midnight: have you read the appropriate section of the manual?

Bish: Https://dev.mysql.com/doc/refman/5.5/en/upgrading.html and in particular https://dev.mysql.com/doc/refman/5.5/en/upgrading-from-previous-series.html – it lists incompatible changes

Hayford: Snoyes: I will look that over today before I do the upgrade this weekend, thanks for the info

Barone: Snoyes: this is a fairly basic install only running a single wordpress site on it so I’m hoping there isn’t too much that goes into this. when this server was built less than a year ago I don’t know why they didn’t use MySQL 5.5 to start with

Achziger: If it was within the last year, 5.6 would have made more sense

Gallinari: Yeah nothing that was done by the previous network admin here quite makes sense

Darwich: We had a production server installed with MS SQL 2014 Enterprise Trial Edition that expired middle of a business day. they had purchased Standard and not Enterprise and there is no easy ‘downgrade’

Bereznak: Can i do a select left join without the same info? like if i want to have everything that is in table A that is NOT in table B?

Pazik: Unnu: SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL;

Tolzmann: Can you explain the logic there?

Coady: Unnu: Very basic join information: http://hashmysql.org/index.php?title=Introduction_to_Joins – For more indepth info: http://dev.mysql.com/tech-resources/articles/mysql-db-design-ch5.pdf

Garan: If no match is found, all columns from that table are set to NULL for that row.

Cistrunk: Hi all, i am using mysql and my app is getting data from table. after some time i could not be albe to access data, when i try to connect mysql from terminal i get following message

Garnes: I setup root p***word again and it start working. but i already had p***word set for root before above message comes up

Weiler: I am using centos and mysql 5.1.73

Collette: I am still having problems here. i have a table cl***esTaken{id int, cl***id int, startTime varchar255, userid int} and avalibleCl***es{id int, startTime varchar255, name varchar255} and users{id int, name varchar255} And i want to select all avalibleCl***es where avalibleCl***es.startTime != cl***esTaken.startTime if corresponding Cl***esTaken.userid = X

Standaert: Patie: https://bugs.mysql.com/bug.php?id=74042

Sporich: If not i suppose i could do the search in php