#mysql
12 October 2007
Total 26 pages. You are browsing page 3/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:55 <****> ren2007bb
01:55 <****> thats username, man mysql
01:55 <****> *sigh*
01:55 <****> ?
01:56 <****> mysql -uren2007bb(username) -p*****(password) ren2007bb < c:\ren2007bb.sql
01:56 <****> how is that wrong?
01:57 <****> and read what you wrote ffs
01:57 <****> mysql -p -u ren2007bb < c:\ren2007bb.sql = Gives me and error "Incorrect database name "en2007bb.sql", what happened to the 'r'?
01:57 <****> i put the -p and -u backwards...
01:57 <****> nm
01:58 <****> anyone mind explaining on why a float would truncate at 221.1 instead of 221.11
01:59 <****> is there a way to sybstr so to speak in mysql?
01:59 <****> substr
02:01 <****> Any ideas on what can cause mysql db corruption? I've never had it before, but am running into it a lot now with a system running mysqld under vmware server on CentOS.
02:02 <****> hardware problems?
02:02 <****> hardware is fine. non-vmware fedora core 3 has no problems and is running mysql as well with no issues
02:02 <****> (I should say, the hostos is fc3)
02:03 <****> If the vmware session (or even a physical box) ran slow or out of memory, could that cause it?
02:03 <****> MyISAM or InnoDB?
02:03 <****> Zabbix, a server monitoring tool, is reporting the server load and cpu is high at times...
02:03 <****> Simetrical - I don't know. Whatever the default is for CentOS. How can I check?
02:05 <****> load as in load average?
02:05 <****> It appears to be InnoDB: ;InnoDB: End of page dump
02:05 <****> 071011 17:07:33 InnoDB: Page checksum 2619754003, prior-to-4.0.14-form checksum 3671331684
02:05 <****> jroysdon, do this: USE information_schema; SELECT ENGINE, COUNT(*) FROM TABLES GROUP BY ENGINE;
02:05 <****> Yes, load average
02:05 <****> ugh
02:05 <****> jroysdon, that just means InnoDB is running, it doesn't mean the database tables you're actually using are InnoDB.
02:05 <****> Simetrical - I cannot start up mysqld as it has errors
02:05 <****> Well, I can restore an old copy, I guess
02:06 <****> jroysdon, ah.
02:06 <****> What error message is it giving you? That's kind of important info. :)
02:07 <****> heh, one sec
02:11 <****> doesn anyone have an example of fbjs ajax?
02:12 <****> Hi
02:12 <****> is it possible
02:12 <****> to change Cell Type DATE in format dd.mm.yyyy
02:12 <****> PaulB: what is it
02:13 <****> oh aorry
02:13 <****> sorry
02:13 <****> facebook javascript
02:13 <****> Does mysqld.log have any "sensitive" info in it, or could I just post the whole thing online?
02:13 <****> [M4rk0]: date_format
02:13 <****> jroysdon: the query log?
02:14 <****> jbalint - the log stored on CentOS (and other RedHat-based distros) in /var/log/mysqld.log
02:14 <****> is it queries or errors
02:14 <****> ooooooooh... RobotJox... hehe
02:15 <****> I don't think it is queries. It's the log about the mysqld as to what state it is in and any error messages are showing in it
02:15 <****> I have a table with a "password" column. Wha is the best stament to update all these columns with the result of calling "PASSWORD" function on that column for each and every row?
02:15 <****> I don't see anything. Simetrical, here is the log for you to check out:ftp://jason.roysdon.net/pub/jroysdon/tmp/mysqld.log
02:16 <****> Simetrical - the second page shows where the errors start.
02:16 <****> jroysdon, is it necessary for me to download all 156.4 MB?
02:16 <****> Because if so, you're going to have to wait half an hour or so.
02:16 <****> Simetrical - no, just the first two pages give it to you
02:16 <****> jbalit when I reade cell "reg_date" from table, how should i SELECT reg_date? to get dd.mm.yyyy.
02:16 <****> I can do a tail and get you just that if you like ;-p
02:16 <****> [M4rk0]: use date_format()
02:17 <****> i don't understande where to use it :)
02:17 <****> jroysdon, so, uh, maybe you should post a link to just the first two pages so I don't have to download the whole thing? Also, how is it that the *first* two pages contain info relevant to *recent* failure to start?
02:17 <****> ftp://jason.roysdon.net/pub/jroysdon/tmp/mysqld-head500.log
02:17 <****> That's better.
02:17 <****> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format
02:17 <****> anyone? how to change all "password" columns to be the result of calling PASSWORD function on the previous contents of that column?
02:17 <****> shamrock: update
02:17 <****> shamrock, UPDATE table SET password=PASSWORD(password);
02:18 <****> super thanks guys
02:19 <****> Don't use the PASSWORD() function
02:19 <****> why
02:19 <****> It's not meant for you to use in your applications
02:19 <****> Stated in manual, btw.
02:20 <****> jroysdon, this happened only once, or you've fixed it before and it keeps coming back? Once could be a fluke, e.g., some kind of one-time hard disk failure.
02:22 <****> It has occurred twice in this vmware install. Each time I just untar a backup of /var/lib/mysql that I have, and eventually it is corrupted (a day or so).
02:22 <****> Zabbix, a server monitoring tool I'm using on the same box, is writing too it very heavily with tons of server stats for a bunch of nodes.
02:23 <****> Okay, so bear in mind I'm totally not an expert. But in principle, InnoDB does not corrupt files, ever. If a file is corrupted, it is either: 1) a bug in InnoDB, 2) a bug in the OS, or 3) a hardware failure.
02:23 <****> I'm just wondering if the box is not beefy enough to be running a vmware session under it like this and if a slow cpu could cause corruption, or if it is purely a disk thing that is getting corrupted.
02:23 <****> Hi
02:23 <****> Ok, so vmware server could be corrupting it when it writes it sends it to the vmware hostos to write it to disk.
02:24 <****> It's not just high load. MyISAM can get corrupted under high load, at least somewhat, because it's non-transactional. I've had mysqld crash due to out-of-memory and then have to repair various MyISAM tables. But that shouldn't happen for InnoDB.
02:24 <****> Other apps are using the same disk that the vmware server is writing to on the hostos and no errors whatsoever... points to vmware server as far as I can tell. I wonder if a slow hostos could cause vmware server to corrupt disk writes.
02:24 <****> If it does, you're looking at some kind of bug and/or hardware failure, AFAIK.
02:25 <****> I have to tables A and B. Both has a column called photo_id. I would like to know how many photo_id fit in both table but they are not primary key nor foreign key.
02:25 <****> Yeah, but the hostos hardware is rock solid. 212 uptime with tons of mysql/apache apps running on it and high traffic.
02:25 <****> what would be the simpliest way to call a picture from a database?
02:25 <****> err... what?
02:25 <****> could I not query a table
02:25 <****> and then just print it out?
02:25 <****> storing picture in db is stupid
02:25 <****> if I do a join, I will take the ones that have the same ID but no the same photo.id
02:26 <****> Simetrical - is there some sort of debug I could turn on with mysqld to test this or sort this out? A way for it to verify each write or something?
02:26 <****> tibyke: why?
02:26 <****> kur1j, no way im gonne persuade you
02:26 <****> jroysdon, no clue, sorry.
02:27 <****> how would i select all the rows distinct on two columns, ex: first_name and last_name
02:28 <****> select distinct
02:28 <****> I have a detail that is driving me crazy!
02:28 <****> select DISTINCT first_name, last_name from names;
02:28 <****> y
02:28 <****> ?
02:28 <****> I have a table that records time entries
02:28 <****> seems this table (I am just learning on of it's complexities)
Total 26 pages. You are browsing page 3/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last