| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> without shutting down you need to use mysqldump
<0> !m fr33mind mysqldump
<1> fr33mind: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<2> are you using all myisam tables?
<3> I think yes.
<2> if you are, and no innodb at all, you can use mysqlhotcopy
<3> not sure. I don't know a lot of mysql, I just want to backup it..
<4> Im trying to convert my database users to pre-4 p***word form, using old_p***word('xx');
<5> gleam_: Nope, doesn't work. You'd figure there'd be a way to do this.
<4> But whats the string for any
<4> SET P***WORD FOR 'user'@'any' = old_p***word('xx');
<6> hi folks, I'm encountering "Incorrect key file for table" errors on 5.0.21
<2> you might want to do update mysql.user set p***word=old_p***word('xx') where user='user'; flush privileges;
<7> whats the preferred way to add a field to an existing table in mysql4, while preserving the existing table data?
<2> !m don-o alter table
<1> don-o: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<3> so the safest way is to use mysqldump?
<6> does anyone have any suggestions on what might be causing this?
<4> gleam_ thanks a lot.
<7> gleam_: thanks i didnt know mysql could do that
<4> by the way, the character for "any" was % :)
<2> yeah, but i wasn't sure if 'user'@'%' would do it for all users or just the user with the explicit host entry %
<8> if I want to do something like this: ALTER TABLE `users_table` MODIFY salt2 varchar(20) DEFAULT SHA1(RAND()); do I need to use triggers?
<8> or is there something in my syntax that is wrong?
<2> you'd need a trigger mick
<4> gleam_ 'user'@'%' does only edit the % user, not the localhost.
<8> I'm new to triggers :-/ - figured that much though
<9> mick_work, the guy is there now and he says my CREATE USER statement "caused a recursion in the kernel". I tried the same CREATE USER statement on my laptop where it was successful, just as expected. Telling him that, he responded that "the were a few parameters tweaked". So I asked him what command should I have used for creating a new user and he responded "you do that out of intuition". Does that make any sense to you?
<2> thien, he's a tool :)
<10> Makes the guy sound like a maroon.
<8> thien: it messed up since it wasn't supported in that version
<2> if it wasn't supported it would throw a syntax error
<2> it wouldn't "cause a recursion in the kernel"
<8> that guy should not be consulted in the future
<9> mick_work: didn't you say it was supported since 5.0.2? We have 5.0.18...
<11> Say I have a column called "Fruits" with different names. Some might repeat from time to time in a random manner. Is it possible to ask mysql to have the list of all unique entries in that column?
<8> nm, I misread
<8> dual monitors and doing 20 things at once, isn't a good idea to give advise :-)
<2> select distinct fruits from mytable
<3> What I want to do is adding this to crontab: mysqldump --opt --all-databases > /usb-drive/mysqldump.sql It's ok?
<2> sure
<8> thien: did you fix the problem though?
<8> thien: also WHATEVER YOU DO - do it on a test db before touching production
<9> mick_work, no idea what he did. I think he just /etc/init.d/mysql restart'd it
<8> ya, you said the users table was corrupted?
<8> did you repair the table?
<3> argn! mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using p***word: NO) when trying to connect
<9> Nope I was afraid it might be because of my CREATE USER command
<3> should be mysql user I suppose.
<8> you can just use INSERT INTO users.... and do a FLUSH PRIVILEDGES;
<3> (I'm in root)
<8> fr33mind: use whatever mysql user/p***word you use
<2> you need to put the root p***word, or the mysql user you want to run mysqldump as, in your my.cnf or ~/.my.cnf
<8> if it requires a p***word you may/may not want to specify it via the commandline
<2> the p***word for 'root'@'localhost' in mysql
<9> mick_work: from my pov it looks good again. Thanks for your council tho!
<12> Anyone have an idea when they're releasing another version of 5.1.* ? The 5.1.9 released has a security issue in it...
<2> you shouldn't be using 5.1.x in production or anywhere near where security matters
<11> gleam_: thanks
<12> i know, but i'm a nub
<12> i went to 5.1.9 and now i gotta dump, restore to 5.0 if i wanna go backwards and that would take 1-2 weeks i'm sure of it
<2> if you know it's been fixed in bk you could build from bitkeeper
<12> ya true, but mysql used to put out the next version almost immediately when a security issue was addressed. I'm not saying I should be using 5.1.9 in production, i'm saying ... like microsoft, if they knowingly have security issues on hand, they should address them immediately. How many new people are downloading 5.1.9 today... I love Mysql, i'll build from bitkeeper but still :)
<2> i'd guess about 3 people are downloading 5.1.9 today
<12> are you serious?
<12> 3 ?
<12> lol
<12> http://dev.mysql.com/
<12> load that up, they're pushing it.. i'd probably think about 5000-10000 people
<2> uh huh
<2> today?
<12> ya
<2> as in, may 29th, 2006?
<2> er
<12> correct
<2> 30th
<2> doubt it.
<8> is there a security announce list (or a security advisory part of the mysql page)
<12> I'd expect 3 people to be screwing with Access today, and 5-10K
<2> where's the bug for the security problem?
<2> or where did you see it?
<12> Bugs fixed : http://dev.mysql.com/doc/refman/5.1/en/news-5-1-10.html
<2> oh those. i think the thinking is that they don't provide special security releases for beta.
<2> because it is, after all, not production
<12> hey, it's not my company image .. :)
<2> uh huh
<12> ok, flip that.. imagine Microsoft is offering a beta version of something, and it has a security issue in it. You like to test things out, and now are sitting vunerable and microsoft's response is "well, it is beta and you shouldn't use it on a computer you care about... even tho we know the issue is in the beta, we're gonna let 3 more people download it today" :)
<2> i think that's a fine response. you're beta testing, take the lumps that comes with it
<12> microsoft would be choked to death :)
<2> why? they already wait weeks to release security patches?
<12> ah it doesn't matter, i'll backport to 5.0.*
<2> s/\?$//
<3> # mysqldump --opt -h localhost -u root --all-databases > mysqldump.sql
<3> mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using p***word: NO) when trying to connect
<3> and I have .my.cnf with p***word
<3> in /root
<3> root localhost Oui ALL PRIVILEGES <-- in phpmyadmin
<2> in the [mysqldump] or [client] section you have "p***word=rootmysqluserp***"?
<3> I have [mysql] stanza and [mysqladmin] stanza
<3> I have user = ... and p***word=... for each
<2> neither of those cover mysqldump.
<3> ~# cat .my.cnf
<3> [mysql]
<3> user = root
<3> p***word = ******
<3> [mysqladmin]
<3> user = root
<3> p***word = ******
<3> ok I understand.
<3> So I need an [mysqldump] stanza too..
<2> or a [client] stanza
<2> which will cover mysql, mysqladmin, mysqldump, etc
<3> can I rename [mysql] stanza to [client] ?
<2> sure
<3> thanks a lot :)
<13> hi. im using mysql. ive deleted some sql data from a table by mistake. is there anyway to get it back ?
<14> hi
<3> WORK! :)
<14> do innodb and myisam support fulltextsearch ?
<14> in mysql5 ?
<2> only myisam.
<14> gleam_: actually what is full text search ?
<2> !m floppyears full-text search
<1> floppyears: (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<14> thanks gleam_
<13> yes
<14> gleam_: but I thought that innodb was better
<2> it's better in many situations.
<2> it doesn't support fulltext, though.
<15> excuse me, is there a better alternative to SELECT * FROM events WHERE eid=358 OR oid=358;??
<12> select * from events where eid=358 union select * from events where oid=358;
<16> how do i tell if a keyword is found in a target data field?
<17> !m azn09 full-text search
<1> azn09: (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<15> xlx, thank you!
<15> xlx, what if the query is SELECT events.* FROM events JOIN venues USING(vid) WHERE eid=358 OR oid=358;
<15> ?
<12> OR doesn't use the indexes properly ... it can't use 2 different indexes... so union it
<16> appreciate it
<12> select events.* from events left join venues using(vid) where eid=358 UNION select events.* from events left join venues using(vid) where oid=358;
<15> looks sooo complex
<15> but thanks
<12> but you should have an index like ... (vid,oid) and .. (vid,eid) on the venues table ... just use EXPLAIN <query>
<15> | eid | int(11) | YES | MUL | NULL | |
<15> | oid | int(11) | YES | MUL | NULL | |
<15> | vid | int(11) | YES | MUL | NULL | |
<15> but i dont see any thing about indexes in EXPLAIN
<12> play around, learn, have fun.,
<13> is there any way to restore deleted data from sql ?
<12> Rarj, backups ?
<12> innodb, rollback if not committed
Return to
#mysql
or
Go to some related
logs:
#web
#centos
stephenford
#web
libmotif amd64 debian
How write own bootloader
#ai
The debootstrap program exited with an error (return value 139)
Please make sure that /etc/conf.d/net has $ifconfig_
lppasswd SuSe 10
|
|