| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> Got fatal error 1236: 'binlog truncated in the middle of event' from master when reading data from binary log
<0> how do i fix this? my slave sare getting stuck
<1> tanto_: iirc the binlog is truncated to only include the most recent statements
<1> so i presume somehow it took your slave too long to catch up with the binlog
<1> so you probably have to sync the slave from scratch
<0> hrm
<0> can you refresh my memory on how to do that? slave stop ; load data from master ; start slave ?
<1> something like that ..
<1> i never really ran replication in production
<1> just some playing around
<0> hrm
<0> how can i tell if my msater's binlog is messed?
<1> i think you can find out the row that your slave last synced or something like that
<0> how do i increase max_connections while the server is running?
<0> can't seem to locate that on google, only the my.cnf setting
<2> hello
<0> hey
<3> tanto_: SET GLOBAL
<3> !man set syntax
<4> (SET Syntax) : http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
<3> !m tanto set syntax
<4> tanto: (SET Syntax) : http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
<0> i got it thanks :)
<5> how can i check which engine is used for particular table?
<6> can anyone tell me what is wrong with my query? this is the query: http://pastebin.com/659234
<6> and the error message is as follows:
<6> #1064 - 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 'SELECT topaanbod_mail . id FROM topaanbod_mail LEFT JOIN vast
<6> what is wrong?
<7> any one able to help get new install of mysql working
<8> hi, is it possible to get a database dump without locking the tables?
<0> ahh i just fixed my replicaiton problem
<9> eeek! I read that as "without looking at the tables"
<9> started thinking about quantum entanglement and such
<8> heh :)
<7> any one able to help get new install of mysql working
<7> [root@dhw308 mysql]# Starting mysqld daemon with databases from /var/lib/mysql
<7> STOPPING server from pid file /var/lib/mysql/dhw308.pid
<7> 060414 03:40:11 mysqld ended
<10> how can i import the sakila database mentioned in the forums? ive downloaded and unpacked sakila.zip, but mysql --user root --p***word --host localhost sakila <sakila-data.sql erros with Unknown database 'sakila' creating the database as root and trying to import again: Table 'sakila.actor' doesn't exist whats wrong?
<11> Hi I can't get my mysql server to work
<11> Hi
<11> I am having trouble
<11> I have the following [root@adrianRH ~]# rpm -qa |grep mysql
<11> php-mysql-5.0.4-10.5
<11> mysql-4.1.16-1.FC4.1
<11> rpm -qa |grep mysql
<11> produced that
<11> [root@adrianRH ~]# telnet 192.168.1.253 3306
<11> Trying 192.168.1.253...
<11> Connected to 192.168.1.253 (192.168.1.253).
<11> Escape character is '^]'.
<11> FHost '192.168.1.253' is not allowed to connect to this MySQL serverConnection closed by foreign host.
<12> mwright1night, your mysql seems to work
<13> mwright1night: the server appears to work but refuses connections from the host you are using (itself).
<11> ok where do I tell it to let me in
<13> you'll have to change your config (but i don't know the details)
<12> mwright1night, did you set mysqladmin p***word?
<11> my.cnf has nothing in it
<11> maybe not
<11> how do I do that
<13> I3ooI3oo: you'll have to dig into some log file to find the error message...
<11> I share this box with another we are both doing devel on it
<12> mwright1night, its provided during install
<11> yer i Know what it will be
<13> mwright1night: mysqladmin p***word <your new root p***word>
<11> root@adrianRH joomla]# mysqladmin p***word ######
<11> mysqladmin: connect to server at 'localhost' failed
<11> error: 'Access denied for user 'root'@'localhost' (using p***word: NO)'
<11> it is only bound to 192.168.1.253
<11> [root@adrianRH joomla]# mysqladmin p***word ###### -h 192.168.1.253
<11> mysqladmin: connect to server at '192.168.1.253' failed
<11> error: 'Host '192.168.1.253' is not allowed to connect to this MySQL server'
<14> Fatal error: Call to undefined function mysql_connect() in /usr/home/gusinje/public_html/sah/trychess-0.2/cl***es/cl***.install.php on line 133
<14> why do i get this error ?
<13> Alija_: your php probably does not have mysql support. ask at #php
<11> any ideas
<13> mwright1night: i don't *know*, but i'd try to bind it to localhost too, and try to connect to that
<13> i think root is restricted to localhost (i.e. unix socket or loopback) per default
<10> how can i import the sakila database mentioned in the forums? ive downloaded and unpacked sakila.zip, but mysql --user root --p***word --host localhost sakila <sakila-data.sql erros with Unknown database 'sakila' creating the database as root and trying to import again: Table 'sakila.actor' doesn't exist whats wrong?
<15> on what default port number does mysql run?
<11> how do I bind it to localhost
<16> 3306
<11> w
<15> 3306?
<15> owk
<15> Database error was:
<15> Can't connect to MySQL server on '192.168.0.3' (113)
<15> :/
<16> !perror 113
<4> System error: 113 = No route to host
<13> if it really running?
<13> oh
<13> network setup messed up
<13> (or wrong IP address)
<13> (or broken/missing cable)
<11> I found mysql config
<11> that specifises the port
<17> hey guys I need ur help... ill not upload pics, files or something on my database, only user informations like live, age, username, p***word.. and im wondering 25mb is enough for storing over 1000 users
<11> but I can't see the host it is listening on
<10> mwright1night, did you changed the initial config after installing mysql?
<11> My colleague installed it
<11> he has gone on holiday
<11> he created one database so I don't want to trash it
<11> I just want to bind it to localhost
<11> or get into it from localhost
<10> its unlikely that mysql isnt listening on localhost....
<11> it's not
<10> what does netstat -pnl|grep mysql say?
<11> [root@adrianRH etc]# netstat -na |grep 3306
<11> tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN
<11> it should be though
<11> according to that
<12> netstat -ltp
<16> It *IS* listening. the problem is that there is no user record created with rights to access it *FROM* the host you are coming from, and thus it is rejecting you. Otherwise, you wouldn't get the "Access denied for..." message, you'd get a "Cannot connect" message.
<10> mwright1night, what does mysql --user yourusername --p***word --host localhost say?
<10> oh...he already posted the access denied messsage...never mind
<10> mwright1night, i guess infi is right
<10> now to the real problems :)
<10> importing the sakila database...its mentioned in the mysql.org forum. how can i import a shema file?
<11> mysqladmin: Unknown command: '########'
<16> metalfan: mysql -u username [-h host] -p database < file.sql
<18> !m mephis1987 right
<4> mephis1987: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<11> What does myphpadmin allow me to do
<11> I am currently able to access that so it can see the databases. will that disclose to e the user name?
<19> create & edit db'S / usrs
<19> goto rights or something like that
<19> permissions, whatever it is called
<18> !m as
<11> i'm looking in the "mysql" database
<4> Incorrect usage. See 'help m'
<18> !m mephis1987 as
<4> mephis1987: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<20> hi
<20> hi this query doesn't return results
<20> SELECT `title`,`text` FROM `sites_us` WHERE MATCH (`title`, `text`, `url`) AGAINST ('php')
<11> I have a page in front of me with Server localhost Database mysql Table user "Users and global privleges"
<11> how do I edit the data to add a user and a host
<20> php is in url field
<11> ok I'm looking at the users
<11> there is one user called root
<11> in the database mysql
<13> the user is not called root. it's called root@...something.
<13> the combination of name and host makes up the "user".
<13> you can set the host to "%" to mean "any".
<13> (though that's not a good idea for root)
<11> user@localhost
<14> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'sah'@'192.168.7.7' (using p***word: YES) in /usr/home/gusinje/public_html/sah/trychess-0.2/cl***es/cl***.install.php on line 133
<11> root@localhost
<14> why does it say that
<11> [root@adrianRH etc]# mysqladmin root@localhost -p
Return to
#mysql
or
Go to some related
logs:
#perl
#web
#ubuntu
#web
gentoo svn co unrecognized url scheme
perl ssh pipe
#python
elpernotador
#math
Digest verification failed gentoo snd
|
|