| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> where u from Todo
<1> eurcolhfe: San Antonio
<0> is a city in usa
<1> eurcolhfe: yes, in Texas.
<0> i think you in midnight now
<1> yes
<1> I work nights at Rackspace
<0> is that rackspace that company givien dedicated servers
<1> yes
<0> i have provide a tecnical support one sever in rackspace
<0> 3 years ago
<0> for a client from sri lanka
<0> those days charge 200 dollers per month for a linux server
<1> eurcolhfe: was the server in in our UK or USA datacenter?
<0> in usa
<1> eurcolhfe: we may have spoken then. I've been with RS for almost 6yr.
<0> rackspace have good customer service
<1> :)
<1> It's only gotten better over the years. Some of the new guys are really good.
<0> me now work for norway IT company operated in sri lanka
<2> isn't sri lanka in a civil war right now?
<0> no civil war
<3> not officially, but they might as well bee
<3> considering that the Tamil Tigers are a significant portion of the population
<3> :p
<2> rawr
<3> stefan: WTF ?
<3> hospital ?
<0> here now 1am i will back
<0> my email is hiranf@yahoo.com
<4> When I'm trying to install DBD::mysql it says it can't find mysql.h although I have it in C:\mysql5.0.18\include ?
<5> hi
<5> hw to take mysql dump without datas
<6> beeps: --no-data
<6> beeps: mysqldump --help | grep data
<7> hi, all
<7> what front end for mysql do you people use?
<7> like phpmyadmin or toad/
<5> xgc:i want no data for few of the tables
<7> beeps, what do you mean?
<5> i want a database dump without data for few tables
<6> beeps: You can dump a specific list of tables. If you want to dump some tables with data and some without, just issue two separate mysqldump commands with separate lists of tables for each.
<8> Hi
<9> kosmonaft: do you have to specify which directory to find mysql.h ?
<6> shakil: Toad for MySQL, MySQL Query Browser, MySQL Administrator, MySQL Workbench.
<10> hey guys
<10> when i create a database i get error msg?
<10> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'databasename'
<8> im trying to add a table
<8> to my database
<8> and i keep getting this error :: http://hashmysql.org/paste/viewentry.php?id=1455
<9> kulbir: no privilege as the error message stated, you are the anonymous user
<10> when i try as root ,i get same error
<7> Xgc: what is MySQL workbench for?
<10> when i try as root or kulbir,its asking p***word.
<8> anyone know the answer to my question?
<10> fuzz, sorry no
<11> fuzz: PRIMARY KEY ( id, id )
<10> fuzz, u know the answer to my qes?
<11> fuzz: Such PK makes no sense.
<7> <5> you dont need to issue two separate mysqldump command to achieve it
<7> <5>i am talking at personal window of yours
<11> fuzz: Also note that once you have PK(id) second index on it is completely redundant
<8> well i changed it to
<8> (id)
<11> kulbir: You are trying to connect as anonymous user which is not allowed to use database 'databasename'
<8> it worked, but will it cause problems?
<11> fuzz: ?
<8> i changed it to PRIMARY KEY (ID)
<11> fuzz: PRIMARY KEY (id) means MySQL will make sure id is always unique
<10> salle, then how can i connect?
<8> what does (ID, ID) mean?
<11> fuzz: And if all values of id are unique all (id, id) will be also unique. That's why it does not make sense
<11> fuzz: ?
<11> fuzz: It is in your CREATE :) http://hashmysql.org/paste/viewentry.php?id=1455
<11> kulbir: Use user name which is allowed to connect from localhost and provide the proper p***word for it
<8> w00t
<8> got it thanks a lot salle
<10> salle, sorry,which user is allowed to connect for localhost?
<11> kulbir: Ask the database admin :)
<10> im admin.
<10> salle, ok tell me
<10> salle, when i type this <mysql -uroot -p> its asking for p***word
<11> kulbir: Do you expect me to tell you what users are allowed to connect to my servers? :)
<10> yes
<11> kulbir: Are you kidding?
<10> salle, nope
<10> this is first time im using mysql
<10> :(
<11> kulbir: And why should I allow you accesing the machines at my home?
<11> kulbir: Hm. If it's the first time you are using MySQL you should definitely go to the Manual
<11> !m kulbir adding users
<12> kulbir: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<10> ok my dear
<10> BTW thanks
<11> kulbir: Never heard MySQL has Manual? :)
<10> salle, r u joking with me? :((
<11> kulbir: Is it your MySQL server or you are connecting to MySQL installed by someone else?
<13> hey question how do you Explain or Test a query before actually executing it? What do you put in front of the query and what not
<3> salle: some people think "manual" refers to a type of ***ual gratification
<11> kulbir: No I am NOT joking!
<10> i want to use wordpress,so i need mysql to create a database,nothing else
<11> kulbir: There are lot of chapters in the MySQL Manual explaining how to install it and how to connect to it for first time and how does MySQL Privilege system works
<13> anyone
<11> kulbir: Well if you just want to do some shopping with your car you still need to learn how to drive it
<3> I am "anyone" and "noone" depending up the circumstances
<3> what aku /
<10> lol
<10> salle thanks
<3> no test mode for MySQL queries to my knowledge
<10> salle, where u from?
<11> kulbir: Bulgaria. Why?
<10> salle, bulgaria???????
<13> oh ok
<13> thanks anwya
<11> kulbir: Yes. There are human beings living in Bulgaria you know :)
<10> salle, no
<14> you're kidding
<11> SpComb: I know some people will disagree with that statement including some of my Finnish friends :)
<11> kulbir: Since you are newcomer to MySQL world you better start with the Tutorial you can find in manual. The first chapter there is labeled: 3.1. Connecting to and Disconnecting from the Server
<11> kulbir: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
<3> I knew a very nice girl in Sophia on ICQ for a good while
<3> Bulgaria has some Hot Chicks(tm)
<3> :)
<11> kulbir: Trying to deal with MySQL without taking look at the manual first is proved to be huge waste of time
<11> Sneaky_Bastard: I could agree with you if my wife wasn't around at the moment ;)
<15> hi all. I have a little problem (or not little :) ). Sometimes (after a few queries), there is an error "Table '.' doesn't exist" on query "select * from globals order by id desc limit 1"
<15> server version is 5.0.12
<15> this error dissapears only after server restarts.
<15> and come back again after few queries
<10> salle thanks
<10> my friend
<14> away away away?
<14> wow, he must be quite away
<9> cpas[sql_mode]: try upgrading, 5.0.12 is beta
<10> SpComb, yes
<15> lokus i try 5.0.17 and 5.0.18. It has another error (on insert "no data to fetch"). i asked about it yesterday
<16> hi
<16> can someone help me? i have a table with a lot of integer columns and i need to change every >0 value to 1 (so basically it will be a binary exists-doesn't exist table). how do i refer to a column asa variable in the update query? or there's some other query i should use?
<17> good morning
<18> hi, i'm trying to drop my databases on my server, but when i login at root it won't let me login to mysql, and when i try to drop without going into root it says i don't have permissions
<17> Ainslee: please define "won't let me login"
<18> says access denied for usr ''@'localhost' to database
<17> then you're not login as root.....
<18> but if i do, it doesn't let me access mysql at all
<17> mysql -u root -p
<18> ta
<18> nifty, ta
<18> just finalising transferring my stuff from a remote server to a local server
Return to
#mysql
or
Go to some related
logs:
#php
dmix which package gentoo
linux qemu cannot set up thread-local storage:
#linux
Kmail LocalFolder
#linux
+debian +canadian multilingual +keyboard
#physics
lookbehind assertion ruby
vmware fedora network unreachable
|
|