| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> could someone tell me whats wrong ?:S
<0> after installing MySQL4.1
<0> can't start it and not even set a p***word for root
<1> sjrussel ****. hit me with a big trout. thankee :)
<2> well, first, you shouldn't have pasted all that here
<0> where should i paste it then?
<0> if not here:S
<2> in a pastebin, and then paste in the link (see topic)
<3> wow, nobody knows how to do this simple thing in mysql?
<1> HaveANiceDay what?
<2> but, your problem is, your mysql server isn't running.
<2> check your *syslot*
<2> check your *syslog*
<3> how do i know what is the charset of a table
<1> HaveANiceDay show create table?
<0> sjrussel but i even can't start my mysql :(
<2> right
<2> you need to figure out why
<2> check the log
<0> sjrussel syslog says that i have already something running on that port
<0> but i don't
<3> create ? i wanna see an existing ones
<1> yeah. "show create table <tablename>"
<0> HaveANiceDay do you know how to fix that problem?
<1> just type it. won't destroy anything :)
<3> veriz: nop
<0> i guess im missing the sock file :(
<1> veriz look @ /etc/mysql/my.cnf, for example ^^ - lsof and netstat could help, too
<3> what is the best way to backup a db ?
<1> HaveANiceDay mysqldump ???
<3> k
<0> nope nothing is running on 3306 port
<0> just installed Ubuntu and tried to install mysql
<2> veriz - mysql will create the socket
<0> but it doesn't :(
<2> it has to start first
<0> and how should i do that ?:S
<0> if its failing
<2> figure out why it thinks the port is blocked
<2> make sure it can write to the dir the socket is in
<2> make sure it's really not already running
<2> (ps waxu | grep mysql)
<0> nope it's not running
<0> maybe my router is blocking it?
<0> but i don't think that...
<0> many ppl have the same problem
<0> that it wont start and create the sock fail
<4> Does && work the same as AND in a where clause? I just noticed that I had mistakenly put in && into a few queries, and they seemed to have worked.
<3> if my table is "DEFAULT CHARSET=latin1" and i want it to be utf-8
<3> can i transform it withou it borking ?!?
<2> psyon - yes
<3> since on the browser and stuff it does show up ok in utf-8, but in phpmyadmin it doesnt
<0> sjrussel so you can't help ?:s
<2> not without you taking a more active role and diagnosing the problem
<1> HaveANiceDay yep.. sec
<1> alter table <table> CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci
<1> e.g.
<3> might it bork stuff ?
<3> i'll make a copy
<3> sec
<1> with me it worked like a charm.. on quite small tables, i confess
<4> sjrussle: actually, I just found docs for it ... && is a bit operator by the looks of it.
<2> no, & is a bit operator
<2> && is boolean
<2> same with | vs. ||
<0> :((((((((
<0> im bored of this linux stuff
<0> nothing works well
<2> heh
<0> and even can't start this s..t
<0> i remember i have done this mysql stuff once
<0> but i don't remember how!
<1> veritz linux is a friendly operating system. it's just picky about choosing its friends
<3> finally google calanders is lvie !
<3> live
<5> how do i show the structure of a table?
<0> sjrussel maybe i should install 5.1 ?
<6> desc table;
<2> they should just change the slogan to "Google: we pownz you"
<0> maybe just 4.1 is bugged
<2> no
<2> your system is bugged
<2> uninstalling and re-installing might work
<3> wow
<2> or, it might not. depending on what the problem is
<3> the google calander is pretty sleak
<0> sjrussel but how i can find out whats the problem?
<2> what do the logs say it is?
<0> they are empty
<3> styx-tdo: alter table <table> CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci which char set is utf-8 ?
<7> ASC and DESC are only legal after an ORDER BY, correct?
<1> have RTFM http://dev.mysql.com/doc/refman/5.0/en/charset-charsets.html
<1> HaveANiceDay utf8_general_ci
<1> HaveANiceDay please use google - just mysql collation are perfect keywords ^^
<1> HaveANiceDay ah charset for collation utf8_general_ci is utf8
<3> blah, i did ALTER TABLE test CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci and all the non-english utf-8 stuff are still jibrish :(
<0> sjrussel any other information ?:S
<3> what other options do i have ?
<1> HaveANiceDay um... what exactly is the problem really? there are conversion functions available for field content
<3> which do what ? i dont see hebrwe in phpmyadmin in my fields in the tables
<3> hebrew
<3> any idea ?
<1> hm.. phpmyadmin adds stuff. what is the charset of the page you see? maybe mysql is OK and php screws it up?
<2> Have--- you need to make sure that apache/php also are doing utf-8
<2> or whatever
<3> how do i know ?
<3> ohh, they are for sure
<3> since i use those fields in my app which uses php, and it shows up perfectly there
<3> just in pma when i try to view them, they arent good
<3> (this issue is on several comps)
<1> ummm.. and you are SURE that this is not related to.. say, phpmyadmin?
<3> i'm trying to view the db in phpmyadmin...
<3> thought somebody here might have a clue on how to know
<3> pma channel is pretty dead :)
<1> anyone knows how i can have one perl DBI placeholder appear twice in a query?
<8> HEllo
<8> In DELETE from multiple tables:
<8> ELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;
<8> Where do i have to put LEFT JOIN ?
<1> between t1 and t2?
<8> what about USING t1, t2, t3 WHERE
<8> i guess it's rather there
<8> but not really sure
<1> iirc using is not for specifying tables but fields?
<8> styx-tdo: http://dev.mysql.com/doc/refman/5.0/en/delete.html
<8> there a re two types of multi-table DELETEs
<1> k
<9> hello !! I am Ysmael, Male I live in the Philippines
<9> 30 years old
<8> Hi, how is weather?
<0> can someone hlep me please? WHY I can't start my mysql4.1, getting this !: http://paste.ubuntu-nl.org/12166
<0> have anyone had the same problem?
<8> veriz: what command do you use to start?
<10> well have you tried starting the server
<0> sudo /etc/init.d/mysql start
<3> veriz: take a look at the syslog...
<1> off., bye
<8> veriz: are you sure server is not already running?
<0> then getting this error: http://paste.ubuntu-nl.org/12168
<0> yes i am
<8> veriz: lsof -i -n | grep LISTEN
<8> look what is listening on 3306
<0> sshd 7637 root 3u IPv6 14553 TCP *:ssh (LISTEN)
<0> master 8579 root 11u IPv4 21563 TCP *:smtp (LISTEN)
<0> only what i have atm
<0> i just installed ubuntu
<3> 5.10 ?
<0> yes
Return to
#mysql
or
Go to some related
logs:
#math
blah.htaccess
sles9 upgrade dev.mysql.com
#math
#linux
ubuntu sound e-mu aps
vpn ubuntu evolution
h2ctypes
#ubuntu
#gentoo
|
|