#mysql
12 November 2007
Total 20 pages. You are browsing page 4/20.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
05:00 <****> should i put in the full hostname?
05:00 <****> it contains "storage engine" something
05:00 <****> kimseong it contains "storage engine" something and a url
05:01 <****> v5: http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html not really relevant but has 1 example of multi table delete in that long article
05:01 <****> thanks
05:01 <****> kimseong: that is great recommendation ;-)
05:01 <****> haha
05:02 <****> how do you configure php and mysql?
05:02 <****> is anything amiss in the ini file?
05:02 <****> i'm getting the conclusion this query is impossible
05:03 <****> Anon696: you got mysql_connect working, so it should be fine
05:03 <****> i did not
05:03 <****> says access denied
05:03 <****> Anon696: access denied is from the mysql server
05:03 <****> Anon696: try no password
05:03 <****> with and without it does not work
05:04 <****> is the username correct? the ones shown on the error message
05:04 <****> and how did you create the user?
05:04 <****> cpanel
05:04 <****> Anon696: are you connecting to the correct mysql server
05:04 <****> if you created it on cpanel, cpanel normally uses yourcpanelusername_databasename
05:05 <****> it generated myusername_mydbusername
05:05 <****> so $db_user = that
05:06 <****> Anon696: web server in the same machine?
05:07 <****> i am trying this..
05:09 <****> nope even with full hostname it cannot connect
05:09 <****> are you sure you're connecting to the right instance of mysql?
05:10 <****> what port does mysql usually run on
05:10 <****> 3306
05:11 <****> that is probably the way it is configured
05:12 <****> o.o
05:12 <****> bit weird.. I've got a table with a cell having the value NULL. when I do "SELECT * FROM table WHERE column = NULL, it doesn't return that.
05:12 <****> null
05:13 <****> column is null
05:13 <****> is "column is null" syntactic or descriptive of the above?
05:13 <****> syntactic
05:13 <****> try that
05:13 <****> is is a valid operator
05:13 <****> cool, thanks!
05:18 <****> Hey, This isn't returning the correct result, i'm wondering if the logic doesn't make sense http://rafb.net/p/2vU9Rg20.html
05:20 <****> hi all
05:20 <****> i have a huge db like about 600++ gb, does it recoment to run on lvm partition?
05:21 <****> Column count doesn't match value count at row 1 does this mean that i'm trying to insert too much data ?
05:21 <****> or not enought...
05:22 <****> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'yourbus5_admin'@'box346.bluehost.com' (using password: YES) in /home/yourbus5/public_html/Install/install.php on line 16\
05:23 <****> ToeBee: i'm trying to count them, brb
05:23 <****> any idea?
05:23 <****> Anon696: did you create the user with a hostname?
05:27 <****> Youve been talking about this problem for more than an hr already
05:27 <****> qkit: I don't think there is anything that would stop you from doing that... may even be handy for backups (lvm snapshots)
05:28 <****> qkit: but I have never personally dealt with that much data so I can't say what issues you might run in to
05:28 <****> qkit: what IS your backup plan? :)
05:29 <****> hi all, I'm running mysql 5 on ubuntu server, and I want to set it up to be case sensitive... and I can't remember / find how I managed to do it before... can someone point me in the right direction please?
05:29 <****> but recently i getting alot hdd crash or unknow error , all are directed to the lvm partition. So a bit worry was it the huge mysql runing on the lvm causing the issue
05:29 <****> as the database are growing from time to time..
05:30 <****> ah
05:31 <****> are you running lvm on top of a raid or something?
05:31 <****> yes..
05:31 <****> the lvm are runing on top of hardware raid 5
05:32 <****> ah... excuse me - I'm trying to set it up to be case *in* sensitive :P bad typing on my part.. can anyone give me a hand. I can't find it in the docs?
05:34 <****> qkit: hmm not sure what going on. Do the logs have any useful information when things go wrong? Could it be hardware problems?
05:35 <****> errr, i getting kernel:stex() invalid tag
05:36 <****> suspected is a bug in the driver, og well, google doesnt return any usedful info
05:36 <****> s/og/oh
05:46 <****> qkit, what raid controller?
05:49 <****> promise supertrak
05:49 <****> ah.. found it.. lower_case_table_names=1 had to be under a [mysqld] section :P
05:50 <****> any idea? nmatrix9?
06:07 <****> whats that SQL for showing the SQL used to create a table? show create table?
06:09 <****> thyko: yes.
06:12 <****> doesnt work :( mysql5
06:12 <****> worked here
06:12 <****> show create table ssm_config;
06:13 <****> heh
06:13 <****> try it again thyko
06:13 <****> works!
06:14 <****> now, i want the sql to cotain the data too
06:14 <****> *contain
06:14 <****> i was leaving out the 'table' bit
06:15 <****> thyko, selec * from table?
06:16 <****> pulpfiction: as in in the SQL itself, as part of the output of show create table blah
06:17 <****> you want something like a mysqldump script?
06:30 <****> bye
06:33 <****> how come sudo apt-get install mysql wont work
06:33 <****> brandon: apt-get install mysql-server
06:33 <****> E: Couldn't find package mysql is what it says
06:33 <****> #debian or #ubuntu would be better suited for the answer though
06:34 <****> brandon: Are you wanting the server?
06:34 <****> yea
06:34 <****> mysql-server should depend on the latest.
06:34 <****> it working
06:34 <****> brandon: "apt-cache search mysql"
06:34 * LoRez taps his microphone
06:35 * Fujitsu wonders if that shown at http://pastebin.ca/770355 is a bug, or if he is missing something.
06:45 <****> Fujitsu: looks like it
06:47 <****> flupps: That's what I thought... It only occurs if I have an index on (date, outside_temp), even if I recreate it.
06:50 <****> Fujitsu: I'd bug report it :)
06:51 <****> flupps: Doing so. Thanks.
06:52 <****> Fujitsu: the index is critical here, report that properly
06:53 <****> maybe together with the EXPLAIN result
Total 20 pages. You are browsing page 4/20.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last