[15:41] <reya276> Morning Everyone
[15:41] <reya276> does anyone know if there is an app that allows you to extract .zipx files?
[15:47] <maxolasersquad> reya276: http://ubuntuforums.org/showpost.php?p=8936071&postcount=6
[15:56] <reya276> thanks
[16:14] <reya276> damn winzip people suck
[16:14] <reya276> 7Zip is free right
[16:18] <DammitJim> yes, 7Zip
[16:18] <DammitJim> how about winrar?
[16:31] <tiemonster> zoopster: ping
[16:31] <zoopster> yo tiemonster
[16:31] <tiemonster> zoopster: hey there. mind if we private message? I have top secret stuff to discuss. ;-)
[16:31] <zoopster> np
[17:23] <reya276> hey does anyone know how I can rename a database in MYSQL
[17:23] <mhall119> I'm not sure you can, why?
[17:23] <reya276> because I have a DB that I need to rename
[17:24] <mhall119> why does it need to be renamed?
[17:24] <reya276> because I need the same exact Db but with a different name
[17:25] <mhall119> create the new db, then run "mysqldump olddbname | mysql newdbname"
[17:28] <reya276> oh cool
[17:33] <reya276> mhall119, thanks
[17:34] <reya276> let me give it a shot
[17:34] <reya276> oh wait I have to do this through CLI?
[17:34] <mhall119> yeah
[17:34] <mhall119> there may be a GUI way to do it
[17:34] <mhall119> but CLI will be easier 
[17:34] <reya276> how do you connect to the CLI in mysql
[17:35] <mhall119> "mysql -u $username -h $hostname --password=$passwd dbname"
[17:35] <mhall119> if it's localhost, your mysql username is the same as your login, and you don't have a password set, you can just "mysql dbname"
[17:36] <mhall119> mysqldump takes the same parameters
[17:36] <mhall119> mysqldump will export all your tables and data as SQL
[17:36] <mhall119> mysql (the command) will execute any SQL passed to it's STDIN
[17:37] <mhall119> "mysqldump olddb | mysql newdb" sends all of the table and data SQL from olddb, and executes it on newdb
[17:37] <mhall119> think of it like backup and restore
[17:39] <reya276> ok I ran that command but I just got this "->" afterwards
[17:39] <mhall119> paste exactly the command you ran (with password replaced by **** of course)
[17:40] <reya276> mysqldump accureports_health | mysql acoreports
[17:40] <mhall119> hmmmm....
[17:40] <mhall119> -> usually means you didn't end a statement with ;
[17:40] <mhall119> but mysqldump should always do that
[17:41] <mhall119> is this a big database?
[17:41] <mhall119> or relatively small?
[17:41] <reya276> ok now I did this mysqldump accureports_health | mysql acoreports; and I got an error
[17:41] <mhall119> do "mysqldump accureports_health > accureports_health.sql"
[17:42] <mhall119> then view accureports_health.sql
[17:42] <reya276> http://paste.ubuntu.com/533930/
[17:42] <mhall119> oh, no no no
[17:43] <reya276> nope still the same error
[17:43] <mhall119> "mysqldump accureports_health | mysql acoreports" gets run from bash
[17:43] <reya276> right you mean CLI right
[17:43] <mhall119> not from within the mysql client
[17:43] <reya276> ok then how do I exot
[17:43] <mhall119> when you see "mysql>" that means you're inside the mysql client
[17:43] <reya276> exit
[17:43] <mhall119> quit;
[17:44] <reya276> ok now I got this http://paste.ubuntu.com/533931/
[17:45] <mhall119> okay, so you need to specify a username and password to use
[17:46] <mhall119> mysqldump -u $username --password=$passwd accureports_health | mysql -u $username --password=$passwd acoreports
[17:46] <tiemonster> or just -p and it will prompt you
[17:46] <tiemonster> then your mysql password isn't in your bash history
[17:46] <mhall119> yes, you can do that too
[17:46] <mhall119> you'll be prompted for it twice though, once for mysqldump and again for mysql
[17:47] <tiemonster> I think you may be right
[17:47] <tiemonster> do we have any graphic designers in the group?
[17:47] <mhall119> I think reya276 is good at that
[17:48] <tiemonster> we're having a logo contest for our open source project
[17:48] <mhall119> are the details online?
[17:48] <tiemonster> an angel investor gave us $375 as a cash prize
[17:48] <reya276> that is me
[17:48] <tiemonster> yep
[17:48] <mhall119> tiemonster: link?
[17:48] <reya276> but I have to finish this SQL thing first
[17:48] <tiemonster> http://99designs.com/logo-design/contests/professional-looking-logo-web-based-data-analysis-tool-57854
[17:48] <tiemonster> unlimited submissions
[17:49] <reya276> mhall119, ok I created the rangeles user in the MYSQL with access as localhost and I still get the same messege
[17:50] <tiemonster> sorry - $325
[17:50] <mhall119> reya276: you can just use the username and password you already were using to connect via the workbench
[17:54] <reya276> ok now I got this http://paste.ubuntu.com/533935/
[17:54] <dantalizing> morning
[17:54] <reya276> tiemonster, what does Saiku stand for?
[17:55] <reya276> mhall119, do you want me to enter this entire line in the CLI mysqldump -u $username --password=$passwd accureports_health | mysql -u $username --password=$passwd acoreports
[17:56] <reya276> or is it one at a time meaining mysqldump -u $username --password=$passwd accureports_health
[17:56] <reya276> and then mysql -u $username --password=$passwd acoreports
[17:56] <mhall119> reya276: they whole thing
[17:56] <mhall119> with the |
[17:57] <mhall119> so that the output from mysqldump gets sent to the input for mysql
[17:57] <reya276> ok I did that and then I got that last error I sent
[17:57] <reya276> http://paste.ubuntu.com/533935/
[17:57] <mhall119> take off the .sql
[17:58] <tiemonster> reya276: it's a Japanese knife. it's all explained in the design brief.
[17:58] <reya276> mhall119, I remove the .sql and it started to work
[17:59] <mhall119> tiemonster: where is the design brief?
[17:59] <mhall119> reya276: okay, sounds like it's working now
[17:59] <tiemonster> top left, where it says "read the brief"
[17:59] <mhall119> when it's done, you'll have the exact same data in both accureports_health and acoreports databases
[17:59] <mhall119> you can drop the old one when you're happy that the new one is correct
[18:00] <reya276> tiemonster, as soon as I finish doing this SQL thing I will look at it
[18:00] <mhall119> tiemonster: is your school spinning off a startup?
[18:00] <mhall119> oh wait, I think I recall you telling us about this
[18:00] <tiemonster> yeah, no.
[18:00] <tiemonster> this is the open source project I'm contributing to
[18:01] <mhall119> ok
[18:01] <mhall119> not related to your work then
[18:01] <tiemonster> they're paying me to contribute
[18:01] <tiemonster> 30 hrs/week most weeks
[18:03] <mhall119> nice
[18:03] <tiemonster> except the server-side team has ground to a halt
[18:03] <mhall119> you should get stock options on the startup too
[18:03] <tiemonster> I keep asking them to teach me maven so I can contribute on the backend, too
[18:03] <mhall119> ugh
[18:03] <mhall119> you don't want to learn maven
[18:04] <tiemonster> have to
[18:04] <tiemonster> what's so bad about it?
[18:05] <mhall119> you'll find out
[18:05] <mhall119> it's a big complex mess
[18:06] <tiemonster> I don't know their reasoning for choosing it
[18:07] <mhall119> this is java?
[18:07] <mhall119> I'm betting they have a lot of Apache stuff too
[18:07] <tiemonster> java+tomcat
[18:07] <tiemonster> or *on* tomcat
[18:07] <tiemonster> it builds a WAR file
[18:08] <mhall119> Maven, to me, seemed like someone tried to turn Ant into Launchpad
[18:09] <mhall119> you know the saying, "XML is like violence, when a little doesn't work use some more"?  That's Maven
[18:09] <mhall119> xml + violence
[18:11] <tiemonster> ROFL
[18:17] <reya276> mhall119, ok it copied all the tables and views but I can't add any information to the table
[18:17] <mhall119> what do you mean?
[19:00] <mhall119> dantalizing: what's the best way to run multiple wordpress sites without having multiple copies to keep updated?
[19:01] <mhall119> if I can keep them isolated, that's be good too, so different users could access their own install, but not the system-wide or other people's installs
[19:01] <tiemonster> reya276: set perms on the new db
[19:02] <reya276> tiemonster, it has them
[19:02] <reya276> only localhost can connect to it at the moment
[19:03] <reya276> and only root user
[19:03] <tiemonster> right - set perms for correct IP
[19:20] <reya276> tiemonster, oh yeah once we go live we do that part not until then
[19:27] <dantalizing> mhall119: lxc?  there is wordpress mu, but i've never tried it
[19:27] <mhall119> I'm thinking I'll just use separate instances, it'll only be for 2 or 3 sites
[19:28] <dantalizing> i still like openvz ... but lxc has linus' blessing in the kernel
[19:28] <mhall119> yeah, too much hassle for what I need
[19:29] <dantalizing> you could use virt-manager to spawn off some kvms quite easily .. .just more hardware overhead 
[19:33] <zoopster> mhall119: I tried multi-site wp...too much hassle
[19:33] <zoopster> I now just update via svn regularly
[19:33] <zoopster> I could automate it, but I haven't
[20:37] <itnet7> dantalizing: ping
[21:04] <dorgan> does anyone know how to go to a specific column on a  given line using less?
[21:07] <mhall119> dorgan: just ike vi
[21:07] <mhall119> the number then capital G
[21:07] <dorgan> mhall119: never needed to use vi to do that
[21:07] <mhall119> oh wait, column...
[21:07] <dorgan> ahh ok
[21:07] <dorgan> yeah
[21:07] <dorgan> :)
[21:07] <mhall119> that'll only do line
[21:08] <dorgan> something i am looking at says   [count]|
[21:08] <dorgan> but what is count
[21:08] <mhall119> yeah, I don't think that's something less can do
[21:08] <mhall119> that format is dependent on the program generating the output
[21:09] <dorgan> ahh i figured it out
[21:10] <dorgan> type in the column number then hit pipe
[21:29] <Guest64398> iPod irc.  Woot.
[22:16] <govatent> hello world!
[22:31] <dantalizing> itnet7: pong
[22:31] <dantalizing> itnet7: on my way home .. i'll catch up with you later....