| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> there is nothing in the files
<0> alpha:~# cat /var/log/mysql.log
<0> alpha:~# cat /var/log/mysql.err
<0> alpha:~#
<1> mysqld may (most likely) doesn't have permission to write to that directory.
<0> what should i do to it?
<1> I just checked my socket, and it's kept in the data directory, owner and group mysql
<1> my /var/run/foo is owned by root
<1> check the permissions on your /var/run/mysql directory
<2> it may also just be going to /tmp instead ;)
<2> ll /tmp/my*
<0> how do you check the permissions on the command line?
<1> .. ls -ld /var/run/mysql
<0> i've only ever chown'd and chmod'd
<0> ls: /var/run/mysql: No such file or directory
<2> you just want a long list, like ll or ls -l above
<1> ok.
<1> mkdir /var/run/mysql && chown mysql:mysql /var/run/mysql
<0> done
<1> try and start it now.
<0> . /usr/bin/mysqladmin: connect to server at 'localhost' failed
<0> error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
<0> Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
<2> and again, please do check /tmp
<2> and check your /etc/my.cnf for paths etc. too
<0> ls: /tmp/my*: No such file or directory
<0> basedir = /usr
<0> datadir = /var/lib/mysql
<0> tmpdir = /tmp
<0> [mysqld]
<0> user = mysql
<0> pid-file = /var/run/mysqld/mysqld.pid
<0> socket = /var/run/mysqld/mysqld.sock
<0> port = 3306
<2> check /var/lib/mysql for an err file
<1> does debian have separate mysql and mysqld init scripts?
<0> no error file in there
<1> I don't. but it looks like you are running a client init script, and not the one for the server.
<2> it may be invoking mysqld_safe
<2> it's been that long since I've used Debian now I forget how it installs
<0> # MySQL daemon start/stop script.
<0> . /usr/bin/mysqld_safe > /dev/null 2>&1 &
<0> is the line that i think it executes from the script
<2> try " /usr/bin/mysqld_safe --user=mysql"
<2> from the command line
<0> Starting mysqld daemon with databases from /var/lib/mysql
<0> mysqld_safe[3039]: started
<0> STOPPING server from pid file /var/run/mysqld/mysqld.pid
<0> mysqld_safe[3045]: ended
<0> (being run as root [if that makes a difference])
<2> good
<2> paste your my.cnf to a pastebin
<0> ok
<0> http://hashmysql.org/paste/viewentry.php?id=1450
<2> now the output of "ls -l /var/lib/mysql"
<0> total 20556
<0> -rw-rw---- 1 mysql mysql 25088 2006-02-16 04:44 ib_arch_log_0000000000
<0> -rw-rw---- 1 mysql mysql 10485760 2006-02-16 04:44 ibdata1
<0> -rw-rw---- 1 mysql mysql 5242880 2006-02-16 04:44 ib_logfile0
<0> -rw-rw---- 1 mysql mysql 5242880 2006-02-16 04:44 ib_logfile1
<0> drwxr-xr-x 2 mysql mysql 4096 2006-02-16 04:44 mysql
<0> drwxr-xr-x 2 mysql mysql 4096 2006-02-16 04:44 test
<2> hmm mysqld_safe isn't even writing an error log
<0> :'-(
<2> might try running mysqld from the command line instead then
<0> 060216 5:18:29 Can't start server: Bind on TCP/IP port: Cannot ***ign requested address
<0> 060216 5:18:29 Do you already have another mysqld server running on port: 3306 ?
<0> 060216 5:18:29 Aborting
<2> heh
<2> ps aux | grep mysqld
<0> root 3051 0.0 0.1 1820 568 pts/0 R+ 05:19 0:00 grep mysqld
<2> but why is mysqld_safe then not writing an error log?
<2> that's wrong
<2> do you have something else on 3306?
<1> fuser 3306/tcp
<0> alpha:~# fuser 3306/tcp
<0> alpha:~#
<2> netstat -an | grep 3306
<0> alpha:~# netstat -an | grep 3306
<0> alpha:~#
<2> set bind-address to 0.0.0.0 in your my.cnf
<0> oh crap
<3> xsquared: comment bind-adress and skip-networking out in your my.cnf
<0> thats not the ip
<2> heh
<2> i just ***umed at first it was, guess not eh ;)
<0> Starting MySQL database server: mysqld.
<0> Checking for crashed MySQL tables in the background.
<0> alpha:~#
<0> heh.
<0> thanks mate
<0> appreciate that
<0> and my own stupid bloody fault
<1> it usually is ;)
<2> !op Leithal
<1> !op infi
<4> You aren't allowed to do that.
<1> :~(
<2> ;)
<0> how can you let remote hosts access the server through the 3306 port?
<2> grant them access
<2> open the firewall for 3306
<2> !man adding users
<4> (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<5> INSERT INTO tblFeatProp (propID, feat_start, feat_end) VALUES ((SELECT propID, UNIX_TIMESTAMP() AS feat_start, UNIX_TIMESTAMP() + 10000 AS feat_end FROM tblProps ORDER BY RAND() LIMIT 0, 10)) <-- anyone know what would be causing that to die?
<0> thanks
<0> this is fun
<5> the select query by itself returns the desired results
<0> 1 last thing. How can i copy all the databases from one mysql server to another?
<1> !m xsquared mysqldump
<4> xsquared: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<1> make sure that you output it with the right version syntax for your destination server.
<1> if you're running 5 it should be fine with whatever you output.
<6> morning
<6> i had the idea of putting the sample .ogg files of a webshop right into the mysqldb.. most people told me that my database will get horrible slow.. anyone who can acknowledge that?
<7> it is a bit daft
<7> the comms link will have a lot more work, the query cache will be easily overwritten
<7> and web caches will be unable to cache the files due to the "file date"
<7> so it wont just affect the db server, it will slow down the http server as well
<6> hm ok, so putting them somewhere static and placing it's filename into the db should do? :)
<7> yes thats best
<6> ok, same for images?
<6> i guess so :)
<7> yup
<7> there are a couple of reasons pro images etc but they are idle programmer reasons
<6> ok
<8> hi
<8> i want to use only r or l in a table, in entry ... i don't know how to explain ...
<7> we dont know how to guess
<8> create table actualite (ID int(5) not null auto increment primary key, choice .... here only put r or l nothing else .... is it possible
<7> use enum
<7> !man enum
<4> (The ENUM Type) : http://dev.mysql.com/doc/mysql/en/ENUM.html
<8> archivist: thanks
<9> hi :)
<9> did someone use mysql 5.0.x on gentoo ?
<10> Is it possible to select the pk of the row that is MIN() of a select query? (hope that is clear \o/)
<10> :(
<11> 4/window 15
<11> :
<11> :/
<10> ?
<10> gimmulf__?
<11> :>
<10> X
Return to
#mysql
or
Go to some related
logs:
force encoding in php
firestarter port forward
#web
#awk
#egghelp
Gentoo rdns
#web
Fatal error: Cannot redeclare str_split() in
proftpd howto active mode
BIND startproc
|
|