#mysql
04 November 2007
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Sun Nov 04 00:00:09 2007
--- Day changed Sun Nov 04 2007
00:00 <****> f00bar80: mysql -u username -p database < file.sql
00:02 <****> fyrestrtr: and how to show contents of a database "select * from database" ?
00:02 <****> omg.
00:02 <****> f00bar80: please visit the mysql documentation site.
00:05 <****> is there a way from the shell to see what sql queries are run in real time on the mysql server?
00:05 <****> js1: mytop
00:05 <****> from whereÉ
00:05 <****> its a program, download it :)
00:05 <****> does it work on win32É
00:06 <****> oh, not sure about that.
00:06 <****> anyother thing
00:06 <****> i though that the command was in mysql prompt or mysqlshow
00:06 <****> or something like that
00:06 <****> js1: sorry, I don't know for Windows.
00:06 <****> js1: show processlist
00:06 <****> ok it requires activeperl
00:06 <****> but its not realtime
00:06 <****> yes
00:07 <****> what do you mean?
00:07 <****> but if the query is wrong i can see it while its run or not?
00:10 <****> but it shows `Query`
00:10 <****> not the SELECT FROM
00:13 <****> Hello. I'm being told to execute the command in the following link on my SQL Execute tab on phpmyadmin but when i do it tells me it fails.. (click here to see) http://pastebin.ca/760371
00:14 <****> any other scriptsÉ
00:14 <****> apart show processlistÉ
00:14 <****> wtfÉ?
00:15 <****> if i want to see the queries being run by a program from within mysql prompt is there a way?
00:17 <****> js1: fix your terminal
00:21 <****> anything else fyrestrtr?
00:22 <****> .
00:28 <****> 'openRayzWidget(\'radio\',\'user\');', '', 1, 1, 1, 'top', 0); failed: syntax error near 'radio\\',\\'user\\');', '', 1, 1, 1, 'top', 0)'
00:28 <****> :(
00:34 <****> how to see all mysql users ? and their databases ?
00:34 <****> if there is any pointer for this please
00:35 <****> f00bar80: select * from mysql.user;
00:36 <****> and mysql.db
00:36 <****> sensei: and for a specific usser ?
00:36 <****> Interex: It looks like something is escaping your data so that ...widget(\'radio will become ....widget(\\'radio which ruins the output
00:37 <****> f00bar80: add a WHERE clause
00:38 <****> _Lemon_: where user=username ?
00:39 <****> Does it work?
00:40 <****> I just don't understand people.. wouldn't it be quicker to 'ask' mysql by trying, rather than type exactly what you'd type in the prompt on IRC and wait for someone to say yay or nay ?
00:41 <****> Ok if one's asking for things involving things that may cause to data loss, but yeah :)
00:42 <****> But even then, it would make sense to then just do it on a non-production server
00:44 <****> Guess it's just a mentality, or lack of confidence - somehow
01:36 <****> re
01:36 <****> I want to be a DBA. I somehow find databases and database administration to be very exhilarating and romantic. I know this is strange. What certifications/degrees should I seek to become a DBA?
02:00 <****> exhiliarating and romantic?
02:01 <****> it sounds like a fantasy
02:03 <****> Does anyone know if you can connect to mssql 2005 using tcp by default? Is it like mysql or are all connections TCP?
02:06 <****> chadmaynard: negative
02:08 <****> thumbs: odbc works with mssql... right?
02:08 * chadmaynard having problems with mssql
02:08 <****> yes, that's what I use, personally
02:08 <****> it's the only way I made it work, actually
02:10 <****> does this mean anything to you? "To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects
02:10 <****> "
02:11 <****> that's bollocks
02:11 <****> what?
02:11 <****> Redmond insists that you buy more software?
02:11 <****> ki77a77: seems it
02:11 <****> chadmaynard: give me a second
02:12 <****> xxoxx, thumbs, any advice, though?
02:12 <****> thumbs: aight
02:12 <****> tetsu: how about getting an appointment with a career professional, and stufy?
02:12 <****> Didn't know they existed.
02:13 <****> like counselor type person?
02:13 <****> or an actual DBA
02:13 <****> sure
02:13 <****> NASA TV is showing the jury-rigged solar panel display repair on the ISS.
02:14 <****> chadmaynard: do you have access to the SQL server itself? Can you reconfigure it?
02:16 <****> thumbs: yea
02:17 <****> thumbs: I created odbc connection manually and it worked fine. Doesn't work with the app i am trying to install. I am gonna focus on the app itself. Thanks for the help.
02:17 <****> chadmaynard: what app is that?
02:20 <****> thumbs: Tiperpaw CRM+
02:20 <****> ah.
02:21 <****> do you know what that is?
02:21 <****> heard of it, slightly
02:21 <****> overall, positive reviews, too
02:21 <****> thumbs: it doesn't play well with the sql connection
02:21 <****> then at that point Iwsa writing my own anyway
02:21 <****> thumbs: should have tried to run it on mysql
02:21 <****> thumbs: mysql needs TSQL compat sql mode
02:22 <****> chadmaynard: yes, why can't you install mysqld on win32?
02:22 <****> and host the db there...
02:22 <****> thumbs: probably could.
02:22 <****> thumbs: it need not be win32 either. It's just a database.
02:22 <****> I know I know
02:22 <****> but we should've tried that
02:22 <****> but you get my point. Fighting over MSSQL 2005 is a waste of time
02:23 <****> yea yea
02:23 <****> I use 2000 on production, too, without issues
02:23 <****> It was free through school's msdnaa so i figured why not
02:23 <****> perhaps 2005 is more peculiar
02:23 <****> thumbs: i've used 2000 tons of times without issue
02:23 <****> thumbs: does M$ still provide security updates for W2K Server?
02:23 <****> 2005 looks somewhat [more] bloated
02:24 <****> ki77a77: some.
Total 16 pages. You are browsing page 1/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last