| branstrom | Are users 'blah' and 'blah@host' treated as completely separate users? I realize 'blah' is actually 'blah'@'%' |
| predder | wouldnt the blah@host be redundant because it's also part of the wildcard either way i'd be very careful with what you're doing! |
| branstrom | With what exactly? |
| predder | but if you have blah@box1 and blah@box2 then yes, they are completely different having blah@% and blah@domain with different permissions |
| branstrom | Yeah, with different passwords and different privileges, I think I get it |
| predder | because you couldnt be guaranteed that the blah@domain account wont just use the blah@% account instead (obviously it wont be let in with a different password but that's not the point) pimpmaster, does your user have "file" privileges? show grants for your user |
| pimpmaster | i just figured it out.. by saving the file to my tmp directory it went through just fine will it save my indexes like this as well? |
| branstrom | I just took that as an example, I'm not after that kind of a setup. |
| predder | pimpmaster, no, doing a select into outfile is raw data, no indexes.. |
| pimpmaster | argh.. so I really should mysqldump it huh? |
| predder | that doesnt make the index either afaik |
| pimpmaster | hmm |
| chadmaynard | the only thing you need to recreate the index is the table structure saying something is indexed |
| predder | but if you want to perform a query and get the results in a file you should be doing mysql -e 'select * from foo.bar;' > somefile.data |
| txmanilat3r | sry i have another new guy question |
| pimpmaster | so INTO OUTFILE is bad? |
| txmanilat3r | i want to put a record such as "23-2-0" in a column, shouldn't i do that as a varchar...i won't need to do any math functions on it |
| predder | well, the docs recommend using mysql -e ........ if you have the ability to i believe |
| pimpmaster | thx predder, I will make a note of this voodoo |
| predder | txmanilat3r, a varchar would be fine |
| chadmaynard | txmanilat3r: if it's always 6 characters wide use a char() |
| txmanilat3r | k thx is there a way to chg the format if I currently have it set to int? its no big deal if not, or if it takes a lot of work this is just a db to fool around on |
| predder | you can alter the table with the alter table command |
| chadmaynard | !man alter t |
| the_wench | see http://dev.mysql.com/doc/refman/5.0/en/alter-table.html |
| pimpmaster | predder, am i correct in thinking that the reverse of that statemnt wouldbe: mysql -e 'INSERT foo.bar' < somefile.sql |
| chadmaynard | pimpmaster: you are incorrect |
| branstrom | By default on my Debian install there seems to be two root accounts: root@Io (its hostname) and root@localhost - isn't the localhost account enough? |
| pimpmaster | doh |
| chadmaynard | branstrom: depends on how you connect |
| predder | pimpmaster, close, you probably just want mysql < somefile.sql where somefile.sql contains the "insert into" query |
| pimpmaster | my bad, i meant to say mysql -e 'select * from foo.bar;' > somefile.data |