| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> NeoThermic: kind of.
<0> NeoThermic: you may just call 'mysqladmin shutdown'
<0> ;-D
<1> is it neccessary to define the default values for every column (i.e. to NULL or "")?
<0> in case of strict mode your inserts would fail if there're no proper defaults and you do not supply variables.
<0> but that is what you may want... though
<2> peqe: thanks for that :D
<1> is there a way to say that a column in table A is the same thing as a column in table B, and if so, is there an advantage to defining that relation?
<3> domas: I'm trying over and over again to change the master, but i still get the same error 'Access denied for user 'ssl'...
<0> dimi3: did you specify certificates for client? did you specify certificates for master? do you have ssl on both?
<3> domas: I can connect on the master using mysql with client certificates with the same 'ssl'@'caffeine' I'm trying to setup replication. Do I have to setup in the CHANGE MASTER the server or the client certificates?
<3> domas: on the slave, in /etc/my.cnf I have setup in [client] the client certs.
<0> dimi3: WRONG!
<0> dimi3: mysqld does not care at all about [client] section, it's for client programs, like mysqldump, mysqladmin and mysql
<0> dimi3: put it all in CHANGE MASTER.
<3> domas: my change master is as : http://bultis.net/slave.txt
<0> dimi3: should I lart you now
<0> or will you fix your mistake?
<3> domas: I don't get what's my mistake! :(
<0> MASTER_SSL=1
<3> domas: really?
<0> MASTER_SSL_CIPHER is wwrong
<0> ssl cipher is not 'p***phrase'
<0> it's encryption algorithm
<0> you should be safe with defaults
<3> ok, what should i put there?
<3> so i don't put anything there?
<0> and master_p***word is where you place p***phrase
<0> anyway, http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
<0> I won't hand hold you more
<3> domas: thanks :)!
<0> get mysql support! :)
<3> i should!
<0> you should!
<0> damn, so many of them
<1> how do you reset an auto incrementing column?
<0> alter table
<4> hi all
<0> hi
<4> for some reason, any mysql function, like conv() for eg always gives error "FUNCTION test.conf doesn not exist"
<4> like it's looking from the database
<4> am I missing something?
<0> conv does not exist then
<0> :)
<4> damn
<0> if there's no global function, then local is used.
<4> I see. I thought it was always included
<4> can I get it somewhere? :)
<4> or is my mysql maybe just misconfigured somehow?
<4> I'm trying to migrate my phpBB priv msgs to punbb
<4> and for the ips I'd probably use "SELECT inet_ntoa (conv (privmsgs_ip, 16, 10)) FROM phpbb_privmsgs;"
<4> but I don't have any of the functions. :)
<4> oh wel..
<4> the reason I ask is that this is a fresh official 5.0.18 install. so are things like conv () something that have to be installed separately?
<5> Hi
<4> hi sahithya
<5> i'm having 2 records of the same type in a table, now i want to delete the record that comes second time
<5> how to do it
<4> sahithya, does the second entry have a unique id?
<5> no
<5> No filipp
<4> ok, then it's beyond me. :)
<4> srry
<4> there's surely a way
<5> ok
<5> Can any one give solution to my problem
<4> sahithya, can you use a DB client, like phpMyAdmin?
<4> ie something graphical. :)
<4> and then You should maybe set that field to be unique, so You don't run into this situation anymore?
<5> filipp, there situation is like i can't set any of the field as unique there
<4> ok, you probably have to remove the duplicate entries first?
<5> All the value in a field may come more than once
<5> ok i got it i think i can't delete first entries here
<5> using LIMIT option in delete
<4> yes
<4> but how do you know which one you're deleting then?
<4> ORDER BY something?
<5> NO
<4> ok
<4> srry, I'm a bit confused. Seems to me you might have a design bug in your schema.
<5> in this case i have to delete first 20 rows
<4> ok. gotta run now. bye!
<5> Here first 20 and last 20 records are of the same type
<6> how can I check what alarms are active in MySQL
<7> hi
<0> phpboy: alarms?
<7> I want to list all users in my users table that have a lastname that occurs multiple times, but i can't seem to get the correct query, something with my GROUP BY is wrong, any idea? http://rafb.net/paste/results/uDcbfN28.html
<0> select * from users group by lastname having count(*)>1
<0> then join to that
<0> :)
<6> domas: In my error log I have "Active Alarms: 1"
<6> I can't seem to connect to mysql remotely
<6> well... not prperly atleast... it takes long to connect remotely
<6> :<
<0> phpboy: 'takes long' - investigate your dns environment
<0> Alarm is just a way to notify process/thread about some event
<6> domas: it's on a LAN and I'm connecting to the IP
<0> reverse dns...
<8> hello
<7> domas: Thx, but can you give me a hint how to put the JOIN into that?
<6> domas: the nameserver that hosts the reverse records is also on the same LAN... I connect to many MySQL servers on the same LAN... they all work properly accept for this one
<9> where is better to ask about mysql++
<6> domas: I'm using a 4.1 client to a 4.0 server
<6> could that not maybe be the problem?
<0> no
<0> I told you were to look for issues.
<6> I double checked the obvious
<6> DNS is working 100%
<6> that I am sure of
<10> How do I determine the no. of rows in a table?
<11> hello
<12> hello every one
<12> i am trying to grab data from master host
<12> but i get this error
<12> mysql> LOAD DATA FROM MASTER;
<12> ERROR 1219: Error running query on master: Access denied. You need the RELOAD privilege for this operation
<12> any one help me with this issue
<12> can some one help me
<12> ?
<13> hi
<14> hello
<13> i have some charset issue..just upgraded my mysqlserver and all the s got wrongly displayed. (A+'on it)
<15> hey
<15> whats the diff between InnoDB and MyISAM
<13> Any idea which charset setting should be changed?
<16> innodb tables support transactions and row level locking
<15> which is "faster"
<16> see the docs
<16> I think it depends on what you are doing
<15> mysql/php driven gallery
<17> if I have a column that's a datetime, how can I find all entries that have that date... SELECT * FROM `normal_events` WHERE start_date = "2006-02-14" only gets me that exact date, with the time 00:00:00
<18> i have already instal my sqld ... i check it running
<18> how i can create the data base
<18> any want help me
<17> Fedoracore6, uh... 'create database <name>;' then grant privledges... there will be a manual in your language.
<19> !m fedoracore6 tutorial
<20> fedoracore6: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<18> thank you hehhehe
<18> i wanna do agi script ... link in database mysql ...
<18> wanna have are ... example ... can i follow
<18> i wanna do touch tones system ...
<18> root@localhost ~]# service mysqld status
<18> mysqld (pid 2239) is running...
<18> its that ny sql is running
<18> its that my sql is running
<21> hey friends, does any one know how i can enable mysql connection from php? i use debian and i think i installed everything but phpinfo still says '--without-mysql'
<18> where i can put in my data base i have 3 fail myi
<22> //server -m irc.chatw.net #chatw
<23> Oracle = Evil now ?
<24> now?
Return to
#mysql
or
Go to some related
logs:
ubuntu sourcelists
#perl
#iptables
losetup -d ioctl: LOOP_CLR_FD: Device or resource busy
#debian
kunbuntu NDISWRAPPER
#linux
#php
gyach quits
#centos
|
|