#mysql
28 October 2007
Total 17 pages. You are browsing page 1/17.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sun Oct 28 00:00:54 2007
00:12 <****> Hi can someone assist?
00:12 <****> i can't get mysql running on my freebsd 6.2 i keep getting errors
00:12 <****> 071027 15:52:49 mysqld started
00:12 <****> 071027 15:52:49 InnoDB: Operating system error number 13 in a file operation.
00:12 <****> InnoDB: The error means mysqld does not have the access rights to
00:12 <****> InnoDB: the directory.
00:12 <****> InnoDB: File name ./ibdata1
00:12 <****> InnoDB: File operation call: 'create'.
00:13 <****> InnoDB: Cannot continue operation.
00:13 <****> 071027 15:52:49 mysqld ended
00:13 <****> can someone help a serious n00b here with a small SQL question?
00:14 <****> looks like nobody is idle
00:14 <****> just ask ..
00:14 <****> oeg: normally mysqld runs under the system user 'mysql', who must have read/write privileges to the data directory.
00:14 <****> ki77a77 can i pm u?
00:14 <****> no
00:14 <****> ok, I need to make sure that certin users only have access (allthough full access to the selected database) to a specific database ONLY
00:15 <****> ki77 can you outline the steps i need to take to start mysql successfulyl
00:15 <****> JeevesMoss: sure you can do this
00:15 <****> or anybodu else that has 5 min..
00:15 <****> should be trivial to do especially if you have some interface like phpMyAdmin or SQLYog
00:16 <****> oeg: follow post installation steps for your o/s. http://dev.mysql.com/doc/refman/5.0/en/post-installation.html
00:16 <****> JeevesMoss: use grant syntax. http://dev.mysql.com/doc/refman/5.0/en/grant.html
00:16 <****> lsmith: I actully have SQLYog, and I don't think it's doing what I need. I didn't want to mess with the command line (hence why I got Yog), but I'm just making sure. We have a bunch of domains that are under test that we can't have the other devs knowing about
00:17 <****> hi, i'm installing mysql 5 right now on my machine for the first time... is it normal, that it takes very long to get it's configuration done? i'm waiting since 7 minutes or so
00:18 <****> it says 'processing configuration' and i get four white circles with 'prepare configuration' and so on, they stay white, i see nothing happening
00:19 <****> localhost# Starting mysqld daemon with databases from /var/lib/mysql
00:19 <****> STOPPING server from pid file /var/lib/mysql/mirzet.homeunix.com.pid
00:19 <****> 071027 16:13:21 mysqld ended
00:19 <****> I have a query that references a table that is not in the same database, can I make the sql query reference an external database by replacing tblname with databasename.tblname?
00:20 <****> here is the query in question
00:20 <****> update tblmasterfood join tblchain on tblmasterfood.ChainID = tblchain.`1` set
00:20 <****> those two tables are in different databases.
00:20 <****> oeg: do 'ls -l /var/lib/mysql'
00:21 <****> mirzet# ls -l /var/lib/mysql
00:21 <****> total 8
00:21 <****> -rw-rw---- 1 mysql wheel 3647 Oct 27 16:13 mirzet.homeunix.com.err
00:21 <****> drwx------ 2 mysql daemon 1536 Oct 27 15:53 mysql
00:21 <****> drwx------ 2 root wheel 512 Oct 27 15:53 test
00:21 <****> mirzet#
00:22 <****> root owns test? oh noees!!
00:24 <****> hey guys I store IP's as varchar of what length? 15?
00:25 <****> oh nvm
00:27 <****> ki77 u there?
00:27 <****> oeg: I think /var/lib/mysql should be mysql:mysql all the way down.
00:28 <****> oeg: I also need you to find out where mysqld is writing the pid file
00:28 <****> oeg: and whether or not the pid file exists when the server is not running.
00:29 <****> ok seems like its working now let me check
00:30 <****> u rock ki77
00:33 <****> oeg: my protocol for assistance is to throw sufficient crap at the wall till something sticks. ;^)
00:34 <****> hehe thanks it sure did stick :)
00:34 <****> wipe your face! it's full of crap
00:35 <****> Sirisian you store IPs as either 4 8-bit numbers or one 32-bit number, as that is what they are
00:35 <****> both are equally valid
00:36 <****> NO
00:36 <****> SELECT INET_ATON('192.168.100.1');
00:37 <****> SELECT INET_NTOA(INET_ATON('192.168.100.1'));
00:37 <****> use those functions
00:37 <****> adaptr, yeah BIGINT? I'm using ip2long
00:37 <****> is BIGINT as long?
00:37 <****> a*
00:38 <****> Sirisian whatever comes out to 32 bits
00:38 <****> one a 32-bit system, that would be a normal INT
00:38 <****> *on
00:38 <****> but it must be unsigned
00:38 <****> yeah
00:38 <****> int is 4 bytes
00:38 <****> to be used as an IP
00:38 <****> okay just wondering the mysql equivelant
00:38 <****> int it is
00:39 <****> in mysql 4.0 what is the byte size of a smallint?
00:40 <****> you guys are morons
00:40 <****> I mean it has medium int also... so if int is 4 bytes, then medium int is like 2?
00:40 * chadmaynard is being ignored, so he'll let you fuck up
00:41 <****> is it possible to have a table autofill a datetime variable upon insert? (ie, insert without specifying that column)
00:41 <****> chadmaynard, was that for me?
00:41 <****> Gm4n sure, set a default for it as NOW() or something
00:42 <****> chadmaynard, I'm using PHP, so I already have it all set up, just curious what the equivelent data types are and their byte counts, but I found it out online
00:42 <****> smallint is just a 32 bit short
00:43 <****> chadmaynard thanks, tard
00:44 <****> 'short' in C is usually 16 bit signed integer, no?
00:44 <****> depends on the wordsize of the machine and the compiler
00:45 <****> adaptr: excuse me?
00:45 <****> how about on a 64 bit machine? is 'short' still 16 bits signed int?
00:45 <****> how can I change the next autoindex?
00:45 <****> you guys are morons <-- as I was the only other "guy" speaking then, I assume that includes me
00:45 <****> adaptr: you aren't a moron?
00:46 <****> about as much as you are a tard, I guess
00:46 <****> enough namecalling
00:46 <****> My information was correct. Yours was silly
00:47 <****> I guess you don't do much actual networking, then?
00:47 <****> chadmaynard: that is not the significant bit. Your approach to people is, dysfunctional.
00:47 <****> dysfunctional, I can handle - insulting is uncalled for
00:47 <****> chadmaynard: dinner time. feel free to ban.
00:48 <****> adaptr: sorry. I was frustrated.
00:48 <****> adaptr: like this? http://pastebin.ca/752005
00:48 <****> Mike_L, whoops yeah I meant to say 16 bit short
00:49 <****> !man default
00:49 <****> (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html
Total 17 pages. You are browsing page 1/17.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last