#mysql
06 October 2007
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:56 <****> hmm not familiar with aptitude but I would think that an install should put a default conf file into /etc/...
04:57 <****> How did you install it from the source code?
04:58 <****> I've installed it via emerge on gentoo, via ports on BSD and via apt on Ubuntu
04:58 <****> I want to have to do it that way.
05:00 <****> ok i am back
05:00 <****> any of you had experience with real time critical programming
05:00 <****> ?
05:01 <****> Do you have the download mysql with giving my email address please?
05:03 <****> does aptitude have an option that will re-run initial configuration for a given package?
05:04 <****> Yes, and I already tried that.
05:05 <****> When you trying to install a application and you get mysql does not support text?
05:05 <****> ToeBee: use man apt-get
05:07 <****> michlemken: I was trying to help phil :)
05:08 <****> Mysql does not support text mean?
05:23 <****> The used table type doesn't support FULLTEXT indexes what doees that mean?
05:30 <****> phil: as I recall, only innodb supports fulltext indexes
05:31 <****> How can I enable it?
05:31 <****> err
05:31 <****> I mistyped. only myisam
05:31 <****> What is myisam?
05:32 <****> !m phil storage engine
05:32 <****> phil see http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
05:32 <****> err
05:32 <****> !m phil storage engines
05:32 <****> phil see http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html
05:32 <****> there
05:32 <****> jty
06:03 <****> sup
06:07 <****> dawg
07:31 <****> i am running mysql but i did not open any door
07:31 <****> mysqladmin version shows some info, its running, but its now showing any port
07:31 <****> i believe its commented in the config file
07:31 <****> i just dont know where it is
07:32 <****> in website mysqladmin says the port: http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
07:32 <****> mine does not
07:34 <****> xjkx: It's possible that it's not using networking but is using a sockets instead
07:34 <****> xjkx: by default mysql only listens on the socket, not on the tcp port
07:36 <****> does anyone know of a tool that will generate a conceptual schema diagram from an sqldump, or something?
07:46 <****> sub, ToeBee how do i change tit
07:46 <****> it shows me a socket, fact
07:47 <****> do you NEED to change it? Just use the socket
07:52 <****> is mytop or mtop more effective for mysql monitoring?
08:04 <****> i'd like to save my database "schema" is it called? and put it under version control just in case something bad happens so i can recreate the structure....how do i do this ?
08:10 <****> Is there a client for mysql similar in intent and functionality to postgresql's psql?
08:19 <****> sauvin: What about mysql ?
08:19 <****> sauvin: mysql the command line tool
08:24 <****> ToeBee, dont know work with socket
08:24 <****> no port is openned by using nmap
08:24 <****> i will insert data from apache
08:24 <****> from web browser i mean
08:24 <****> using php
08:26 <****>
08:26 * sauvin is busy trying to find docs in his distro's package manager because he can't get into mysql and presumes there's some setup to do similar to what had to happen in postgresql
08:27 <****> i cant get into mysql neither
08:27 <****> =s
08:29 <****> i need a tcp port in mysql
08:29 <****> its not openning
08:29 <****> anyone?
08:30 <****> here http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html it says "Localhost via Unix socket" but it has a port anyway "TCP port 3306" but mine doesnt
08:30 <****> my mysqladmin shows just the socket part
08:31 <****> Server version 5.0.37 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysql/mysql.sock Uptime: 1 hour 47 sec
08:33 <****> sauvin, what do you think?
08:34 <****> You're asking somebody who hasn't even figured out yet how to even *spell* mysql?
08:35 <****>
08:35 <****> we are the only actives, both of us know nothing anyway =D
08:35 <****> I have a mondo mysql dump I'm trying to get loaded up into something I could hook up to with a DBI interface, but can't even get into mysql yet to get it to even show system catalogs.
08:36 <****> It just says "error 1045 (28000): access denied for user 'sauvin'@'localhost' (using password: NO)"
08:36 <****> Ergo, I need to find some docs to RTFM.
08:37 <****> did you set sauvin to have access?
08:38 <****> xjkx, all I've done so far is install the package from a package manater.
08:38 <****> Manager, even.
08:38 <****> Postgresql did something similar to me. I had to invent a postgres 'user', set its password, go into postgresql itself, invent 'sauvin', give the idiot some perms and suchlike, and create a db for him.
08:39 <****> sauvin, read here http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
08:40 <****> I thank you for that, and I WILL read it, but I'm looking for any docs that might be on my distro's package manager's repos, too, and enjoying the browsing because I'm also picking up craploads of unrelated docs because, well, "d'oh, yea, I'll want to have that handy..."
08:40 <****> xjkx, yes, that *looks* exactly like what I need.
08:40 <****> :)
08:43 <****> I am NOT editorialising, nor am I trolling. I'm just more comfortable in postgresql, which is why I need docs for mysql, at least good enough to get this dump installed so I can hook up to it and suck it into postgresql in order to work with it.
08:44 <****> I don't understand this dump - it's all INSERT into sometable_or_other VALUES (number, number)(number,number)(number,number).....
08:49 * sauvin gives up on his distro's package manager and downloads mysql documentation directly from mysql.com
08:59 <****> solved my problem here, thanks god
09:00 <****> xkjx, that link you gave me, is it good for mysql 5.x as well?
09:04 <****> sauvin, http://dev.mysql.com/doc/refman/5.1/en/unix-post-installation.html
09:05 <****> its just the same anyway
09:05 <****> but it says refman/5.1 so you'd have no doubt
09:06 <****> xjkx: php can connect through the socket
09:06 <****> sauvin, maybe you should take a look at here too http://dev.mysql.com/doc/refman/5.1/en/access-denied.html
09:06 <****> why open a tcp port if you don't have to? Opens up more remote attack vectors
09:07 <****> ToeBee, you are saying i wouldnt need to change my code?
09:08 <****> no. I believe you just have to do mysql_connect("localhost", "user", "pass") in php
09:08 <****> where would you see the needing to use mysql remote then?
09:09 <****> maybe if you have a dedicated database server and your app server is on another machine
09:10 <****> uhmm, here is just for studying purposes, anyway, my machine wouldnt be vulnerable just by having it openned, i am connected through a geteway, my ip is not valid
09:17 <****> is myisam same as innodb?
09:17 <****> ToeBee, help sauvin out, he wants to create an user account, allow some user or something
09:18 <****> Oh, I'll be alright. I've set up mysql before, just using docs from mysql.com.
09:19 <****> It's a job I'll tackle when I'm not so tired my ears are ringing :D
09:23 <****> ;]
09:28 <****> If I have a query that does a lot of joins, and works out a where clause accross all tables but one (call this one "extra") - if I join all the tables, will mysql join on "extra" all the time, or only when it satisfies the "WHERE" clause?
09:29 <****> (I mean, only when the rows that join it satisfy the where clause)
09:34 <****> how can i chance a table from myisam to innodb?
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last