[02:49] <itnet7> RoAkSoAx: Hey there
[04:28] <RoAkSoAx> itnet7: how's iut going man
[04:36] <sublime1> hello 
[14:04] <reya276> Morning Everyone
[14:08] <munz_werk> mornin reya276 
[14:59] <angu> hi there
[14:59] <angu> anyone here?
[15:26] <mhall119> morning
[15:31] <MichelleQ> meh
[16:01] <tiemonster> MichelleQ: hey. haven't talked to you in a while...
[16:04] <mhall119> tiemonster: you haven't been around in a while
[16:04] <mhall119> tiemonster: they're doing project lighting talks in the next Ubuntu Developer Week: https://wiki.ubuntu.com/UbuntuDeveloperWeek/Sessions
[16:05] <mhall119> at the bottom
[16:05] <mhall119> thought you might have something you open sourced that you'd like to talk about and promote for 5 minutes
[16:05] <tiemonster> I've been busy with school, work, family, FOSS ;-)
[16:05] <tiemonster> our open source project is having an initial release on March 1. very exciting.
[16:05] <mhall119> yay!
[16:06] <tiemonster> it's fun working with an Aussie, because bugs magically get fixed and features magically get added while I'm sleeping :-)
[16:06] <mhall119> tiemonster: UDW lighting session is on March 4th, so perfect timing for you to promote it!
[16:06] <tiemonster> lol. sure.
[16:07] <mhall119> add yourself to the list at the link above
[16:08] <tiemonster> it all seems very Ubuntu-focused
[16:08] <tiemonster> I'd feel out of place
[16:09] <tiemonster> although I never did that django-nonrel talk...
[16:09] <mhall119> it doesn't have to be Ubuntu-focused
[16:10] <mhall119> mine is XDG/generic desktop
[16:10] <MichelleQ> tiemonster: been a little crazy around here. 
[16:10] <tiemonster> same here
[16:10] <tiemonster> we need an excuse to party
[16:13] <MichelleQ> I'm counting down days until October
[16:16] <tiemonster> what happens in October?
[16:17] <mhall119> UDS
[16:17] <tiemonster> all these acronyms...
[16:17] <mhall119> Ubuntu Developer Summit
[16:17] <mhall119> where all the Ubuntu developers will gather in Orlango
[16:17] <tiemonster> UDS != UDW?
[16:17] <mhall119> Orlando even
[16:18] <mhall119> UDW is a week of online hour-long teaching sessions
[16:18] <mhall119> UDS is a week of 8 hour days of in-person planning for the next Ubuntu release
[16:18] <mhall119> UDS: http://uds.ubuntu.com/
[16:18] <tiemonster> there's a user week, too, right?
[16:18] <mhall119> yea
[16:19] <mhall119> well, user day (not week)
[16:19] <mhall119> there's developer week, open week, and user day
[16:19] <mhall119> all online IRC sessions
[16:19] <mhall119> UDS gathers several hundred people from around the world to one location to plan the next 6-month iteration of Ubuntu
[16:20] <mhall119> you know, that big event in Orlando last October that you missed :(
[16:20] <tiemonster> because it was for people hacking on Ubuntu itself...
[16:21] <mhall119> no
[16:21] <mhall119> it was for people working in the community too
[16:21] <tiemonster> still within the Ubuntu ecosystem
[16:21] <tiemonster> KDE, gnome, etc.
[16:21] <mhall119> again, no
[16:22] <mhall119> ask MichelleQ 
[16:22] <MichelleQ> whooseawhatsis?
[16:22] <mhall119> is UDS just for people contributing code to the desktop?
[16:22] <tiemonster> UDS?
[16:23] <MichelleQ> no
[16:24] <mhall119> tiemonster: you're going to the next UDS in Orlando if I have to drive up there and kidnap you
[16:24] <tiemonster> lol
[16:24] <tiemonster> justify it for me
[16:24] <tiemonster> my boss offered me time off last time
[16:25] <mhall119> I spent most of my time at the last one talking about django and other web technologies
[16:25] <mhall119> which have been a benefit to me here at Moffitt
[16:26] <tiemonster> Ubuntu is really committed to Django I've noticed
[16:26] <mhall119> they're really committed to Python
[16:26] <mhall119> and Django is just much easier than zope
[16:26] <mhall119> tiemonster: did you see my blog post from last week?
[16:27] <mhall119> http://family.ubuntu-fl.org/mhall/fun-with-django-meta-classes-and-dynamic-models/
[16:28] <tiemonster> did you post that on Twitter?
[16:28] <mhall119> probably not
[16:28] <tiemonster> then no
[16:28] <tiemonster> :-)
[16:28] <mhall119> but it was on planet.u.c
[16:42]  * RoAkSoAx btw... the Canonical is hiring a new member for the UBuntu Server Team
[16:56] <reya276> mhall119, hey can I PM u? I need to ask you a MySQL Q, something you had helped me with before
[16:56] <mhall119> reya276: sure
[17:21] <maxolasersquad> Is there any sort of way to call class methods statically in Python?
[17:22] <mhall119> Class.method()
[17:23] <maxolasersquad> mhall119: Thanks
[17:23] <mhall119> there's also a class method decorator
[17:23] <mhall119> @class_method I think
[17:23] <mhall119> but when doing it that way, I don't think you get 'self' as the first argument
[17:23] <mhall119> you might get the Class instead
[17:24] <maxolasersquad> TypeError: unbound method get_connections() must be called with Connection instance as first argument (got nothing instead)
[17:24] <maxolasersquad> That's what I get when I call get_connections, of the Connection class, statically.
[17:25] <maxolasersquad> If I instantiate an object and call it then it acts as I would expect.
[17:47] <mhall119> how are  you calling it?
[17:48] <reya276> general question? what is the MYSQL Installation type on a Ubuntu System? would it be Ubuntu Linux(Vendor Package) or Ubuntu Linux(MySQL Package)?
[17:49] <mhall119> reya276: I don't understand the question
[17:51] <reya276> bah never mind it was useless as it really did not matter, don't even know why they bother asking
[17:55] <maxolasersquad> mhall119: Connection.get_connections()
[17:56] <mhall119> what kind of object is Connection?
[17:57] <mhall119> if you dir(Connection), do you see get_connections?
[17:57] <maxolasersquad> mhall119: Not much of an object right now.  It will be for retrieving and storing connection credentials in seahorse.
[17:57] <mhall119> oh nice!
[17:57] <mhall119> can you pastebin the class code?
[17:58] <maxolasersquad> http://paste.ubuntu.com/567765/
[17:59] <mhall119> maxolasersquad: take 'self' out of the argument list
[17:59] <mhall119> wait, you're using self in that method?
[17:59] <maxolasersquad> Yes
[17:59] <mhall119> self == instance
[17:59] <mhall119> you can't use self from a static context
[18:00] <mhall119> bbl, meeting time
[18:44] <zoopster> itnet7: around?
[18:45] <zoopster> off-topic, but for anyone in the central florida area around the next shuttle launch I'm working with questforstars.com to help with a balloon launch and recovery simultaneously...should be very interesting if you want to help with launch or recovery
[18:58] <maxolasersquad> zoopster: Sounds like a lot of fun.
[19:21] <reya276> mhall119, how can I connect to the MYSQL server through CLI?
[19:21] <reya276> like what is the command
[19:22] <mhall119> mysql -h $host -u $user
[19:22] <mhall119> host defaults to localhost, user defaults to your unix username
[19:29] <reya276> oh I got an error 
[19:29] <reya276> mysql -h localhost -u root
[19:30] <reya276> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
[19:31] <mhall119> -p to supply a password
[19:34] <reya276> ok I was able to connect, but how will I know when the dump is completed will the CLI give me a msg? right now is at ->
[19:37] <reya276> mhall119, weird it does not seem like is doing anything
[19:38] <reya276> it just shows this '->'
[19:40] <reya276> this is the command I ran in the CLI after connecting 'mysqldump -u root --password=$pass accureports_health | mysql -u root --password=$pass accureports_wc;'
[19:40] <DammitJim> doesn't -p ask you for the password?
[19:40] <reya276> oh I'm connected to mysql
[19:41] <reya276> and after I connected I ran that command but its just sitting there showing me '->'
[19:41] <reya276> but it did not populate the other DB
[19:45] <reya276> how can I exit?
[19:51] <reya276> DannitJim, I was able to connect what I'm having issues with is running an specific command
[19:51] <reya276> and it does not seem to be running it, at least it does not show me any indication that is doing so
[19:52] <reya276> other than '->'
[19:53] <reya276> I just did '\c' to clear the command I gave it, so now I'm back at the mysql> prompt
[19:54] <reya276> after I enter the command I want to run do I have type 'go' so that it actually runs the command?
[19:57] <reya276> nope still nothing, same thing '->'
[19:59] <maxolasersquad> reya276: Instead of piping the results, can you get mysqldump to save to the filesystem?
[20:00] <reya276> what do you mean?
[20:00] <maxolasersquad> mysqldump -u root -p$pass accureports_health > dump.sql
[20:01] <reya276> right now I need to transfer the contents of one DB to another DB
[20:01] <reya276> oh I already have a dump file for that
[20:01] <reya276> but now I need to import it into a different DB called accureports_wc
[20:09] <maxolasersquad> I think you can do something like
[20:09] <maxolasersquad> mysql -u root -p$pass < dump.sql
[20:10] <maxolasersquad> Yeah, that should work
[20:11] <reya276> right but that will import it to a DB with the same name not to a Different DB with a different name which is what I need to do
[20:11] <maxolasersquad> right, hmmm ...
[20:11] <maxolasersquad> You will probably need to use sed to do a search/replace of the database in the dump file.
[20:12] <reya276> mhall119 had given me this 'mysqldump -u root --password=$pass accureports_health | mysql -u root --password=$pass accureports_wc;' script to use but I can't seem to make it work 
[20:13] <reya276> meaning I can't make the server execute it as after I hit enter it just stays at '->'
[20:13] <reya276> but nothing is happening
[20:14] <reya276> the script is not being executed is there something I need to do in addition to that to make it go
[20:14] <maxolasersquad> Well, I don't think that would create it with the new schema.
[20:14] <maxolasersquad> Maybe something like this
[20:14] <reya276> no it will not the new scheme is already created
[20:14] <reya276> all I want to do is grab the info from one DB to the other DB
[20:14] <maxolasersquad> Yes, but the mysqldump output, I believe, specifies the schema name.
[20:15] <reya276> and that script will do that
[20:15] <reya276> but I can't seem to get the server to execute it
[20:15] <maxolasersquad> You are trying to copy schemas on the same database instance?
[20:16] <maxolasersquad> mysql -u root --password=$pass accureports_wc < mysqldump -u root --password=$pass accureports_health
[20:16] <maxolasersquad> Perhaps that.
[20:17] <reya276> no that script is correct but the server is not executing it meaning that after i enter the command the prompt stays at ->
[20:17] <reya276> is there anything else that i have to do to make it run it
[20:18] <reya276> like go or run or something or the sort
[20:23] <maxolasersquad> Take out the semi-colon at the end of that.
[20:23] <maxolasersquad> I just used mhall's syntax and it worked.
[20:24] <maxolasersquad> reya276: ^^
[20:25] <reya276> right I did that too but is not working for me
[20:25] <reya276> like the damn thing is not running
[20:26] <reya276> yet both DB's are there, one is populated and the other one is not yet nothing is happening
[20:26] <maxolasersquad> On a test db I did this.
[20:26] <maxolasersquad> mysqldump db_source | mysql db_target
[20:27] <reya276> ok let me try that
[20:27] <maxolasersquad> This database was not password protected.
[20:27] <reya276> neither are these two
[20:27] <maxolasersquad> Ah, then the above should work, no need for -u root --password= ...
[20:28] <reya276> ok again nothing this is what my CLI looks like at this moment 
[20:28] <reya276> mysql> mysqldump accureports_health | mysql accureports_wc
[20:28] <reya276>     -> 
[20:29] <maxolasersquad> Run that at bash, not at the sql prompt
[20:31] <jck77> good afternoon everyone
[20:32] <reya276> at bash?
[20:32] <maxolasersquad> Yes.
[20:32] <reya276> you mean at the default server prompt
[20:32] <maxolasersquad> The command mhall gave you was a bash command, not a mysql command.
[20:32] <maxolasersquad> Yes.
[20:33] <reya276> but I thought you needed to be connected to mysql in order to run mysql commands
[20:34] <reya276> bartdev@bartdev-server:~$ mysqldump accureports_health | mysql accureports_wc
[20:34] <reya276> ERROR 1045 (28000): Access denied for user 'bartdev'@'localhost' (using password: NO)
[20:34] <reya276> mysqldump: Got error: 1045: Access denied for user 'bartdev'@'localhost' (using password: NO) when trying to connect
[20:36] <reya276> ok now I'm getting a different error when I try to run mhall119's commad from bash
[20:36] <reya276> mysqldump: Got error: 1449: The user specified as a definer ('root'@'%') does not exist when using LOCK TABLES
[20:36] <reya276> how can these tables be locked?
[20:36] <reya276> no one is using the DB
[20:48] <maxolasersquad> log into the db and try: UNLOCK TABLES;
[20:49] <maxolasersquad> I'm only somewhat familiar with MySQL, but I think you can manually lock tables.  Someone may have manually locked a table.
[20:51] <maxolasersquad> reya276: You may want to read http://fossplanet.com/f7/mysqldump-got-error-1449-user-specified-definer-root@%25-does-not-exist-when-using-lock-tables-64847/
[21:07] <reya276> thanks
[21:13] <reya276> this is what I'm using to manage my MySQL servers and do the diagrams http://wb.mysql.com/?page_id=35
[21:14] <reya276> it is an awesome tool, for those of you whom may not be 100% comfortable with CLI
[21:15] <reya276> maxolasersquad, I need to make the root user on the server to be root@% before it was root@localhost only and that is why it would fail
[21:15] <maxolasersquad> So it is working now?
[21:16] <reya276> so right now I entered the command that mhall119 gave me and it is running
[21:16] <maxolasersquad> Excellent!
[21:16] <reya276> yeap sure is
[21:16] <reya276> I'm just extremely glad that there is this MySQL WorkBench this thing is awesome
[21:19] <reya276> I very cool it also has this http://wb.mysql.com/?p=857