| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> Riis: select * from mysql.db where db = 'wordpress';
<0> you'll see it in there
<1> I see also old files proc.MYD and proc.frm , how I can read them ?
<2> napnap: ib_logfiles are innodb log file, not mysql binary log
<1> lokus, yes but a way exist to read this file ?
<2> napnap: the proc.frm proc.myd is used to hold the procedures you create, when you drop it, it will be removed from this table
<2> napnap: the procedure in not in there anyway
<1> lokus, ok, but I see a backup of my directory with old proc.* perhaps this files contains my procedure
<1> but I don't know how read this files
<3> hi
<3> i need help
<3> i forgot my mysql p***word :-(
<2> napnap: restore in into a newly created database
<2> !m jzono1 reset p***word
<4> jzono1: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<3> any way to completely purge everything ***ociated with mysql?
<3> thanks
<1> lokus, not procedures in it :-(
<1> lokus, and for ib_logfiles are innodb log file, I can read them or not ?
<5> Will this query work properly?
<5> SELECT COUNT(*) FROM user_accounts WHERE UserName = 'User' AND P***word = 'P***' AND AccountType = '1' OR AccountType='2'
<5> Will it search for matching user/p*** and either one of those accounttypes?
<5> What if it's AccountType=2 but the username is different?
<2> napnap: not really, unless you know the internals of it, and procedure is never store there, and these logs are reused, it is only for the running of innodb to hold commited data that has not been written to disk yet
<2> jbrimble: using paranthesis will better show the precedence
<1> lokus, I know, I hope just , it is all that it remains to me :-(
<2> jbrimble: what is 2 * 3 + 4, 10 or 14 ?
<5> ah, true
<5> so parenthesis around the accounttype section
<2> napnap: try to make a copy of the proc.myd and open this copy with an editor, hopefully you can still see it there
<2> napnap: it is usually mark deleted, so if the space has not been reused, you may be able to get the procedure back
<1> lokus : yes the proc is in it !
<2> napnap: copy the text and recreate it
<1> lokus, BIG thanks
<6> g'day all
<5> hey inzanez
<6> Hm,...I got a database with about 6 tables, linked via foreign_keys. Now I _must_ change all primaryKeys from "char(32)" to int,..
<6> so I also got to change the foreign_keys and their values,...is there an "easy" way to do that? :)
<6> The only idea I had is to setup a new database, read the old one out via php, modify the entries and write them to the new database...
<6> I do not want the data get mixed up :)
<7> i have create a user in mysql admin utility but if I want to use the commandline option I get a beep it gone
<7> and how configur mysql on ISS
<8> uh, *stares at bennie and segfaults*
<9> hi
<9> I got two tables: table1 and table2. table1 got this columns: number,name. table2 got this colums: groupnumber,t1number,somecrap ||| I need a select query that selects all table1.names from table1 where table2 got table2.groupnumber=100 and table2.t1number=table1.number
<9> mysql 4.0 (no nested selects)
<7> how to link each table
<9> t1number and number
<10> have you tried with JOIN .
<10> ?
<9> i'm a sql noob
<9> always fail when it comes to join
<9> could you give me a example how to join these 2 tables the way i'd need it please ?
<10> ok wait
<11> hi
<11> table2.t1number=table1.number
<11> what do u mean with this
<11> o yes i got it:)
<9> i mean table2.t1number should be the same as table1.number
<11> try this
<10> http://www.rafb.net/paste/results/joOgza78.html
<10> this can work
<9> thanks *trying*
<10> ;)
<12> Hello. I'm trying to set up replication. In the slave, the instruction CHANGE MASTER TO MASTER_HOST='venus',MASTER_USER='repl',MASTER_P***WORD='xxx',MASTER_LOG_FILE='mysql-bin.000032',MASTER_LOG_POS=1613; gives me an error of; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log. The log file says this: 060302 13:12:18 [ERROR] Failed to open the relay log './venus-relay-bin.0
<12> 00001' (relay_log_pos 4) 060302 13:12:18 [ERROR] Could not find target log during relay log initialization
<11> SELECT * FROM table1,table2 WHERE table2.groupnumber=100 AND table2.t1number=table1.number
<13> Error
<13> MySQL said:
<13> #2003 - Can't connect to MySQL server on 'localhost' (10061)
<13> need help
<10> ZaLeX_, your querie work too BUT if there is no table2.number is displays nothing
<14> is_true("spice girls" == "good"); --> uncaught FILE_NOT_FOUND exception
<14> hmm, one right arraow oto much
<10> it depends on what Konky^futtern wants
<11> table 2 does not have a number field
<12> (4.1.12) myisam
<13> please help me : #2003 - Can't connect to MySQL server on 'localhost' (10061)
<12> bl4ck: what type of connection are you doing? over tcp/ip or over unix sockets?
<10> ZaLeX_, choose maybe another name to your column number because as you can see in the paste, "number" seems to be a keyword
<10> ZaLeX_, i've no table2.number in my querie, i've " ON table1.number = table2.t1number "
<13> anv , i istall apache,php & mysql with winlamp on windows xp sp2
<11> i insist that it will give the same result
<11> ley me try it on access
<2> BL4CK: is the mysql server running?
<9> i think it works, thank you ;)
<11> give me a minute
<10> np :p
<11> which one worked?
<10> ZaLeX_, the two worked
<13> phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and p***word in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server. | Error | MySQL said: | #2003 - Can't connect to MySQL server on 'localhost' (10061) |
<13> C:\Apache2\mysql\bin>mysql
<13> ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
<2> BL4CK: windows? check the task manager, any mysqld* in the process list
<12> bl4ck: then... you must not be using unix sockets... I don't know if in windows there is something similar... but if your are using tcp/ip, the problem may be you has the option "--skip-networking"
<10> mysql -u root -p base
<13> lokus , i see mysqld.exe
<13> jessy , i get error for that
<13> anv , how ?
<9> zalex_: my bouncer is crazy (nickchange imopssible) and unregistered users can not send privmessages (can't answer you)
<9> both work, thank you
<11> np:)
<15> hello
<11> hi
<11> :)
<15> I have instaled mysql 5.0.18 and I am trying to setup apache to work with it
<10> BL4CK, that's i'm using under linux, base = the name of my mysql base
<15> I also installed php 5.1.2 which works fine
<15> and when I start up apache it doesn't give me any error
<15> but I don't think mysql is working
<15> don't I just have to install it and apache will know it's there?
<2> BL4CK: try from a command prompt telnet localhost 3306
<10> ZaLeX_, what's the error that you've got with my querie ?
<2> BL4CK: try mysql -h127.0.0.1
<10> ZaLeX_, the only one you can get it's with the groupnumber, if the groupnumber is defined in table1 too, you have to wirte table2.groupnumber = 100 even if mysql don't know if you want the one from table1 or table2
<11> the access give an error that i can not translate into english
<11> :)
<12> bl4ck: the options are what you include in the command-line...
<13> tnx all . mysql running :D i read this in mysql.com : mysqld --remove ,then : mysqld --install ... and then net start mysql
<13> http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html -- in user comments
<16> quick Q: How to write a query to return the last 200 rows of a table. Last = last unique IDs values
<17> something like ORDER BY id DESC LIMIT 200 ?
<17> I have 2 indexes (a,b,c) and (c,a,b). I'm doing a search for
<17> c and a, but it seems to be just using the first index (which doesn't really narrow it down much) and ignoring the second (which would pinpoint the number of rows nicely)
<17> and so is doing an ALL scan
<17> I've tried USE INDEX (c,a,b) but the explain select returns no rows, and the actual select tells me that Key Column 'c' doesn't exist in table
<17> any suggestions?
<16> osfameron, thanks for the suggestion, I want normal order. Infortunately I can't help with your issue
<17> antirez: you could do where id >= (select min(id) from table order by id desc limit 200) ?
<17> or something along those lines
<18> i forgot the username i defined for using a database, how can i find out about it, cause i do not want to work with root user all the time
<16> osfameron, I think I don't have subqueries support in my old mysql...
<16> (and I can't change it unfortunately)
<17> ah, then do a select to find the minimum id, then send it to the next query
<17> anyone got any suggestions for the index?
<17> I know! I'll go and ask my friendly neighbourhood DBA, but I'll gratefully read suggestions in the scrollback
<18> so no one can tell me how to find out which user is ***igned to a certain database?
<2> ratschnowski: there is no such things in mysql
<2> every user can access whichever database he got privilege on
<19> hmm, I'm making a signup form, instead of sending an activation e-mail I was thinking of giving an activation key immideately so they can copy it and go to an activation form. Now, I have to store this information in another table than the usual user-table, should I use a temporary table or something?
<17> isn't there a users table or something?
<17> yeah, 'use mysql'
<17> 'show tables'
<20> naa, you can use show grants
<20> show grants for root@'localhost';
<17> aha, even better :-)
<20> there you can see all grants given to that user, and therefrom you can see what databases/tables user is ***igned to.
<18> lokus: i know, but i need to get the user, i forgot the user! i can access as root, but i need the user of this certain database
<17> ENODBA
<18> lokus: i just need to find out the owner of a certain database, so the user with privileges on it
<17> well select db, user from db; seems to do something for me
Return to
#mysql
or
Go to some related
logs:
OpenSuse Disable PowerSaver
bcm4318.inf
#perl
gentoo mdns off
Access denied for user 'db_user'@'localhost'
#ubuntu
mount *** glibc detected *** free(): invalid pointer
python argument after * must be a sequence
xmms-mpeg123
tell which version of ubuntu
|
|