#mysql
30 October 2007
Total 22 pages. You are browsing page 1/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Tue Oct 30 00:00:20 2007
--- Day changed Tue Oct 30 2007
00:00 <****> thumbs i dont have other choice, i migrate servers
00:00 <****> and i will not install archaic mysql 3 to move that database
00:00 <****> mysql 4.1 is also archaic for me , but ok
00:00 <****> well at least make sure the charsets used in 3.x are available in your 4.1 server
00:01 <****> Ksz: It does from 3.2.3 over to 5.0.whatever, for me, anyway
00:01 <****> as i know there is not any charsets in mysql 3?
00:01 <****> What up everyone?
00:01 <****> yes this version is mysql 3.2.3
00:02 <****> Ksz: It should magically work. Hopefully. Just set a server up and test it already :p
00:03 <****> yea i will tonight:)
00:04 <****> i have been migration from 4.0 to 4.1 , 4.0 does not have utf8 ,and i got a lot of problems with some databases
00:04 <****> migrationg*
00:04 <****> Ohw ell
00:06 <****> Does anyone know any other progamming chatrooms besides this one?
00:06 <****> Skater: this is not a programming chatroom??
00:06 <****> skater yes, ajax, css, mysql
00:06 <****> Skater: /join #language
00:06 <****> xml
00:06 <****> who was a snow flow lately ? or im only one here
00:06 <****> has*
00:08 <****> #language aint even a room jsoftw
00:08 <****> *sigh*
00:08 * jsoftw slaps Alpha_AI
00:09 <****> s/room/channel/
00:09 * Alpha_AI Punches Jsoftw
00:10 <****> Phhht.
00:10 * Alpha_AI slaps jsoftw with his fist
00:12 * thumbs looks at Alpha_AI suspiciously
00:12 <****> :-)
00:21 <****> is there a webpage for mysql jobs
00:21 <****> !man replace()
00:21 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
00:22 <****> tators: yes. it's blank.
00:22 <****> hrm
00:22 <****> is there a place to look besides monster
00:23 <****> under the bed ?
00:23 <****> Hidustan Times
00:23 <****> Hindustan Times
00:23 <****> =]
00:23 <****> oh I thought you meant look FOR a monster
00:23 <****> okok I don't think the market is that bad
00:24 <****> for what ? one-eyed cripple prostitutes on C++rack?
00:24 <****> tators: you probably should think about melding a couple of skillsets, like mysql and rails or php etc.
00:24 <****> ruby, python
00:25 <****> yeah
00:25 <****> I'm going to learn php next
00:25 <****> lots of ASP.NET/IIS jobs around
00:25 <****> hrm
00:25 <****> not very familiar with asp.net
00:26 <****> quick question, I have mysqld 5.0 running on bsd, I put my.cnf into /usr/local/etc , where it should be for this os, I've used port = 3307 to change the port, and the mysqladmin variables reports that its using that port, I also use binf-address= my public ip address, but it doesn't seem to be working, is there anything else I need to put into my.cnf to bind mysqld to one ip address ?
00:27 <****> * bind-address
00:27 <****> ironpig: you use bind-address to restrict where clients can connect from
00:28 <****> heh
00:28 <****> :) that explains it.
00:28 <****> ironpig: comment it out and restart mysqld
00:28 <****> so is there a way to get mysqld to listen only to traffic on one ip only?
00:29 <****> ironpig: 3 issues; bind-address, firewall, user remote access privileges.
00:30 <****> ironpig: mysqld will listen on the server's ip address/port.
00:30 <****> yes, I am aware of the security risks... do I really need to set up a firewall to have mysqld listen to one IP address? I have multiple ips assigned to the same box.
00:31 <****> ironpig: if you run a server that offers services, you have to use a firewall. Or you will eventually be hacked.
00:32 <****> eh. fine I assume your not going to answer the question then.
00:32 <****> ironpig: how many nic devices are in the box?
00:32 <****> 2
00:32 <****> is there a good resource that explains how mysql works -- like I know all the syntax and everything, but I don't know how its actually doing everything
00:33 <****> ironpig: what other services does it host?
00:34 <****> publicly ?
00:35 <****> ironpig: you still have to attend to threats from compromised computers on your internal network.
00:37 <****> ironpig: but that's a debate for another day. You want to bind the mysqld process to just one of your nics?
00:37 <****> !man bind_address
00:37 <****> Nothing found.
00:37 <****> pfft
00:38 <****> yes.... One IP on one nic
00:39 <****> Can i change the name of a database?
00:39 <****> like by using alter database or something?
00:39 <****> !man rename database
00:39 <****> Nothing found.
00:39 <****> !google rename database
00:39 <****> rename database: http://dev.mysql.com/doc/refman/5.1/en/rename-database.html
00:39 <****> thumbs thanks
00:44 <****> are you use the bind-address is the address to which mysqld will only allow incoming connections on?
00:46 <****> thumbs that link refer's me to http://dev.mysql.com/doc/refman/5.0/en/alter-database.html
00:47 <****> I have a table of products, another of articles and another of events, I also have a "feature" table that features 1 an item from one of these tables. I can store the id of the article/product/event but how can I tell what table the id belongs to?
00:47 <****> but the conditions for doing that are only for upgrading from what i can tell - i just want to rename a database from otrs to otrs1 so i can keep that data and create a new otrs
00:47 <****> i guess i should just go about it a different way and export the data and import it to a new one
00:48 <****> Shai_Tan: Just out of curiosity, what's an article and what's a product ? article is an instance of a product?
00:48 <****> not related
00:48 <****> And wouldn't the feature table be a duplication of data, maybe you can use a view ?
00:48 <****> Shai_Tan you'll have to figure out some way to make them unique between tables
00:49 <****> yes, but how?
00:49 <****> maybe make a translation table ?? i'm not 100% sure
00:50 <****> I've never made a claim of being a developer.. but maybe you should rethink your design a bit? But I'm not sure, just seems a bit 'crazy' to me :)
00:51 <****> bz029: yes, that is a good alternate solution
00:51 <****> Shai_Tan if you have an ID that identifies products (or cars, or animals, whatever) then those products MAY NOT be scattered over multiple tables
00:51 <****> yeah i was hoping for a simple rename but its all good
00:51 <****> or you'll lose pretty much anything SQL has to offer you
00:52 <****> sadly, that is my taks
00:52 <****> you adda column "type" to the table , that's how
00:52 <****> task
Total 22 pages. You are browsing page 1/22.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last