| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> my guess is you're having problems with dns and you aren't running with --skip-name-resolve
<0> just a guess.
<1> everything is IP based
<1> would that still cause an issue?
<1> omg
<1> i think that was it
<1> im going to go kill myself now
<1> thanks!
<0> i hope that was it
<2> what have I done wrong here .. select DATE_FORMAT('%b %e, %Y',FROM_UNIXTIME(1149084000)) as date
<2> It's giving 'null' .. the FROM _UNIXTIME() part works ..
<0> you have your arguments reversed
<0> datestr,format
<0> not the other way around
<2> GAH .. thanks
<3> hey anyone wanna help my mysqld won't start, i'm running gentoo
<4> how can i list anything for host so people can connect from outside the box?
<4> % ?
<3> Can't start server : Bind on unix socket: No such file or directory
<5> United: you can't directly with mysql
<5> you need to use iptables
<5> you bind to a public ip address, then use grants
<5> if that's not enough, you use iptables
<4> thanks
<6> i restart mysql .. and i got this error message --> STOPPING server from pid file /var/run/mysql/mysql.pid
<6> whats qrong?
<6> *wrong?
<7> nothing, its stops the server then starts it
<6> how do i starts it?
<8> ichigo_reloaded, nice name btw, is mysqld running?
<6> nope ..
<8> i would check your err file
<8> which usually resides in your data directory named hostname.err
<6> thx :) even i restart my slck .. i still got that msg
<8> oh your using slackware?
<6> yup
<8> is this your fist time using mysql on it?
<6> yup .. and my 1st time using linux :P
<8> oh okay
<8> you have to install the initial database tables
<8> hold on I'll tell you how to do that as soon as i can remember (look up) the script name
<8> okay
<8> su to root
<8> if your not root all ready
<6> ok
<8> then: su mysql
<8> you should be mysql user now
<6> ok
<6> then?
<6> :P
<8> then do: mysql_install_db
<6> ok.. done ... next?
<8> exit
<8> so your back to root
<8> then: /etc/rc.d/rc.mysqld start
<8> you only have to do mysql_install_db when you do a fresh install
<8> so you should be good to go from now on
<6> yippeee... done ..
<6> thx alot bro
<8> heh i ran into the same problem when i first ran linux (i ran and have been running slackware ever since)
<8> since 9.1
<6> wow ... long long long long long time ago eh ..
<8> heh 2 years or so
<8> now i forbid any MicroSoft operating systems near my home computers
<6> ahaahahahahaa. ...
<6> i still need to use that stupid o/s ..
<6> i mean .. my work make me use it
<6> i try to start mysql all night long
<6> man ... now i need to configure apache ..
<9> gday. im trying to do replication on a debian system. yesterday i stopped the master and did a dump of the db i want to replicate with --master-data. i've now loaded this into the slave, and it seems fine except that the master has now moved on to mysql-bin.132 and the slave is on mysql-bin.131 - why did it change, and can i make the slave change with it?
<3> i installed mysql on gentoo
<3> and it won't start
<3> it tells me Can't start server : Bind on unix socket: No such file or directory
<3> can someone look at my error log?
<3> http://pastebin.com/766664
<3> someone want to help? that would be so sweet
<8> sol, does that mysql.sock exist?
<3> cythrawll: no
<3> cythrawll: and thanks :-D
<0> does /var/run/mysqld exist and is it owned or rwitable by the user mysql runs as?
<3> gleam_: yes
<0> how are you starting mysql?
<3> rc-config start mysql
<8> with what user?
<3> root
<3> cythrawll, gleam_ : any help?
<10> I'm trying to find the syntax for IN but it's a bit difficult because most search engines look at that as a stop word an the mysql manual search isn't that helpful either, can anyone point me in the right direction?
<3> cythrawll, gleam_ : this is a fresh install of MySQL so... i dunno
<3> can someone please help me
<11> k4st_, WHERE col IN ('hi','no','foo','bar')
<10> thanks!
<12> im having mysql troubles, is anyone around who would be willing to help?
<11> !tell us about ask
<13> will asked me to tell you this: Don't ask if you can ask a question or ask if anyone knows about a particular topic. Just ask your specific question, then wait to see if someone will help.
<12> haha, thanks
<14> I created some tables on mysql 4.0... now i find out my webhost has mysql 3.25... what would serial fields be in 3.25 ?
<12> I know this is ugly but here is my query
<12> SELECT topics.* ,COUNT(post_info.id) as replies , author_info.* , category_info.* , post_info.*
<12> FROM topics
<12> JOIN users AS author_info ON author_info.id=topics.author_id
<12> JOIN categories AS category_info ON category_info.id=topics.category_id
<12> JOIN posts AS post_info ON post_info.topic_id=topics.id
<12> WHERE category_info.slug='Marketing' AND type='forum'
<12> GROUP BY topic_id
<12> ORDER BY cc_topics.created_on DESC,post_info.created_on DESC
<12> LIMIT 9
<12> It seems like the order clause for post_info.created_on is being ignored. I need it to return the most recent row from post_info but its returning oldest.
<15> try using pastebin next time
<12> will do, thanks
<6> man .. i know this is the wrong place .. but can someone help me .. how can i make userdir as a default website .. i mean, if i put 198.0.0.1 , then it will automatically go to the userdir
<16> !perror 28
<13> System error: 28 = No space left on device
<16> hmm
<17> zircu need more space
<17> free more
<18> i have question ?
<15> do you?
<15> !tell castro2006 about ask
<13> Alrighty.
<17> castro2006 ask
<17> ask
<18> i am backing up my database by mysqldump
<17> ok and?
<18> i was installed mysql as server on my backup server and it was working fine
<17> ok
<17> and?
<18> i formatted the server and istalled mysql as client and now when i run the backup script it give me out of memeory
<17> how run the script
<17> wich is the script?
<18> my DB is aroung 7G
<17> have space i nyour new server?
<18> i mean mysqldump -q -ubackup -pbackup01 -hnevada.palnet.com PAMS > backup-PAMS.txt
<18> yes i have
<18> after i added -q option it worked fine but from crontab still
<19> !man show slave hosts
<13> (SHOW SLAVE HOSTS Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_SLAVE_HOSTS.html
<20> hello
<21> wow
<21> wish my hellos had that effect :P
<21> hiya domas :P
<20> ;-)
<22> Hehe
<17> castro2006?
<18> jak2000: it was disk space problem, thanks for your help
<17> castro2006 anyway
<17> why not use replication
<17> ?
Return to
#mysql
or
Go to some related
logs:
#fedora
#debian
php html scraping
SMC2602W linux ADM8211
#debian
repo libdirectfb-0.9
oidentd ubuntu
#asm
debian dpkg-reconfigure lcd 910GL
UnicodeEncodeError psycopg2
|
|