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