| |
| |
| |
|
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 25
Comments:
<0> bobfield: should i just put root as the user?
<1> makes most sense
<0> hmm, seems to have froze
<0> that, or it takes a very long time to load it
<0> compared to the dump time
<1> could be more work to do depending on indexes and such
<1> reading data is quick, writing indexes can be slow
<2> Hi
<2> I have server files under $MYSQLDIR/var like this
<3> hi all
<2> mysql-bin.number, mysql-bin.000459 what are these files?
<3> once apon a time I saw a cool perl script that would backup mysql databases and keep x copies of daily, weekly, monthly dumps
<3> skopo: your bin log
<2> Can I delete these files?
<3> skopo: are you using replication?
<2> no
<3> do you want crash recovery?
<2> no xD
<3> xD?
<2> No idea about binary logs :)
<3> you can disable the bin-log in the my.conf
<2> ahh, thanks
<3> and you can also run a flush log command from the admin and clear out the log
<4> can mysql change character like or ` from spanish to english, for example? or can phpmyadmin do this?
<5> wfq, Is it for web?
<4> keizer, yes
<5> I would use the code for it then
<5> Give me a sec, i'll get the link
<4> but, i have changed the html code
<5> http://us3.php.net/htmlspecialchars
<2> I can disablle log-bin-mysql-bin put the # before?
<0> bobfield: it's been 10 minutes and it didn't do anything..
<6> how to search, using LIKE %text%, insensitive with accent-keys ? eg: I find by coracao and it returns corao
<0> and looking back in /var/lib/mysql, it seems that it hadn't even made the folder to start writing data into
<1> mysql is still running?
<0> well... kinda yes kinda no
<0> if i type in mysql, it just kinda sits and waits
<0> oh, wait, i think i know
<2> I can disable log-bin-mysql-bin put the #/comment before?
<0> i have to run the whole database making script before i can import my dump
<2> what is the way?
<0> don't i?
<5> lol yeah if the mysql table is not created
<0> /that's/ the tricky bit...
<1> Lokathor, well the dump should create all the tables and data
<0> ***uming that a program can make something from scratch
<1> the thing we weren't sure about was the privileges and stuff in the grant tables
<0> aopen25:/var/lib/mysql# mysql_install_db
<0> Installing all prepared tables
<0> Fill help tables
<0> and then it's stopped again
<0> for over a minute
<1> it's apparently crunching away at something
<1> lots of hard drive activity?
<7> that last one ****ed
<0> well i don't hear anything special, and Gnome System Monitor refuses to open...
<0> i think my computer... has hit a bad patch of RAM perhaps..
<1> hardware issues?
<0> ran memtest86 the other day... told me i had something over 2,000 RAM problems..
<7> haha
<0> even if it's not actually that many, that's still a whole lot
<7> that's a big bad patch
<0> new Min/Maxer note: Charisma can be a dump stat, motherboard cannot
<0> it keeps destroying my ram chips
<7> buy a new motherboard
<1> sounds like you need to fix some hardware issues
<8> how can I select a unique record, base on a simple select statement from which no other process can select the same record? e.g. similar to row level locking? for example http://hashmysql.org/paste/viewentry.php?id=1543
<9> jade: sounds like a subselect. no need for explicit locks.
<8> arjenAU, thanks!
<0> well i guess the lord isn't my Shepherd because i'm definitely left wanting
<9> or a join. whatever.
<9> Lokathor: help yourself, so you may get helped.
<8> arjenAU, subselect or join? join is for more than one table... not sure how that would work.
<9> jade: it's just a multi-table update I think.
<1> well I'd be skeptical of a system with memory issues.
<9> jade: if you don't know how to use joins, you really need to get eddemacated.
<9> it's kinda fundamental.
<9> bobfield: skeptical is a very kind way of putting it
<8> arjenAU, heh, i know how to do join, but a join to solve this particular issue was not clear.
<10> anyone able to tell me why when I start my cluster and do a show (btw, this is a test sandbox for me to learn clustering) and I do show in ndb_mgm, I see my two ndb nodes but both show up as masters and I know that isn't right. Why are they both showing up as masters?
<10> oh, nm. :)
<9> cloaked: output error. lemme kick a dev. which version is this?
<10> I think I figured it out. Let me check something
<10> 5.0.18
<10> just a sec
<11> the master is the node that has been running the longest
<10> arjenAU: no output errors...that I see on STDERR.
<11> and it has nothing to do with the replication sense master ;)
<10> HarrisonF: if that's the case then why are both showing as masters?
<9> cloaked: it's an output error. bug ***igned to stewart smith (cluster dev)
<11> cloaked: try restarting one, <nodeid> restart
<12> could someone point me in the right direction. I am trying to change all the entries in a column from name1 to name2. What mysql command am I looking for here?
<10> just a sec
<11> arjenAU: stupid bugs!
<7> LB!
<9> firewire: ?
<10> and let me see if I got this right...the only daemon that uses config.ini is ndb_mgmd, right?
<7> arjenAU you know LB
<9> HarrisonF: how's the book coming along
<10> ndbd uses my.cnf, right?
<9> firewire: ye worked it out
<9> cloaked: no. ndbd uses nothing.
<10> ah
<11> arjenAU: good, at the publishers now, should be out soon
<9> cloaked: you just tell it where the mgmd is and that's all.
<11> cloaked: it does use the my.cnf, but not a lot goes in there
<0> ok, reboot, fresh start and what, and now it made the database
<0> InnoDB: Error: log file ./ib_logfile0 is of different size 0 2166784 bytes
<0> InnoDB: than specified in the .cnf file 0 5242880 bytes!
<0> 060306 17:57:31 [ERROR] Can't init databases
<0> 060306 17:57:31 [ERROR] Aborting
<11> cloaked: mgmd info, maybe a no-start option or similar
<0> but i get that
<10> Harrison; right, just the connect-string, right?
<11> correct
<13> Gumby: something like UPDATE <table> SET COLUMN='NAME2' where COLUMN='NAME1' - something along those lines
<11> anything you would see in ndbd --help
<9> !m Lokathor innodb errors
<14> Lokathor: Nothing found
<9> !m Lokathor innodb error
<14> Lokathor: (InnoDB Error Codes) : http://dev.mysql.com/doc/mysql/en/InnoDB_error_codes.html
<9> hmm
<11> Lokathor: you changed the size of the redo logs without deleteing them first
<12> mikere: so UPDATE is the command then.. thx
<13> Gumby: yes
<9> Lokathor: http://dev.mysql.com/doc/refman/5.0/en/error-creating-innodb.html
<0> that's entirely possible Harrison, and was entirely an accident if i did
<13> Gumby: ***uming you are executing an sql query....
<12> mikere: yes, thats what I am looking to do.
<9> !m Gumby update
<14> Gumby: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<10> there we go
<9> Gumby: of course, values shouldn't really be duplicated, that's why you normalise a schema.
<10> alright, last question. I have my API none are showing in my mgm show.
<10> so, I'm thinking I've misconfigured something somewhere.
<9> cloaked: yes, have [API] blocks in the config.ini. as many as you have mysqld servers
<10> Yeah, I have 4 of them
<10> and mgm show shows that I have 4 available but none connected.
<9> HarrisonF: who was it with, apress or pearson?
<10> but I have two up and running.
<11> arjenAU: pearson via mysql press
<9> cloaked: that could be a fact. did you enable ndbcluster inside the mysqlds?
<9> HarrisonF: ok cool. how was Alex?
<10> doh! That's what's wrong...no db's using the engine. Hehehe.
<10> thanks arjenAU
<9> cloaked: show engines
<4> what does it means in dumped file this /*!40101 SET NAMES utf8 */;?
<10> hrm
<4> did mysql dump with utf8 code?
Return to
#mysql
or
Go to some related
logs:
#physics
#web
#debian
Config.wtf wine
bcm43xx modprobe.conf arguments
why linu8x?
#debian
ctorrent keyword masked
seatspace
#physics
|
|