#mysql
29 September 2007
Total 14 pages. You are browsing page 2/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:00 <****> I'll go to the port now.
01:00 <****> See you in a bit
01:00 <****> Hrm, I just had a good idea. mysqldump --all-databases --only-changed <-- is there a way to only backup only changed databases? .. I'm thinking of writing a script that checks show table status, parses it, then dumps accordingly
01:01 <****> first define --only-changed
01:01 <****> nils_: there is a lot in that log. I think I will killall and retry to see what changes in the log
01:01 <****> maestrojed: A lot of what?
01:02 <****> A lot of mysql log lines or from other ser vices
01:03 <****> seekwill: both, but I have also been trying a lot of mysql stuff lately. I can pastebin the whole thing if you wish. Or killall and try again and see what new stuff apears
01:03 <****> archivist, Jan 1st, you dump "test.yahoo" ... Today you go to do a full database backup, table hasn't changed so you pass: mysqldump --all-databases --only-changed "2007-01-01 00:00:01" .. if "test.yahoo" hasn't changed, it skips
01:03 <****> maestrojed: Any log lines that look interesting? That might tell you something??
01:03 <****> --last-modified "..." .. whatever
01:03 <****> TapoutT: Use the binary log?
01:04 <****> hi seekwill
01:04 <****> miracee: Hi
01:04 <****> miracee: How are you doing?
01:04 <****> seekwill, i don't binlog ;)
01:04 <****> fine thanks, and you?
01:04 <****> TapoutT: Maybe you should?
01:04 <****> miracee: Great!
01:05 <****> seekwill, working on winning the lottery first ;)
01:05 <****> TapoutT: The chances of you turning on the binlog is a lot better than winning the lottery
01:05 <****> At least 2:1
01:06 <****> seekwill: "mysqld[23472]: invalid adjustment '192.168.0.2'
01:06 <****> :)
01:06 <****> seekwill: that is not that box's IP
01:06 <****> maestrojed: Open up my.cnf and see if that's in it perhaps?
01:06 <****> seekwill, it's a good idea tho ... there are other tools that check to see if it's already updated .. ie: optimize table .. "table is already optimized"
01:06 <****> mysqlcheck .. detects.. :)
01:06 <****> TapoutT: You really shouldn't rely on mysqldumps
01:07 <****> why not?
01:07 <****> maybe I should master replicate for backups
01:07 <****> seekwill: were might I find tht file?
01:07 <****> maestrojed: /etc?
01:07 <****> i'm trying to do an insert into query but i keep getting an error, the select bit is ok but it doesnt like the first part - http://rafb.net/p/8raNfX35.html
01:07 <****> but then I'd want row level replication, then have to use 5.1 in production
01:07 <****> TapoutT: Because better options exist
01:07 <****> seek, like what?
01:08 <****> mctay: You use either VALUES or SELECT. Not both
01:08 <****> ah, thank you
01:08 <****> mctay: You probably just want to remove the VALUES, if name and manid are column names in models2. You are also trying to insert three columns in a table that has only two...
01:08 <****> hrm
01:09 <****> TapoutT: CSV
01:09 <****> i am trying to set a password for a database user and am having a problem
01:09 <****> TapoutT: LVM
01:09 <****> TapoutT: Binary logs
01:09 <****> seekwill: that file is not in etc. How can I search with linux/ubunut?
01:09 <****> maestrojed: find / -name 'my.cnf'
01:09 <****> whenever i do a "mysql -u root -p" i get prompted for the password, which i enter... but then i get an error saying "(using password: YES)"
01:10 <****> wrench--: Wrong password
01:10 <****> anyone here familiar with Tuning MYSQL for osCommerce ?
01:10 <****> I have 400,000 products in my database
01:10 <****> and it's a bit slow to search and browse
01:10 <****> when i initially set the password, there wasn't an issue
01:10 <****> the site is www.fiscodirect.com
01:10 <****> and i am sure i am using the same one i specified
01:10 <****> another question... are joins more efficient than using say table1.id = table2.id in your where clause?
01:11 <****> seekwill: I just get a whole bunch of permission denied stuff when I do that find command
01:11 <****> i think the sql joins in osCommerce are terrible
01:11 <****> do alpha-numeric characters cause problems in a password?
01:11 <****> select pd.products_name, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_
01:11 <****> xibalba_, you might need to tune oscommerce
01:11 <****> maestrojed: Too bad? Run it as root/sudo?
01:11 <****> hmm, tune it how?
01:11 <****> xibalba_: Not much you can really do about it
01:12 <****> mctay: Usually
01:12 <****> seekwill: thanks for putting up with the newbie stuff. I found it and the nice is set to that IP. I am not sure what "nice" is. Should it be set to this box's IP?
01:13 <****> nice?
01:13 <****> it's the same password... no idea why it doesn't like it
01:13 <****> Paste the line?
01:13 <****> wrench--: Someone changed it
01:13 <****> wrench--, an external login is not the same as a local one
01:14 <****> seekwill: but it also seems those settings are just for mysqld_safe not mysqld
01:14 <****> I don't know what you are talking about
01:15 <****> archivist, i understand
01:15 <****> mysqladmin -u root password FOO
01:15 <****> mysql -u root -p
01:15 <****> Enter password:
01:16 <****> i enter "FOO"
01:16 <****> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
01:16 * wrench-- shrugs
01:16 <****> i should point out that the actual password contains alpha-numeric chars
01:17 <****> wrench--: and the password is set for user root and host localhost?
01:17 <****> well, definitely for user root, not sure about host localhost
01:17 <****> but the example i followed didn't mention any sort of host qualification
01:19 <****> wrench--: alpha-numeric characters shouldn't be a problem
01:20 <****> i didn't think they would be....
01:20 <****> weird
01:20 <****> i guess i can reset the password to something without alpha-numeric chars
01:20 <****> and try again
01:21 <****> wrench--: have you restarted the mysql-server or did a "flush privileges" after changing the password?
01:21 <****> i used the mysqladmin command from a shell prompt to set the password
01:21 <****> (so no "flush privs"
01:21 <****> i'll restart mysqld
01:22 <****> nope, same result
01:22 <****> how annoying
01:22 * wrench-- wonders what went wrong
01:24 <****> seekwill: Here are my errors http://pastebin.com/d7374725f
01:24 <****> how does one reset a password?
01:24 <****> reset root
01:25 <****> See http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
Total 14 pages. You are browsing page 2/14.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last