| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> keex: ^--- that sounds like the otehr host has an old(er) version of mysql.
<1> yeah... it is
<2> ji
<2> hi even
<2> anyone alive?
<2> why wouldn't I be able to select a database even though I have it?
<3> what error do you get when you try?
<4> how do I test to see if I have compiled mysql correctly?
<2> oh, I got it, I used table name instead of database name
<2> :|
<3> bl4: does it run?
<4> yes
<5> hey everyone. it's been a while since i used mysql. and now i've forgotten the p***word to the user 'root'. how can i recover from this?
<3> IIRC, you can start the server with an option that makes it ignore the permissions table
<3> --skip-grant-options, maybe?
<3> start it up like that, change the p***word, then restart it.
<5> DShadow: unknown option --skip-grant-options
<3> well, it's not that, then
<3> check the manual. there's probably something useful in there
<3> if it's not that, then --skip-grant-tables, maybe
<3> otherwise, I'm out of ideas.
<5> nah, unknown option as well. is there anyway to just blow away the entire config tables and recreate them?
<3> I think you want to look at the manual and find the command
<3> I know it's there, I just don't remember what it's called.
<5> ok. tnx :)
<6> helloo.. please can any one tell me how I can drop a primary key from the table i have?
<7> mizZo_ use alter, smth like alter table table_name drop primary index index_name
<6> the query am trying to exec is: ALTER TABLE foo drop primary key;
<6> Adrenalin`: what is the index?
<6> how can I know it?
<7> no, no, I'm wrong, it's key instead index
<7> what error you get ?
<7> ALTER TABLE foo drop primary key key_name;
<6> Errorcode: 13, error on rename
<6> play i will try that
<6> oops i mean okay
<6> key_name is it the column name?
<0> not necessarily, no.
<0> or... in the case of a primary key, no name is needed, is it?...
<0> "drop primary key" should do fine.
<7> yep.. "ALTER TABLE foo drop primary key;" should work.. Errorcode: 13 isn't mean "Permission denied" ?
<6> It displays: Error on rename of directory\foo.MYI to directory\#sql12-7e4-48.MYI <Errcode: 13> btw am using an older version of mysql
<0> !perror 13
<8> System error: 13 = Permission denied
<0> mizZo_: ^--- check file system permissions
<6> does that mean being an administrator or not?
<9> Is the root user only allowed local access by default?
<0> i think so, but it probably depends on your distribution
<9> How can I find out?
<0> actually, debian allows *no* acces via tcp per default
<0> err... you mean, without logging in?
<9> Distro is OpenBSD
<0> well, log in as root, then do SHOW GRANTS FOR root.
<0> that should tell you.
<0> ...FOR 'root', that is.
<9> ahh
<9> right
<9> mysql> SHOW GRANTS FOR root;
<9> ERROR 1141 (00000): There is no such grant defined for user 'root' on host '%'
<9> hm
<10> I have created one database and I would like to get to know if it is an innodb. In fact, I created one database using the default mysql(I think the default use innodb), I do not know why but there wasn't my.cnf.
<10> Afterwards I created my one my.cnf using the my-large.cnf and uncommenting the innodb lines. I am quite sure it is working because I can see the logs and there is nothing wrong.
<10> How can I be sure that the tables that I have created in the past are innodb tables? why does the mysql server created one folder and several files for each database of mine? Weren't these file to be in only one(/var/lib/mysql/ibdata1)?
<10> If I make a backup of this folder (/var/lib/mysql), can I use it later or I have to import it?
<0> foo: don't know, maybe there are defaults in my.cnf - i'm not a wiz ;)
<9> Duesentrieb: hm, thanks, I'll check
<10> sorry, for bothering you guys, but I am reading the documentation of mysql and trying to learn. If sby could help be I would be very greatful
<0> Azuos001: you can use SHOW CREATE TABLE x to find out what engline the table uses.
<0> maybe EXPLAIN TABLE shows that too, not sure.
<0> ibdata stures innodb data
<0> myisam data is in MYI and MYD files.
<0> myisam uses one folder per database. innodb sticks everything into a single file, i think.
<11> does anyone know if these two queries produce the same result
<11> select a from R Natural join s group by a having count(*) < 2
<11> select a from r where b not in (select s1.b from s s1, s s2 where s1.b = s2.b and s1.c <> s2.c
<0> Azuos001: making backups of the data files will probably work if the db is not running while you make the copy, and you want to open it later on the exact same system. But it would be much better to use dumps created with mysqldump. Please read the manual about it.
<10> why do I have some files in some folders that look like myisam? isn't the default innodb?
<0> "hot backups" are possible, afaik, but not exactly trivial.
<0> I have no idea what the default is on your box.
<10> ok, but if I copy it when my server is stopped I can copy it without problem like a common file
<10> is there anyway to transform a myisam table to innodb?
<0> aleh: no they don't. s1.c <> s2.c is not part of a natural join. the rest is equivalent if and only if b is the only field the two tables have in common.
<0> Azuos001: you can convert it using the ALTER TABLE syntax.
<10> great
<10> the "show create table" didn't work here
<0> it didn't?
<10> let me go to google and I will be back to tell you, might be sth wrong with the syntax
<0> !m Azuos001 show create table
<8> Azuos001: (SHOW CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html
<10> mysql> SHOW CREATE TABLE;
<10> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
<0> well, you should tell it what table you want...
<10> I am still a stupid here. sorry
<10> it is a myisam table
<10> ok
<12> aleh: No.
<12> aleh: Not even close.
<10> as I said before I have configured my server to work with innodb now. Everytable that I create now will be innodb or I do need to say to the server that I want a innodb table?
<0> i don't know if you *need* to, but you *should* specify the engline type when creating a table.
<0> unless the create statement should be "compatible" SQL - in that case, it's up to the server to decide.
<10> how can I tell the server what kind of table I want?
<11> does anyone know how to convert sql statements into datalog
<0> Azuos001: SHOW CREATE TABLE shows you the create command for the table. it includes the ENGINE setting at theend which tells the server the engine type.
<10> exempla: create table Product ( cod_product int unsigned not null auto_increment primary key, description varchar(100) not null , value int not null, pontos int not null );
<12> aleh: What's datalog?
<11> a logic query language
<11> for recursion its useful
<10> it worked
<10> do you recommend me to use innodb_file_per_table? What would happens with my logs?
<10> I am thinking about using one dedicated hard disk to save my database and logs.
<10> What would be the correct arquitecture? I am thinking about the need of recovering the database?
<11> is a natural join contained within a full outer join i.e. fullouter join = nj + lj + rj?
<12> aleh: The problem is MySQL doesn't support the recursive oriented features of standard SQL. The conversion would pose pose problems. There's just no direct / general path from here to there.
<11> doesnt mysql have recusive as its keyword
<12> aleh: The list of reserved words might be a superset of thsoe supported.
<12> those
<12> aleh: A natural join is an inner join, not outer join.
<11> so its a left inner jion and right inner jion?
<12> aleh: No.
<11> if i had like r natural full outer join union r natural join s
<12> aleh: LEFT JOIN is ... LEFT OUTER JOIN
<12> aleh: The OUTER joins are in the set of JOINs called <qualified join>
<12> aleh: Natural join is not.
<11> ok so r natual full outer join s is the same as r natual left outer join s + r natural right outer join s
<12> aleh: But, hold on.
<12> aleh: Ah. You can add the <join type> to a natural join. Sorry. My mistake.
<11> ok so if u had (r natural full outer join s ) + r natural join s
<12> aleh: Right. So you'd have to use NATURAL LEFT JOIN to compare to LEFT JOIN. They are identical if you use the equivalent join criteria.
<11> and r natural left outer join s + r natural right outer join s
<11> they are the same
<11> ?
<12> aleh: Not "same", but "equivalent".
<11> because in the first one r natural join s is already a subpart of the natural full outer join s
<11> ?
<11> i.e. you can have duplicates so wouldnt really effect the result
<12> aleh: LEFT and RIGHT are not equivalent, except in some special cases relating to the data.
<13> ei galera como eu fao essa tabela?
<13> Campo Tipo Extra
<13> mes integer No nulo, chave primria, valores entre 1 e 12
<13> ano integer No nulo, chave primria, valores maiores que 2002
<13> filiado integer No nulo, chave primria, chave estrangeira para a tabela filiados
<13> pagamento date
<13> devido numeric(11,2)
<13> pago numeric(11,2)
<13> qual comando?
<12> Paraibano: Don't do that. Use the pastebin (from the topic).
<11> ok so they are not equivalenent?
<12> aleh: I'm not sure what you meant by "+"
<11> i.e. (r natural full outer join s) union (r natural join s)
Return to
#mysql
or
Go to some related
logs:
#math
ksmoothdocker
grub-reboot doesn't work ubuntu
updatedb cron job FC5
mp4creator rpm fc5
mysql 1406 Data too long for
Autodetect atheros on Ubuntu
Authdir /var/gdm does not exist
How to install Ethereal on Ubuntu
sqlalchemy temporary table
|
|