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