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