| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> or 127.238.15.73
<1> What?
<2> thanks gleam
<1> What's the second one?
<0> same as the first
<0> 127/8 is all localhost
<1> So I might see a t-shirt that says "there's no place like 127.238.15.73" sometime soon?
<2> :( #2003 - Can't connect to MySQL server on '127.0.0.1' (10061)
<1> Is it running?
<0> sure
<3> craigb***1976: hehe, patent it :)
<3> anyway...
<3> g'n8
<0> connection refused means the server isn't running or isn't listeningo n that ip or port
<1> Why does he have to type an ip at all?
<2> gleam I'm using apache
<2> and it's running
<0> apache is not mysql.
<2> ?
<0> they're separate pieces of software.
<0> mysql is not apache
<2> um but I'm trying to connect to phpmyadmin
<2> to create the database
<2> and it shows that error
<0> and?
<0> the. mysql. server. is. not. running.
<1> is mysql running? You've actually started the daemon?
<2> sorry but I'm new in this thing
<1> What distro are you using?
<2> I'm just following some tutorial
<4> ps aux | grep mysql usually tells :)
<2> what do I need to see the phpadmyn page?
<0> you need to start the mysql server
<1> It doesn't matter I guess... /etc/init.d/mysqld start should work
<4> :)
<2> so how do I start it
<0> gah
<1> ^^^^
<4> craigb***1976 just said so
<0> run mysqld_safe as root angela
<5> hey all, with mysql replication is it possible to stop the bin-log file rotation?
<5> or to keep the leafs updated with the changes
<0> ttchmnkyz max_binlog_size has an upper limit of 1 gig
<0> the slaves should pick up on the new binlog filename automatically
<5> cuz my master server rotates the file and then removes the original file and the leafs loos track
<0> it shouldn't remove hte old one immediately
<5> May 11 21:10:46 localhost mysqld[14751]: 060511 21:10:46 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
<5> it dont
<5> just it cant find it again after a restart
<5> it was fine for about 2 weeks
<5> then lost the file
<0> mm? how long was the slave stopped? is the file it was working on when it restarted still on the master?
<5> i dont know where it stoped
<0> the master.info file in the datadir or show slave status should tell you
<2> gleam mysqld_safe where do I find it?
<0> angela, i don't know. it depends on how you installed the mysql server.
<0> if you even installed the mysql server at all.
<5> [Thu May 11][root@osiris][/var/log/mysql]$ ls
<5> mysql-bin.000151 mysql-bin.000152 mysql-bin.index
<5> [Thu May 11][root@osiris][/var/log/mysql]$
<5> so it is not mysql rotating
<0> that's the master
<0> on the slave
<0> on the slave, the master.info file
<0> should tell you where it is
<0> so should "show slave status"
<0> make sure the binlog it says it's reading exists
<5> right now i am trying to figure out why it is rotating
<5> logrotate is not set to
<0> because mysql automatically rotates the logs when they hit X megs
<0> max_binlog_size
<5> but not deleteing all files
<0> max_log_days
<5> can i set to never
<5> lol
<0> er, expire_log_days
<0> expire_logS_days
<0> set it to 0 i think
<5> expire_log_days 0
<5> max_binlog_size 1G
<5> works right
<0> yes
<5> sorry
<5> = in there
<0> it'll rotate them when they hit 1G but i think won't delete.
<1> angela24, how did you make out?
<5> i dont care bout the leafs rotating
<5> i just care bout the master
<2> craigb***1976 what ?
<2> do you know where can I find a good tutorial
<6> anyone know how i can empty a table?
<6> i want to keep the schema, but start from scratch :)
<5> delete from <table>;
<5> works for me
<0> truncate table
<0> or drop it and recreate it
<5> gleam- wouldn;t mine work too?
<6> thanks :) worked
<5> mine?
<0> truncate drops and recreates the table in everything but innodb. it's a lot faster than delete
<5> k
<5> well look at that learned 2 things tonight
<5> thnx
<0> it also resets auto_increment
<0> which is useful.
<0> on innodb pre-5.0.fairlylow it just did delete from
<7> everything but innodb when not using file per table
<0> even without fpt it still drops and recreates in 5.0 doesn't it?
<0> unless there are fks
<5> i like 5.x
<8> anything seemingly wrong with this query? select a.book_title, b.units_on_hand from t_book a, t_inventory b where a.book_code = b.book_code group by a.book_title;
<0> are you getting an error?
<8> yeah. not a Group by expression
<0> full error
<8> ORA-00979: not a GROUP BY expression
<0> okay why are you asking oracle questions here?
<8> where would you have me ask them
<0> #oracle, #sql, or buy a support contract? :P
<8> for a second year university paper
<5> third one is the best
<0> then ask your instructor or TA for help
<8> they wont teach me. they said wait till next week
<5> we dont do much oracle here
<0> so wait until next weeK?
<8> fo shizzle
<0> have you tried group by a.book_title,b.units_on_hand?
<8> yeah nah i only wanna group on title
<9> I have a table that has a primary key of (driver_id, order_id). However, now I want to add more companies data to this same table. meaning that each company can have only one driver_id/order_id pair. Is there a way to do that?
<0> what?
<0> make company_id unique also?
<5> gleam-, i have a slave server that is located in Frankfort Germany, and it keeps loosing connection to my master server. can i make the timeout on this server a lil higher so it dont recoonect so much?
<0> sure
<0> variable is in the manual somewhere
<5> k
<0> !m ttchmnkyz server system variables
<10> ttchmnkyz: (Server System Variables) : http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
<5> will locate it
<5> net_read_timeout
<0> i don't think so
<5> i get this
<5> May 12 04:54:37 frankfort mysqld[4358]: 060512 4:54:37 [Note] Slave: received end packet from server, apparent master shutdown:
<5> that is the error on the server
<7> on the slave
<5> but no other server has that problem
<5> yea
<5> the slave
<7> one slave of many?
<5> 1 of 3
<5> sorry
<5> 1 of 4
<5> the only one that has this problem
Return to
#mysql
or
Go to some related
logs:
turn off caps lock using vb6.0
easysouce
#linux
ubuntu installing alc202
latin1_swedish mysql
bmp magic number
#perl
#web
kitchens desining
python raw post data
|
|