#mysql
28 December 2007
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Fri Dec 28 00:00:53 2007
00:10 <****> hi... mysql recognizes my system as "localhost", but the host's name not that. how do I correct this behaviour?
00:11 <****> ron_asheton: you don't. that behavior is necessary.
00:12 <****> if I create an ODBC DSN type for a database (let's say my DSN is called "mydsndb") how do I connect to it?
00:12 <****> threnody, the host's name not "localhost". anyway, it works
00:13 <****> ron_asheton: those are different forms of connection.
00:14 <****> threnody, so I don't need to configure anything?
00:14 <****> I have a stored procedure, when I call it from the command line it tells me that the query was executed successfully but there's 1 warning - it doesn't give me any details of what the warning is though
00:14 <****> show warnings;
00:15 <****><
00:15 <****> Thanks ebergen
00:15 <****> ron_asheton: for a local connection, where the client and the mysqld server process are on the same computer, no changes are necessary
00:16 <****> threnody, ok
00:16 <****> ron_asheton: this allows you, if you need, to restrict connections to the localhost, perhaps for security reasons
00:18 <****> how do you make comments in sql backup files? like.. /* ... */
00:18 <****> threnody, that seems reasonable
00:19 <****> Hello all. I'm having a problem.
00:19 <****> aren't we all :)
00:19 <****> I have a mysql query but the problem is that I need to only get something if a certain condition doesn't apply
00:20 <****> tsark: -- Comment here
00:20 <****> todd-: post the query (not php code, pls)
00:20 <****> just single lines?
00:21 <****> ok one second
00:21 <****> Tabmow, -- is only for single lines, what about for multiple lines?
00:22 <****> -- This is
00:22 <****> -- multiple
00:22 <****> -- lines
00:22 <****> ;o)
00:22 <****> /* foo */
00:22 <****> thanks
00:24 <****> I am trying to dump a 3.23.58 database and restore it on a 5.0.32 server. Is there an easy way to do this? I get an incompatibility (at least 1). Namely, ERROR 1064 (42000) at line 6644: 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 'dec text, min_max text, numb_fields text, fill tinyint(1) default NULL, ' at line 8. While I can fix one or two problems by hand, I do not wan
00:24 <****> yury to is a reserved word you could try `to`
00:24 <****> ...
00:24 * yury kicks the bot
00:25 <****> the bot is right :)
00:25 <****> perhaps
00:25 <****> you must be using a word that's reserved on a newer version of mysql
00:25 <****> hm... that sucks
00:25 <****> I really do not want to read through these databases. They are not even mine.
00:26 <****> yury: dec is reserved
00:26 <****> http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
00:27 <****> I suppose there is really no way to fix this except by hand
00:27 <****> only problem is, I do not know where that field is used, so I may wipe out an entire web app
00:27 <****> yury: find and replace world probably work as long as you included the leading and trailing whitespace.
00:28 <****> as long as I run through some user's web code as well
00:28 <****> so much for backwards compatibility
00:28 <****> thanks anyway
00:29 <****> hi all, can someone tell me the command i need to use to import an .sql file into a database in mysql5?
00:29 <****> threnody did you see the stuff?
00:30 <****> todd-_: no
00:30 <****> i tried 'localhost dbname < c:\filepath\dump.sql;' but it gave syntax errors
00:30 <****> scroll up a bit if not i'll repost and retype
00:30 <****> todd-_: if it's a single sql statement, just post it here
00:30 <****> 0))
00:30 <****> 0, I want to ignore all those rules and just return everything
00:31 <****> is there a way to check how many table exist in a database?
00:32 <****> show tables;
00:35 <****>='. Define 'invalid date'
00:36 <****> that is the negated
00:36 <****> that query is wrong
00:36 <****> the logic is what i want to do
00:36 <****> i don't get the desired results
00:36 <****> everything i get is promotion!=0
00:36 <****> but I want to get promotion=0 (with rules)
00:37 <****> hi\
00:37 <****> 0
00:38 <****> Could someone please clarify the MySQL license to me? If I distribute a commercial product that happens to connect to a mysql database do I have to pay for a commercial license or can I use the free one? Also, does using Connector/J change anything (license-wise)? Thank you.
00:38 <****> ok i'll try that
00:39 <****> todd-_: might have to move the parentheses around 'WHERE ((a = b) and (c = d)) OR x = y.
00:39 <****> hmm i think i know what i'm missing... i need an OR
00:39 <****> thanks dude you just helped me... let me test
00:39 <****> i'll let you know
00:40 <****> ok
00:41 <****> What is the best way to learn better ways to store data? I'm tempted to throw all of my data into one table instead of splitting it up with best practices. Many-to-many relationships and all of that mumbo-jumbo. ;) Can anyone recommend good resources?
00:41 <****> Cow_woC: I believe you have to pay if you embed a mysql db in a commercial product. Check the mysql ab site to be sure.
00:42 <****> normalization
00:42 <****> http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and http://datamodel.org/NormalizationRules.html and http://mysqldump.azundris.com/archives/20-Nermalisation.html and some here http://www.keithjbrown.co.uk/vworks/mysql/
00:42 <****> I need some help with the error : #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
00:42 <****> iMarc: ^^
00:42 <****> Thanks! :)
00:42 <****> H ow do I and where is do I configure the mysqld.sock file?
00:43 <****> just needed a good mouth-full of links. ;)
00:43 <****> ironfoot: that file is created when the mysqld server process starts, and is deleted when it stops. Is the server running?
00:43 <****> threnody: I'm not asking about embedding mysql in my product. I'm asking if I have to pay for *connecting* to a mysql server with my product :)
00:44 <****> with a distributed commercial product that is
00:44 <****> threnody: Well it does when iuse the command line.
00:44 <****> ironfoot: also, the mysqld server process writes that file in a particular location. Your client needs to be looking for it int he same location.
00:45 <****> ok I ran into a problem when I was trying to incororatye ruby It has thrown the whole phpmyadmin off.
00:45 <****> Cow_woC: I understand. I don't think so. But I wouldn't base a business decision on an IRC impression. Check with the owners.
00:45 <****> where can I find this file?
00:45 <****> to correct it?
00:46 <****> thanks will do
00:46 <****> ironfoot: the mysql server config tells the server where to write it. In my.cnf, or perhaps in the service startup script.
00:47 <****> I looked at this file it looks ok is there something else to look for?
00:49 <****> let me see if it worked
00:50 <****> if I run innodb in repeatable-read mode, will all selects be the equivalent of select ... for update?
00:50 <****> sense of humor mandatory
00:50 <****> (i.e. no other transactions can modify rows I selected until I'm done)?
00:50 <****> hrm, 2 priests walking a space bar...
00:51 <****> s/ing/ in to/
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last