| reya276 | Morning Everyone | 15:41 |
|---|---|---|
| reya276 | does anyone know if there is an app that allows you to extract .zipx files? | 15:41 |
| maxolasersquad | reya276: http://ubuntuforums.org/showpost.php?p=8936071&postcount=6 | 15:47 |
| reya276 | thanks | 15:56 |
| reya276 | damn winzip people suck | 16:14 |
| reya276 | 7Zip is free right | 16:14 |
| DammitJim | yes, 7Zip | 16:18 |
| DammitJim | how about winrar? | 16:18 |
| 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 | 16:31 |
| 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:23 |
| mhall119 | why does it need to be renamed? | 17:24 |
| reya276 | because I need the same exact Db but with a different name | 17:24 |
| mhall119 | create the new db, then run "mysqldump olddbname | mysql newdbname" | 17:25 |
| reya276 | oh cool | 17:28 |
| reya276 | mhall119, thanks | 17:33 |
| 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:34 |
| 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:35 |
| 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:36 |
| 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:37 |
| 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:39 |
| 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:40 |
| 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:41 |
| mhall119 | then view accureports_health.sql | 17:42 |
| reya276 | http://paste.ubuntu.com/533930/ | 17:42 |
| mhall119 | oh, no no no | 17:42 |
| 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:43 |
| reya276 | ok now I got this http://paste.ubuntu.com/533931/ | 17:44 |
| mhall119 | okay, so you need to specify a username and password to use | 17:45 |
| 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:46 |
| 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:47 |
| 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:48 |
| reya276 | mhall119, ok I created the rangeles user in the MYSQL with access as localhost and I still get the same messege | 17:49 |
| 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:50 |
| 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:54 |
| 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:55 |
| 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:56 |
| 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:57 |
| 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:58 |
| 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 | 17:59 |
| 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:00 |
| 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:01 |
| 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:03 |
| tiemonster | have to | 18:04 |
| tiemonster | what's so bad about it? | 18:04 |
| mhall119 | you'll find out | 18:05 |
| mhall119 | it's a big complex mess | 18:05 |
| tiemonster | I don't know their reasoning for choosing it | 18:06 |
| 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:07 |
| mhall119 | Maven, to me, seemed like someone tried to turn Ant into Launchpad | 18:08 |
| 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:09 |
| tiemonster | ROFL | 18:11 |
| 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? | 18:17 |
| mhall119 | dantalizing: what's the best way to run multiple wordpress sites without having multiple copies to keep updated? | 19:00 |
| 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:01 |
| reya276 | tiemonster, it has them | 19:02 |
| reya276 | only localhost can connect to it at the moment | 19:02 |
| reya276 | and only root user | 19:03 |
| tiemonster | right - set perms for correct IP | 19:03 |
| reya276 | tiemonster, oh yeah once we go live we do that part not until then | 19:20 |
| 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:27 |
| 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:28 |
| dantalizing | you could use virt-manager to spawn off some kvms quite easily .. .just more hardware overhead | 19:29 |
| 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 | 19:33 |
| itnet7 | dantalizing: ping | 20:37 |
| dorgan | does anyone know how to go to a specific column on a given line using less? | 21:04 |
| 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:07 |
| 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:08 |
| dorgan | ahh i figured it out | 21:09 |
| dorgan | type in the column number then hit pipe | 21:10 |
| === Michelle is now known as Guest64398 | ||
| Guest64398 | iPod irc. Woot. | 21:29 |
| govatent | hello world! | 22:16 |
| dantalizing | itnet7: pong | 22:31 |
| dantalizing | itnet7: on my way home .. i'll catch up with you later.... | 22:31 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!