#mysql
30 October 2007
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
03:07 <****> ?
03:07 <****> add -h to your mysql commandline arguments
03:08 <****> tigerplug292, mysql -u shanek -pmypasswordhere -h mysql.mydomain.com t eredluin_smf1 < import.sql
03:08 <****> what do you mean like -h mysql.mydomain.com -h u shanek -pmypassword database < file.sql?
03:08 <****> Im not sure if I understand :(
03:10 <****> aw well, Im lost now!
03:11 <****> hi guys, i am having problems connecting to mysql DB. I use cpanel, i created the DB, created the user, asigned the user to the db but mysq_connect('localhost','user','password'); gives me error. It says user@localhost password yes
03:11 <****> and wont connect
03:11 <****> in the same boat... I think
03:13 <****> you have the same problem?
03:13 <****> think I fixed it :)
03:13 <****> yeah, but Im using dreamhost, they use their own control panel
03:14 <****> can you give me an example of how you connected?
03:14 <****> doesn't dreamhost have docs on how to connect?
03:14 <****> tigerplug292: necrotic told you exactly what to do...
03:14 <****> also, the database server may be different to localhost..
03:16 <****> Are there really 431 people in this chat?
03:17 <****> no, some of us are bots :P
03:17 <****> thank you
03:18 <****> I'm not quite sure how I arrived here but I was looking for a Spanish chat.
03:18 <****> no es aqui, cabron.
03:18 <****> OK entonces donde?
03:19 <****> though spanish is optional...
03:19 <****> dave10: mysql has meaning in spanish?
03:19 <****> maybe mysql has spanish users
03:19 <****> and what is that meaning
03:19 <****> .. which is why this showed up
03:19 <****> but thats just crazy talk
03:19 <****> If I check on "channels" above does it give me a complete of available channels?
03:20 <****> list of available channels.
03:20 <****> tigerplug292, i just explained
03:20 <****> dave10: You probably don't want a list of all channels. That would probably flood you off the network. :)
03:20 <****> thank you
03:21 <****> JohnRobert, for me the server says localhost
03:21 <****> dave10: freenode might have a web site listing many/all of the registered channels.
03:21 <****> not exactly... but more importantly, I'm not sure freenode hosts NATURAL language channels
03:21 <****> jmoncayo : I know and thanyou. I hate to be an annoyance but it looks like the file imported, however when I check I dont see all the data on the site. Cleared my cache and refreshed and still the same.
03:21 <****> anyone?
03:22 <****> tigerplug292, ohhh, i dont know, my files are there, but i cant connect
03:22 <****> =S
03:23 <****> thanks anyway
03:59 <****> is it ok to expose a mysql server to the internet? how's the security record? what about encryption?
04:02 <****> padde: It's probably not a good idea to expose any protocol server, beyond http and maybe a few others.
04:03 <****> padde: Databases tend to have some private information and that's a reason you normally expose some application layer via http directly to public access and let the application control database access.
04:05 <****> padde: There's no absolute rule, however. It's up to you whether you expose a database to public connections and what level of sensitive data is contained in the database.
04:05 <****> Xgc: ok... so that means, if i need people from some other branch office accessing my database securely, we need to set up a vpn.
04:05 <****> padde: That would be one common approach. Yes.
04:06 <****> Xgc: ok... thanks!
04:09 <****> anyone need help?
04:09 <****> no
04:10 <****> shocking
04:10 <****> residentgrey: i do
04:10 <****> me too
04:10 <****> how so
04:10 <****> how can you tell the size of an individual index?
04:10 <****> dunno right now
04:11 <****> in innodb table
04:11 <****> :X
04:11 <****> when will you know?
04:11 <****> hmmm
04:12 <****> i wasw just trying to goad people into asking stuff so they can move on, to stop the lurkage, and maybe fire off a luky answer
04:12 <****> i'm not sure if it worked
04:13 <****> start from an empty bufferpool, select index_col from table, this will load the index into bufferpool, check how many pages used, maybe not exactly accurate
04:13 <****> you mean size as in tbl size?
04:13 <****> now many entries?
04:13 <****> h
04:13 <****> kimseong: ;)
04:13 <****> or for each member
04:13 <****> h back at ya
04:13 <****> what type of field should i use for 2 digit numerics only?
04:14 <****> whatever that means LOL
04:14 <****> tinyint
04:14 <****> residentgrey: lol :D
04:14 <****> jbalint: i know the question is for the fun of it :)
04:14 <****> THOL
04:14 <****> kimseong: yeah, thats a reasonable answer, thanks :)
04:14 <****> tinyint is a 16bit in right?
04:14 <****> no,8
04:14 <****> ahh
04:14 <****> smallint is 16
04:14 <****> kk
04:15 <****> didnt know there were both
04:15 <****> im real rusty with mysql
04:15 <****> been like a year since i messed with it on me old 446 mhz lappie
04:15 <****> 446... thats a new one
04:15 <****> heh
04:16 <****> what brand?
04:16 <****> the things i did with that one were amazing
04:16 <****> things i shouldnt have been able to do
04:16 * jbalint still has a running 166MHz pentium pro :p
04:16 <****> some nice 3d renderings for one
04:16 <****> cool
04:16 <****> took about 2 days but it got the job done
04:16 <****> How about for a 1 letter alphabetic entry ?
04:16 <****> kinda type
04:16 <****> gentoodude: char(1)
04:16 <****> gentoodude: set the charset correctly and it will be fine
04:17 <****> ahh cuz of whar_t for unicode
04:17 <****> well, its not like that in mysql
04:17 <****> there is no char/wchar
Total 22 pages. You are browsing page 5/22.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last