| itnet7 | RoAkSoAx: Hey there | 02:49 |
|---|---|---|
| RoAkSoAx | itnet7: how's iut going man | 04:28 |
| sublime1 | hello | 04:36 |
| reya276 | Morning Everyone | 14:04 |
| munz_werk | mornin reya276 | 14:08 |
| angu | hi there | 14:59 |
| angu | anyone here? | 14:59 |
| mhall119 | morning | 15:26 |
| MichelleQ | meh | 15:31 |
| tiemonster | MichelleQ: hey. haven't talked to you in a while... | 16:01 |
| 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:04 |
| 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:05 |
| 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:06 |
| mhall119 | add yourself to the list at the link above | 16:07 |
| tiemonster | it all seems very Ubuntu-focused | 16:08 |
| tiemonster | I'd feel out of place | 16:08 |
| tiemonster | although I never did that django-nonrel talk... | 16:09 |
| mhall119 | it doesn't have to be Ubuntu-focused | 16:09 |
| 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:10 |
| MichelleQ | I'm counting down days until October | 16:13 |
| tiemonster | what happens in October? | 16:16 |
| 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:17 |
| 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:18 |
| 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:19 |
| 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:20 |
| 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:21 |
| 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:22 |
| MichelleQ | no | 16:23 |
| 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:24 |
| 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:25 |
| 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:26 |
| mhall119 | http://family.ubuntu-fl.org/mhall/fun-with-django-meta-classes-and-dynamic-models/ | 16:27 |
| 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:28 |
| * RoAkSoAx btw... the Canonical is hiring a new member for the UBuntu Server Team | 16:42 | |
| 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 | 16:56 |
| maxolasersquad | Is there any sort of way to call class methods statically in Python? | 17:21 |
| mhall119 | Class.method() | 17:22 |
| 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:23 |
| 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:24 |
| maxolasersquad | If I instantiate an object and call it then it acts as I would expect. | 17:25 |
| mhall119 | how are you calling it? | 17:47 |
| 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:48 |
| mhall119 | reya276: I don't understand the question | 17:49 |
| reya276 | bah never mind it was useless as it really did not matter, don't even know why they bother asking | 17:51 |
| maxolasersquad | mhall119: Connection.get_connections() | 17:55 |
| mhall119 | what kind of object is Connection? | 17:56 |
| 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:57 |
| maxolasersquad | http://paste.ubuntu.com/567765/ | 17:58 |
| 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 | 17:59 |
| mhall119 | bbl, meeting time | 18:00 |
| zoopster | itnet7: around? | 18:44 |
| 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:45 |
| maxolasersquad | zoopster: Sounds like a lot of fun. | 18:58 |
| reya276 | mhall119, how can I connect to the MYSQL server through CLI? | 19:21 |
| reya276 | like what is the command | 19:21 |
| mhall119 | mysql -h $host -u $user | 19:22 |
| mhall119 | host defaults to localhost, user defaults to your unix username | 19:22 |
| reya276 | oh I got an error | 19:29 |
| reya276 | mysql -h localhost -u root | 19:29 |
| reya276 | ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) | 19:30 |
| mhall119 | -p to supply a password | 19:31 |
| 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:34 |
| reya276 | mhall119, weird it does not seem like is doing anything | 19:37 |
| reya276 | it just shows this '->' | 19:38 |
| 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:40 |
| 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:41 |
| reya276 | how can I exit? | 19:45 |
| 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:51 |
| reya276 | other than '->' | 19:52 |
| reya276 | I just did '\c' to clear the command I gave it, so now I'm back at the mysql> prompt | 19:53 |
| reya276 | after I enter the command I want to run do I have type 'go' so that it actually runs the command? | 19:54 |
| reya276 | nope still nothing, same thing '->' | 19:57 |
| maxolasersquad | reya276: Instead of piping the results, can you get mysqldump to save to the filesystem? | 19:59 |
| reya276 | what do you mean? | 20:00 |
| maxolasersquad | mysqldump -u root -p$pass accureports_health > dump.sql | 20:00 |
| 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:01 |
| maxolasersquad | I think you can do something like | 20:09 |
| maxolasersquad | mysql -u root -p$pass < dump.sql | 20:09 |
| maxolasersquad | Yeah, that should work | 20:10 |
| 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:11 |
| 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:12 |
| 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:13 |
| 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:14 |
| 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:15 |
| maxolasersquad | mysql -u root --password=$pass accureports_wc < mysqldump -u root --password=$pass accureports_health | 20:16 |
| maxolasersquad | Perhaps that. | 20:16 |
| 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:17 |
| reya276 | like go or run or something or the sort | 20:18 |
| maxolasersquad | Take out the semi-colon at the end of that. | 20:23 |
| maxolasersquad | I just used mhall's syntax and it worked. | 20:23 |
| maxolasersquad | reya276: ^^ | 20:24 |
| reya276 | right I did that too but is not working for me | 20:25 |
| reya276 | like the damn thing is not running | 20:25 |
| 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:26 |
| 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:27 |
| 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:28 |
| maxolasersquad | Run that at bash, not at the sql prompt | 20:29 |
| jck77 | good afternoon everyone | 20:31 |
| 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:32 |
| reya276 | but I thought you needed to be connected to mysql in order to run mysql commands | 20:33 |
| 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:34 |
| 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:36 |
| maxolasersquad | log into the db and try: UNLOCK TABLES; | 20:48 |
| maxolasersquad | I'm only somewhat familiar with MySQL, but I think you can manually lock tables. Someone may have manually locked a table. | 20:49 |
| 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/ | 20:51 |
| reya276 | thanks | 21:07 |
| reya276 | this is what I'm using to manage my MySQL servers and do the diagrams http://wb.mysql.com/?page_id=35 | 21:13 |
| reya276 | it is an awesome tool, for those of you whom may not be 100% comfortable with CLI | 21:14 |
| 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:15 |
| 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:16 |
| reya276 | I very cool it also has this http://wb.mysql.com/?p=857 | 21:19 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!