Hasha: Jx, “use dbname” – you maybe define the db directly in php connection so that may differ
Laviola: I’m supposedly defining it in the connection, but I have no doubt that could have been done wrong to. Like I said, I’m learning, and when rrors arise, I’m the first, second, and fourth suspect.
Grodi: Jkavalik: Is there a functional difference between fieldname and ‘fieldname?
Fulco: Jx: Use around identifiers database/table/column/alias names and ‘ around strings and dates. MySQL does allow ” for strings, but ANSI standard uses ” for identifiers which you can enable with ANSI QUOTES option.
Whiston: Ubiquity_bot: Let me try that.
Demartino: When I create temporary table and then table with the same name, how to access real table and not temp one?
Alvacado: Let’s say my query has huge data and I dont want tested selects.
Falgout: To state the obvious. don’t create a tmp table with the same name as a real table
Czysz: Jkavalik: LOL, didn’t notice until now I replied to a bot. However, yoru help got me getting data IN, so progress.
Heximer: OneSploit: Drop the temporary table and you will be able to access the original one again
Whisenant: Jkavalik: You were a huge help, I see other errors now, and that’s useful. jkavalik++
Grammes: Jx, you are welcome; yep, seeing errors is much better than just silently not working
Heximer: Jkavalik: There is no way statement will fail silently if there is missing ‘
Borgert: Salle, not in mysql, but it was probably php error
Pals: Or not checking for errors?
Heximer: Jkavalik: I’d say not checking for errors
Gelen: Oh, they already left. I missed the statement about it failing silently in CLI too – it did not execute at all
Heximer: Jkavalik: Which is what I don’t trust :
Trometter: Salle, the ‘ prompt should be a big enough hint
Eaglen: Mysql won’t let you rename a database that has triggers? D:
Eaglen: Is there a way round this?
Eaglen: Wait I found a way round it
Stringham: You can’t rename a database
Baird: Hi, I’m not familiar with mysql and got an issue I think due to a server crash. T get
Lidey: ERROR 126 HY000 at line 1: Incorrect key file for table ‘/tmp/#sql_62f6_0.MYI’; try to repair it
Wetz: On the next try the 62f6_0 part will change.
Ako: It is a temporary table
Carreira: What are you trying to do?
Zalazar: I have to stop mysql and restart it due to the lack of resources malloc errors when upgrading the weak system with apt-get. Otherwise apt-get will get out of memory.
Heximer: Eaglen: MySQL won’t let you rename database regardless of triggers
Joncas: On the start I now get those errors.
Heximer: Floogy: Check if you have enough disk space in /tmp
Heximer: Floogy: Modern distros use memory fs for /tmp and it is easy to use all of it
Pearyer: Salle. I didn’t had, but I removed some cache file and ran apt-get clean.
Heximer: Floogy: You can set tmpdir=something_else in your my.cnf or appropriate /etc/my.cnf.d file
Heximer: Floogy: Don’t run apt-get
Heximer: Floogy: Reinstalling MySQL almost never helps with anything
Malekan: Ah, you’re right, salle: df -h /tmp – overflow 1,0M 32K 992K 4% /tmp
Heximer: Floogy: These files are temporary table used by some query and they might need hundreds of MB and even GB if the query wasn’t optimized well
Heximer: Floogy: You can run apt-get clean hundreds of times, but it will not help at all with this :
Kirchman: Salle, no. It was a normal dist-upgrade to update the system. But due to lack of resources I really have to switch to a new server I have to stop munin, and mysql for that task. I wouldn’t reinstall mysql.
Eledge: Ok, so /tmp isnt on that mountpoint.