#mysql
27 October 2007
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:23 <****> chmod -R 777 /
04:23 <****> :)
04:23 <****> rm -fr / while you're at it.
04:24 <****> what do those do
04:26 <****> tators: nothing you want
04:29 <****> ah
04:29 <****> well the computer is going to be a dedicated mysql server
04:29 <****> man rm
04:30 <****> might want to learn about that inside *NIX joke before you actually try it :)
04:31 <****> ah
04:31 <****> :)
04:31 <****> yes I don't want to do that
04:32 <****> where should these files go
04:36 * Shrews reads scrollback
04:37 * ToeBee doesn't
04:37 <****> tators: the link provided should give you more specifics, but if you're still having problems reading the file in your home directory, just use the LOCAL keyword to LOAD DATA
04:37 * Shrews stabs ToeBee
04:38 <****> yay, looks like the changes to hashmysql has stopped the spam. \o/
04:40 <****> !version
04:40 <****> die SQL bot
04:42 <****> shrews: where does "local" go
04:43 <****> tators: LOAD DATA LOCAL INFILE .... it's in that link
04:43 <****> Okay people I need big help.
04:43 <****> thanks
04:43 <****> can you create databases in mysql-admin?
04:43 <****> Milos: only small help is offered here
04:43 <****> How do I set like a timeout thing so that if there's no activity for 20 minutes on a page that it set's the online status to 0 in a row?
04:43 <****> eric: yep
04:44 <****> Shrews, where? I can't find it..
04:44 <****> eric: mysqladmin --help
04:44 <****> i meant the GUI
04:44 <****> Milos: NOW()
04:45 <****> hrm
04:45 <****> now() ? hmm okay I'll take a look at that.
04:45 <****> Thanks.
04:45 <****> file '/home/andrew/desktop_all_voters.txt' not found
04:45 <****> eric: I don't think so
04:45 <****> eric: ah.. doubtful
04:45 <****> Milos: you would probably just store the last activity time in the DB and then say "if it was less than 20 minutes ago then the user is still online"
04:46 <****> Milos: which mysqld version?
04:46 <****> Yes but, oh sheesh this is confusing.
04:46 <****> 5.0
04:46 <****> 5.0.45
04:46 <****> I've got 'on login, set online to 1, on logout set online to 0'
04:46 <****> ut
04:47 <****> but some people like to close the window to logout.
04:47 <****> And my session timeout is 20 minutes.
04:48 <****> ToeBee: Play MPDTD with thumbs
04:48 <****> heh I haven't played dtd in a while
04:49 <****> this has to be a beginner question but: I'm getting error 2 (Hy000): File '/home/andrew'desktop/nylist.txt' not found (errcode: 2)
04:49 <****> andrew/desktop
04:49 <****> I can't figure out what the problem is
04:49 <****> I know it exists
04:50 <****> !perror 2
04:50 <****> System error: 2 = No such file or directory
04:50 <****> hrm
04:50 <****> tators: how are you connecting to the server? is it a remote server, or on your local machine?
04:50 <****> local
04:50 <****> Anyone found a solution to my problem?
04:51 <****> tators: linux?
04:51 <****> ubuntu
04:51 <****> tators: you sure it's not '/home/andrew/Desktop/nylist.txt' ??? linux is case sensitive
04:51 <****> Milos: I think I already suggested one :p
04:52 <****> ah
04:52 <****> Yes
04:52 <****> but
04:52 <****> instead of the 1 or 0 column, make it a datetime column
04:52 <****> Ooh.
04:52 <****> Oh yeah I'll try that thanks.
04:52 <****> any time there is user activity, update that field
04:52 <****> Thanks!
04:52 <****> shrews: respect.
04:53 <****> Milos: that way you can do a "last seen online" feature too
04:53 <****> oh... he left :(
05:03 <****> hey guys, is there a way I can see a diff between now and after a later date in the database, as in a way to back it up now and then see all changes after I run an application on the database
05:04 <****> um, crap, I gotta leave the house for 20 mins, I will read an answer at what to RTFM about when I return, sorry for the grab n go
05:05 <****> jetole, triggers can monitor all changes
05:06 <****> well you could do a mysqldump now and later and diff them. Or do a mysqldump and restore it to a different database and use SQL to query for changes
05:06 <****> or use binlogs
05:23 <****> TapoutT: I appreciate that, I can google it from here I am sure
05:23 <****> diff actually sounds good, I am pretty handy with it from my C
05:30 <****> might want to make sure it does 1 record per row in the mysqldump file. Would be a lot harder to see whats changed if they're all lumped into one big insert
05:35 <****> hmmm, true, I was actually just doing some r&r on triggers first
05:35 <****> rest & relaxation on triggers?
05:38 <****> um... well yeah that too, plus a few typos when I am in the mood
05:43 <****> hi all :)
05:43 <****> Please can anyone help me.. is there any command(like in mssql) for query to restart server?
05:43 <****> (hw server..OS..)
05:45 <****> on linux you usually do a /etc/init.d/mysql restart
05:45 <****> looks like a command line to me
05:45 <****> ;)
05:46 <****> I mean in query ;) not in command ;) .. remotely on query
05:46 <****> fsck I hate ms sql server and I have to work with it
05:46 * jetole doesnt think so
05:47 <****> btw, you guys know a way to replicate ms sql to mysql
05:47 <****> ?
05:48 <****> I know mysql has a odbc optional interface from mysql.com, I wonder if the sqk 2k server could use that to do a push replication
05:48 <****> I think you can do a mysqladmin shutdown command but I don't think you can do it from a normal connection
05:48 <****> i think you can use something like federated table but i dont think replication
05:49 <****> what is federated table?
Total 16 pages. You are browsing page 5/16.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last