| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> 'mysql' directory.
<1> uh... don't do what I said, for real
<2> nater: np, but why do you have 4 employee columns?
<3> I want a completely fresh install
<0> sjrussel, :)
<3> where is that?
<3> under ubuntu
<0> Depends on your datadir
<0> Try /var/lib
<3> k
<4> jivedue: because the requirements are weird
<5> something *under* /var/lib, not *all* of it!
<6> TTT_Travis, in Synaptic do a complete removal
<3> yep
<3> well all I have is commandline
<0> Who needs /var anyways? Bunch of crap
<2> nater: why not just have a projects table with a project_id, then a employee_projects table with (project_id, employee_id)?
<5> will[werk]: you mean, like /var/www/?
<0> /home is worthless too. Everything should be in /root
<1> while you're at it, /etc could be cleaned up
<0> Duesentrieb, /usr/local/apache2/htdocs :P
<7> everything should be in /
<5> who needs files?
<1> uh, everything IS in /
<5> files ****.
<0> sjrussel, :)
<4> jivedue: eh.... its ummm... strange, really
<7> it should use a tablespace that floats in our heads
<7> plugin to the tablespace
<5> shabbs: naw, raw partitions
<1> nater - that feeling of wrongness is the realization that it's wrong, deep down somewhere
<2> nater: okay, just a suggestion, I'm not really going to drill you for it
<7> safe drilling
<3> whats the default root p***word?
<2> I don't know how to respond to that..
<2> how about, "guard!"
<0> TTT_Travis, Blank, Zip, Nada
<3> hmmm
<3> it say's theres one
<0> Litterally... mysql -uroot -pblankzipdata
<0> I'm safe. Only been with Therion
<3> even after removing /var/lib/mysql
<1> ... and everyone he's been with, by proxy. Yikes!
<0> TTT_Travis, If you removed /var/lib/mysql, you have to reinstall MySQL. Need to shut the binary down, delete dir, reinstall, then all should be well.
<3> now I'm locked out of mysql
<3> k
<2> TTT_Travis: try the back door
<0> Wait....
<3> is there an easier way to reinstall with apt-get?
<1> too slow
<6> TTT_Travis, sudo apt-get install --reinstall {packagename}
<5> apt-get erase; apt-get install ?
<5> but i don't think that will delete that data dir
<0> Why can't people just use the MySQL binary?
<5> in fact, i would kill the programmers if it would
<3> k
<7> will[werk]: because it's much easier to type some silly package command and hope for the best
<8> nater: The response is pretty much unanimous. You'll eventually feel the pain. You may not realize why.
<0> Duesentrieb, It doesn't. Had people complain about it before.
<1> it'll probably be will, waiting at the back door
<0> Or was that install_db?
<2> Xgc: isn't "pretty much unanimous" a bit of an oxymoron?
<7> kinda like will
<3> there we go
<3> all good now
<0> shabbs, No, I'm just a moron.
<0> Not of the oxy type
<7> well do you smell like oxen? might qualify then
<8> Jivedue: Maybe a little bit.
<5> will[werk]: that'S like... uninstalling word would erase all your word files.
<2> that reminds me of when I was younger and asked my older friend what "mediocre" meant, and he came up with this brilliant response: "You know Medieval? Well that means 'kind of evil'. So mediocre means 'kind of ocre'"..
<7> and it should
<7> if you can't open it, you have no use for 'em
<5> shabbs: who sais I can't open them?
<9> what's this about okra?
<8> Just another color spelled wrong.
<8> or is that colour?
<7> okra is a color?
<10> mmm okra
<8> ochre is a color.
<8> That's what I heard.
<2> and ocre is part of my silly story
<11> What is going on if i have a ^T in the output of a sql file ?
<7> what's a ^T?
<12> probably a tab ..
<8> ^I is tab.
<11> made insert statements in a while loop in PHP
<7> where is this ^T?
<13> Hey, i'm running mysql 4.1.11 on linux. I have a backup mysql.sql of over 10GB that i need imported. But the .sql also includes the mysql database. Doing mysql -u user < mysql.sql halts on the error when getting to the mysql database.
<4> basically i'm under a tight deadline and i'm working on a db that's already in use
<7> the error? there's only one?
<13> ERROR 1050 (42S01) at line 4492: Table 'columns_priv' already exists
<14> t-start: Employ your text-munging language of choice to omit it.
<14> Or restore over it, if that's what you want.
<13> 'over it' ? How can i 'overwrite' an existing database when importing ?
<13> It's a 10GB file.. i can't 'search' through the file and cut the mysql database
<15> what does "desc limit 1" mean?
<15> the desc part?
<7> it's part of the order by before it
<14> t-start: Sure you can. MySQL is about to handle 10GB of data, so other things on the same computer can too.
<7> order by whatever desc (descending)
<14> t-start: You overwrite an existing database by dropping it first.
<14> You'd probably have to start mysql without grant tables, though.
<7> or add drop database mysql; right before it creates it
<1> you could just do -f to ignore errors
<1> but, that's not the safest of options
<10> A proper dump will include the DROP statements making it unnecessary, as long as the user has proper privileges
<10> Just need to FLUSH PRIVILEGES after
<11> shabbs, its a weird thing, in phpmyadmin it apperes as a '-' but if i cut and paste it in vim, it becomes a opposite '?'
<7> so it's probably a unicode character or somethin, or just something outside the normal ascii range
<11> it also apperes as ^T or ^V
<11> How do i get around ?
<7> is it bugging you?
<11> i made an export that wont import
<7> what's the error?
<5> ovis: make sure you have the charsets configured right...
<5> if it works in one DB, wit works in another.
<5> (chances are, it's an –, btw)
<16> !man binary operators
<17> Nothing found.
<16> !man binary operations
<17> Nothing found.
<16> ...!
<15> shabbs: thanks.
<11> Duesentrieb thats what i am trying to find out now
<18> http://lists.voscur.org/surveys/admin/manage.php what's going on here
<18> where and what do i configure to load the mysql extension
<7> seems more like a php question
<11> maby it got something to do with the Collation
<7> !m jink operators
<17> jink: (Operators) : http://dev.mysql.com/doc/mysql/en/Non-typed_Operators.html
<16> yeah, tnx, found it already
<16> !man bit functions
<17> (Bit Functions) : http://dev.mysql.com/doc/mysql/en/Bit_functions.html
<19> hi!
<19> there are some posibility to usage MySQL without case-sensitive under Linux?
<0> genar, Table names and such?
<0> Or data in columns?
<19> both
<11> mmh one database is latin1 and the other is swedish
<19> i trying to migrate one aplication from access to mysql
<11> d
<19> and this aplication is bad writted
Return to
#mysql
or
Go to some related
logs:
crclient
AMBROSH
#gentoo
#math mbot
conky refresh kde desktop
installing ibuild in dapper drake
auto_prepend Auth php5
laptop HP fv5000
automatic mount ntfs hd ubuntu
#debian
|
|