| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> *should*
<1> worth a shot
<1> Darien, it only seems to be one database........ and that was working fine on 4.1 before on 2 different servers
<0> you mean one table?
<1> Darien, nah whole database
<0> w33rd
<0> maybe it's InnoDB?
<1> nah, myisam for sure... there's one memory table too
<2> hey
<2> how easy would it be to search a database and search for key words and give you a count of them
<0> you could search a *table*
<1> Darien, errors gone, data gone.... Table 'thread' is marked as crashed and should be repaired
<0> so repair it
<1> Darien, how can I repair all tables in a db ?
<1> there's like 700 in this db
<0> !m scott mysqlcheck
<3> scott: (Overview of the Client-Side Scripts and Utilities) : http://dev.mysql.com/doc/mysql/en/Client-Side_Overview.html
<1> thanks
<0> try mysqlcheck --all-databases --auto-repair --use-frm
<4> or mysqlcheck
<4> yeah
<4> why --use-frm?
<0> just in case :p
<0> it's not actually necessary
<0> but if you have a problem relating to the myi header, try it
<4> . Note: Use this mode only if you cannot use regular REPAIR modes. .MYI header contains important table metadata (in particular, current AUTO_INCREMENT value and Delete link) that are lost in REPAIR ... USE_FRM. Don't use USE_FRM if the table is compressed because this information is also stored in the .MYI file.
<0> neat
<0> be nice if they said that in --help
<1> Darien, error : Can't create new tempfile: ...
<0> the whole error?
<1> that's it on the repair, the tablename is after that
<1> error : Table './db/vb3_attachment' is marked as crashed and last (automatic?) repair failed
<1> -rw-rw---- 1 mysql mysql 0 Mar 5 22:11 vb3_user.MYD
<1> -rw-rw---- 1 mysql mysql 1.0K Mar 5 22:13 vb3_user.MYI
<1> Darien, backup worked. ugh
<0> ouch
<1> another reason to setup replication maybe
<1> means another 10 more servers though
<5> I've been looking aimlessly for this, but haven't found anything; thought I'd give it a try over here. Does anyone know if there's anything similar to what Oracle can do in terms of message-p***ing and / or blocked triggers, in MySQL? What I'd like to do is call a stored procedure, and wait for an INSERT or UPDATE on a given table to occur before the stored procedure ends.
<1> 17 hours data... fortunately it was only a game and nothing too important
<1> well just checked, everything else seems fine. hmm, that was weird
<6> ive been looking around and i cant figure out how to make a timestamp look like YYYYMMDDHHMMSS, got any leads for me?
<0> !m blobaugh format
<3> blobaugh: (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
<0> hmm
<0> !m blobaugh date_format
<3> blobaugh: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<0> yay
<0> second time's a charm
<6> heh, ok ill try that one i havent looked at it yet
<1> hey, does anyone know if it's possible to replicate mysql on the same system? instead of remotely
<0> sure
<1> that might be work ok for now then
<7> hi guys, which version should i use for production?
<1> that might be ok/work ok for now then ;-)
<5> Hmm. I guess that. I'm looking for a way to see if a table has been updated, without continuous polling. Is that possible in MySQL 5? Anyone? (:
<8> triggers
<8> ?
<0> triggers
<0> !m jasper_ triggers
<3> jasper_: (Triggers) : http://dev.mysql.com/doc/mysql/en/Triggers.html
<5> Darien: Yes. (: But how, from a language like PHP, do I detect if a trigger has been fired?
<0> jasper_: when a trigger is triggered, put an event into a separate memory table and then have your action server or whatever poll that table
<2> hi, I am getting his error Resource id #3 from http://pastebin.com/585841
<2> any ideas ?
<5> That's what I was thinking too, but I was hoping there would be a cleaner way. (:
<5> Sounds like I'll be going for that then; thanks Darien.
<0> you can't trigger external code from within MySQL
<5> Darien: Yes; but if it were possible to have a trigger send a message to another thread within MySQL .. Oracle does something like that with RDBMS.SEND_MESSAGE, etc.
<5> Then I could have a stored procedure wait for a message from a trigger and wait for the stored procedure to finish in my application.
<6> ahha! CURRENT_TIMESTAMP + 0, sheesh Darien i should have just asked first cause i never found that page, thanks
<9> Is there a way to join a table with a subselect?
<10> kippi, that's not an error, you just haven't fetched any row(s)
<2> blobaugh: how would i do that?
<2> I tired $result1=mysql_fetch_***oc($result);
<2> but got a blank page
<10> you need to do something like $row=myql_fetch_***oc();
<10> then echo $row['somefieldname'];
<6> so where would one find the meaning of the resource errors? ive looked but i cannot find
<0> what resource errors?
<11> Sharcho: put the subselect into table position ",(...) as foo", then use it's results the same way you're using columns from a table.
<11> Be warned that mysql might not optimize subselects intelligently.
<11> s/subselects/queries with subselects/
<12> Sharcho: It's called a 'derived table'. MySQL supports that just fine. It's usually the suggested form.
<11> well, "just fine" might be a bit of an overstatement. I've run into speed problems the first time I'm using subselects.
<11> with mysql 4.1 (maybe 5.0 is better?).
<13> ok. I am trying to create an SQL database on a computer through SSH
<13> mysqladmin -u mysql create forums
<13> mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost'
<11> -u mysql probably doesn't exist, Koharski
<11> maybe you've meant mysqladmin -u root create forums
<13> yeah, that works
<13> thanks
<13> ^_^
<2> SELECT count(disposition) FROM cdr WHERE 'ANSWERED';
<2> why is that brining me back 0
<2> when there is at lease 5 counts of ANSWERED
<10> 'ANSWERED' is the value in a column?
<2> yep
<10> you need to say which column e.g. WHERE colname = 'ANSWERED'
<2> so SELECT count(disposition) FROM cdr WHERE 'ANSWERED';
<2> opps
<2> so WHERE disposition = 'ANSWERED'
<2> working
<10> yes that's the idea
<14> if yuo accidently deletes rows from a myisam table... is there a way to retrieve those rows somehow? can myisamchk be used for this in one way or another or are there any hexvalues you could alter in the MYD file ?
<15> yes .. from your backups :-/
<14> i think i have seen some way but i forgot the method
<14> perhaps i should tell that its not for me, its for a question on forum.mysql.com
<15> well if you did it inside a transaction you could rollback
<14> i thought that myisamchk -e would help this guy but obviously not
<14> lsmith: myisam doesnt support transactions
<14> http://forums.mysql.com/read.php?21,73723,73941#msg-73941
<15> well .. if you want to go hardcore at the problem
<15> the data will probably not yet have gotten overwritten
<15> i dont remember the exact myisam internals .. but i doubt it does more than mark the rows as deleted
<14> $ myisamchk -e weatherdata
<14> Checking MyISAM file: weatherdata
<14> Data records: 0 Deleted blocks: 839435
<14> obviously myisamchk can "see" these deleted rows, so why cant it retrieve them ?
<16> DCC SEND "(#MATH-SAYS_****_YOU-#MATHSAYS_****_YOU-#MATHSAYS_****_YOU)" 0 0 0
<17> if i have a column that's set to datetime and I wanna just match for the day and not the time, do I need to use LIKE or is there a better way?
<10> WHERE date_format(datetimecolumn,'%Y-%m-%d') = 'somedate'
<17> thanks
<10> np
<18> Viper007Bond, LIKE works better.
<19> Viper007Bond: split the col into separate date and time cols if you need to search like that. otherwise queries will be slow. the above solution can't use an index
<19> and actually will makes a good point. for this particular case LIKE would actually be able to use an index
<10> I stand corrected
<18> bobfield, It's the effort that counts ;)
<20> bobfield is my hero
<10> my fan club is still rather small
<20> you have a big fan here
<10> well I try
<10> can't please everyone
<20> on 2 occasion you've pulled it out of the bag
<20> for me
<10> solutions are divided into 'works' and 'optimal'
<19> bobfield: define works... a) syntactically correct or b) provides the result this year given a reasonable size dataset ?
<10> getting it to go from point A to point B is a major part of the battle in my book
<10> now with 10 million rows may be a different story
<10> but I do try to listen and learn
<20> your my hero
<10> well I've still got a lot to learn yet
<10> but I'm not afraid to take a stab with what I do know
<20> you pulled it together for me so I'm made up
<21> is there a version of SUM() that can be used to sum multiple rows even if I use GROUP BY?
<2> with mysql is there away to work out the average from a list of numbers?
Return to
#mysql
or
Go to some related
logs:
lazellama
+ubuntu+alacarte +sudoer
#web
rpm ragnarok server repos -hardware -hard -ram -rom
#qemu
perl remove ANSI escape sequences
eternal_drake
#centos
v200z ndiswrapper wireless
lufsmount ping
|
|