| |
| |
| |
|
Page: 1 2
Comments:
<0> hi
<0> #1005 - Can't create table '.\tp\affecter.frm' (errno: 121) << do you this problem ?
<0> do you know this problem ?
<1> can somebody help me... my MYSQL wont start... pls PM me
<2> how can I automate the PURGE MASTER LOGS command without perl/php ?
<3> without those 2 or any script language ?
<2> well, without one that makes usage of a Perl/PHP module that interacts with the mysql libraries
<2> so no DBI/dbd
<2> maybe even a way to execute a simple mysql script
<2> but I'm not sure how to supply the p***word automagically
<3> allow access from root on localhost with grant syntax ?
<2> yeah, maybe something like this: mysql -u root -p < cleanup.sql
<3> sure
<2> and cleanup should contain something like: use mysql; purge master logs to 'date'
<2> but how do I input the p***word ?
<3> you can allow root on localhost to connect p***wordless.
<2> yes but that's not a very good idea
<3> why not ? :)
<2> good question :)
<3> I mean, if someone is able to get root access on your box....
<3> well, nuff said.
<3> can you be sure your replica will have the logs you will be purging ? if you want to automate it using dates...
<3> maybe you are better of purting to a certain filenumber.
<2> that's the thing
<2> i'm not sure if the slaves still require a certain log file
<2> so if I go by date and only remove log files which are 1 month old
<3> you can do SHOW SLAVE STATUS /g;
<3> and get the binlogfile variable.
<3> then purge to the file before it and you are safe, I think.
<2> I'd have to do that on each slave
<3> ah right
<2> hmm, if I would have went straight to the mysql page...
<2> 0 9 * * mon mysql -uroot -e "PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 31 DAY);"
<3> you could do that
<3> and have something which notifies you of slaves running late.
<3> then you are safe enough right. or do logging on the slaves as well :p
<2> i just turned off the logging on the slaves - lol
<2> my guess is that there should be no reason for a slave to request stuff from a bin file 90 days ago
<3> I agree.
<3> I do it manually.
<2> well, this is strange
<2> to this command, I get an error
<2> PURGE MASTER LOGS BEFORE DATE_SUB( NOW( ), INTERVAL 62 DAY);
<2> You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEFORE
<3> not before
<3> TO
<3> iirc.
<2> the TO is for file names
<2> PURGE MASTER LOGS TO 'file-name.010'
<3> ah ok.
<4> What's a reliable/standard php/mysql webmail package?
<2> horde ?
<5> hi there everyone
<5> can anyone help me with a rule to select duplicates?
<5> like something i have select * from dt_profile where id='1669' i would like to select all rows and duplicates
<6> well, that would return everything with and id='1669'
<5> that only displays 1 row
<6> then there is no duplicate id
<6> which is probably good
<5> anyone here knows how i could calculate a birthday with mysql?
<5> something like SELECT * FROM dt_members WHERE gender='Female' AND looking_for='Male' and today is like user.birtyday ?
<6> you mean calculate the age?
<6> birthday is a constant
<7> beebum: http://www.kfwebs.net :(
<6> hrm
<7> of course I have it all backed up, but it require a rewrite if I want to use it on the other server
<6> well, if that admin guy would get off his duff and do something... ;)
<7> hehe
<7> it is 700km away from me, I'm directing people per telephone
<8> can anyone tell me what kind of softwares using some sites...!
<7> huh?
<7> IceEyes: http://www.catb.org/~esr/faqs/smart-questions.html might increase your chance of getting a, in your perspective, positive response.
<6> heh, i think he's looking for netcraft or something
<7> really?
<6> i think
<7> I can't read that out of the statement
<6> i've been dealing with statments like that for a long time ;(
<7> hehe
<9> is the command: PURGE MASTER LOGS BEFORE 'date' still in use ?
<10> how can I order columns in a HTML table by clicking at the topic (ASC, DESC)? I am using MySQL with PHP.
<7> and that is related to mysql just how?
<9> it probably uses mysql somehow :)
<7> probably use power somehow as well, I don't see him calling the power company
<11> ha
<9> rofl
<12> well he might somehow asign an id to what he made there with his columns and use myqsl somehow to order `em
<12> :)
<12> mysql*
<7> his question is a PHP && HTML && Logic question
<12> eXactly
<12> :)
<13> HI
<13> i got an existing table with data on it
<13> i missed one column data for my table and i want to insert this column - how can i do it?
<6> alter table to add the column, not sure what's the best way to populate the column
<13> yeah thats my problem also
<13> if i will insert the column the columns will move right?
<13> what about if i will put a default column valu for this added column?
<6> i think you can put the column where you want
<13> yes
<13> can you give me the correct syntax then
<14> http://dev.mysql.com/doc/refman/5.0/en/alter-database.html
<6> heh, i was just about to paste that ;)
<14> or http://dev.mysql.com/doc/refman/4.1/en/alter-database.html
<6> actually
<6> 13:43 <13> yeah thats my problem also
<6> 13:43 <13> if i will insert the column the columns will move right?
<6> 13:44 <13> what about if i will put a default column valu for this added column?
<6> 13:44 <6> i think you can put
<6> oop
<6> http://dev.mysql.com/doc/refman/5.0/en/alter-table.html
<6> ok, that
<6> s what i meant to do
<6> sorry for the hickups
<6> heh, surprised i didn't get kicked for all that nonsense
<13> ok
<13> so alter then insert a value for the new column
<6> you have to alter the table so the column exists and then you have to put the data in the column
<13> yea
<6> not sure the best way to match it all up
<6> i could figure out an ugly way to do it but i'm sure someone else knows the 'right' way to do it
<13> ADD [COLUMN] column_definition [FIRST | AFTER col_name ]
<13> then i can add more condition to that sql right?
<6> yes
<13> ADD [COLUMN] column_definition [FIRST | AFTER col_name ]
<6> well you have to pick one
<13> this is more related that alter right?
<6> alter table add column after column...
<13> then
<13> i can insert a value for this new column is that right?
<6> yes
<13> ALTER table_users ADD middle_name AFTER last_name;
<6> how much data do you have?
<13> over 2000 records
<6> you have to define the column
<6> did you just populate the table for the first time?
<13> i have them for years
<6> ah, do you already have a set of data for this new column?
<13> not yet
<6> ok
<13> i just need to default them to 0
<6> ALTER table_users ADD middle_name column_definition AFTER last_name;
<13> definition?
<6> char, varchar, ...
<13> varchar(15)
Return to
#mysql
or
Go to some related
logs:
#AllNiteCafe
#MissKitten
#skype
#asm
zotzy
#c
Z-EL DIVO
mysql nhost is not allowed to connect
nun eats priest shit
#c++
|
|