| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> Hey guys w***up.
<1> how do i completely delete a database?
<2> What special stuff do I have to do to import a .sql created in mysqldump 4.0.25 into 4.1.11?
<2> AngryElf: mysql> DROP DATABASE myDatabase; ?
<3> Mike, man mysqldump
<4> MikeW: likely nothing. are you getting errors?
<1> thanx
<2> infi: ERROR 1064 (42000) at line 891: 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 'NOT NULL,
<2> value text NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM COMMENT='Mike' at line 4
<4> MikeW: Paste that entire surrounding create table statement to the pastebin from the topic.
<4> actually, I wonder if value is a reserved word. try `value` text not null,
<5> value is not a reserved word. `values` is however.
<5> http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
<2> http://hashmysql.org/paste/viewentry.php?id=1654
<2> I'm not entirely sure how that comment got in the sql anyway
<3> key is reserved
<4> oh, it's the key, use `key`
<4> yeah
<2> but because it is a 36mb .sql file created with mysqldump, I really don't want to have to edit it manually. I'd much perfer to use some switches with mysqldump 4.0 to create a .sql file I can use with mysql 4.1
<2> oh wait, now I know. Yeah, I created that table myself
<3> Mike, if you use a *nix box, then it isn't that bad (w/ vim)
<2> well I don't know how to use vim
<3> on Windows, good luck ;)
<4> there's like a --quote-all-fields parameter to mysqldump iirc. but the longer-term solution is "don't use reserved words as column names."
<3> yup
<2> hmm, and mysql never complained about me using key as the field name
<2> if I knew that back then, I wouldn't have used key
<1> is there a way to clear all privilegs on a db?
<3> look at the priviledges table
<3> MikeW, that is odd - as key isn't a new reserved word
<2> hmm, well I created the table using phpmyadmin. I'm surprised it even let me do that
<4> I'm not ;)
<2> my ideal would be if mysql allowed me to use any words for field names :)
<4> it does, if you use `foo`.
<3> http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
<3> MikeW, ^^
<2> thanks. that's a big list
<6> it's a very big list
<6> and includes words like TRIANGLE
<6> oh, 4.1
<2> you're everywhere
<2> :)
<3> heh
<6> I'm not on freenode ##php
<6> hmm, where is triangle...
<6> I could have sworn triangle was a reserved word
<6> how did mysql's april 1st go?
<7> anyone know about the WHERE field IN (array) statement efficiency?
<7> I'm wondering if its equal to or less efficient than =
<8> To my understanding, there should be roughly no difference; the majority of performance should get lost elsewhere.
<8> But I don't _know_ it. I only know how I'd implement it.
<9> how the most efficient way to relate 1 item to N other in the same table?
<6> xml, obviously!
<8> define a "parent" foreign key, allowing NULL entry
<6> lame
<8> SpComb: xml? yes. I forgot. XML is the answer to anything.
<6> of course
<6> or you could be boring and define a foergin key in the N side of things :(
<8> which is the same as the 1 side of things. ;)
<6> but that's like... infelxible and so not-trendy
<8> "in the same table"
<6> foergin key doesn't make for a good buzzword
<8> SpComb: and, even worse. it could even perform.
<6> I mean, if you said, "we use a foergin key to efficiently map x to y", it wouldn't sound nearly as cool as saying "we use a xml data column on x to provide a flexible win-win enterprise relationship to the latest y technology"!
<6> oh, same table
<6> whatever
<8> hrhr :)
<8> but your "we use a xml data blah" bull****ting will win a prize, I'm sure :-)
<9> i prefer to be boring with this, thanks for answer
<6> salee
<10> hello
<10> how can i import an mysql database ?
<10> which comand
<10> mysqladmin -uBenutzer -pP***wort datenbank < datenbankfile?
<4> mysql
<10> i get this error
<11> isn't it something like myql << myfile.sql?
<10> RROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2
<4> mysqld is likely not running, then.
<4> or you have a permissions problem.
<10> u think it is a permission problem ?
<6> mysql should just use a memory-based xml file for client connections!
<4> that or mysqld not running, like I just said.
<10> so what can i do ?
<12> Can i use mysql with squid( proxy cache )?
<11> BeK depends on what OS you are on to some extent
<11> Could be service mysql start
<11> or some gui or ....
<6> or /etc/init.d/mysql start
<13> hi
<13> what is blob?
<11> Binary Large Object
<11> or trying to store a picture or other file in a database
<13> can i put in blob more than 1000 characters?
<11> FC-tooki: yes, but you could put that in other data types as well
<13> what are these other types?
<6> XML!
<11> FC-tooki: http://dev.mysql.com/doc/refman/4.1/en/data-types.html
<13> thnx
<11> I think everything should be stored in a buzzword.
<6> CREATE TABLE executive_rank (Key BUZZWORD, Points smallint); GRANT SELECT ON db.executive_rank to 'manager'@'%';
<13> thnx, bye
<14> gah poor Jaxxie
<6> XML.
<15> please forgive me for what is probably going to be a series of stupid questions...but I'm trying to set up mysql with php and I'm getting an error saying, "mysql_fetch_row(): supplied argument is not a valid MySQL result resource in ...session.php"
<6> mysql database permissions.
<6> most probably
<14> Frazzydee that's usually when your query failed
<15> do I need to explicitly create a table?
<6> or if you have error reporting off, then anything silly
<14> do a $result = mysql_query($sql) or die(mysql_error()); tha should help you
<15> Jax: sorry, I'm completely new at this...where do I put that?
<6> erm... you do have a mysql_query() call?
<6> you don't p*** the sql string to mysql_fetch_row()
<15> well, it's not my php, it's someone else's that I'm trying to set up
<6> ah
<15> this looks like it though: $row = mysql_fetch_row($query);
<15> it's in multiple PHP files, so how would I know which one is causing the problem?
<11> Frazzydee: somewhere above thatt it should say $query=mysql_query($strSQL) - something like that
<15> in one of the errors it says session.php, but in another it doesn't specify
<15> mikere: it doesn't in that file :(
<15> oh, I think this is it: if (list($value) = mysql_fetch_row($qid)) { return $value; }
<15> I think it's a problem with the list...can the PHP file create that automatically or do I have to do it explicitly?
<14> DUDE my cat has fleas
<14> >;/
<5> I recently upgraded a box from MySQL 3.23 to 4.1 and am running phpMyAdmin 2.7. When going to the Browse page on any table I get a blank page.
<5> I asked in #phpmyadmin but no one responds.
<6> Jax: use a XML based flea cataloging and tracking system!
<5> (nearly) all other funcitions in phpMyAdmin seem to work fine.
<5> From a command line browser (links) I get "Error reading from socket" on the browse pages.
<5> or any page that uses the sql_query= variable in the url.
<16> I have a question regarding moving data from one mySQL bugzilla db to another. Could I export all data from all tables to a file, and then import that data to another mySQL bugzilla db so long as all the tables are exactly the same as the first db? The db name is different however. And of course, would all the bugs then be available as they were in the first db?
<5> also... With log-bin enabled under 3.23 it makes logs in the form `hostname -s`-NNN. Under 4.1 it makes `hostname -s`-NNNNNN If you run "SHOW BINLOG EVENTS and you have both old and new style logs around mysqld will crash.
<16> the purpose is to move teh database from my Mac desktop to a hosted machine
<16> at an isp
<5> steelrain: mysqldump should give you all the structure and data together in a nice form that should load only nearly any mysql instance.
<5> also, MyISAM tables are binary transportable. You should be able to take the current table files *.frm, *.MYD and *.MYI from your current box and drop them into another database, be it Mac, Linux or Windows.
<5> it's safest to stop mysql or run "FLUSH TABLES WITH READ LOCK" before you make the copy though
<17> hello
<17> how do I make my data case-sensitive?
<5> use the BINARY keyword on your fields.
<17> is this when I make the actual table, or do the queries?
<5> in the table def.
<16> Thanks TInT, I appreciate the response. I'll see what I can do then. Good luck with your request.
<17> ah, I see
<5> you can also use VARBINARY() instead of VARCHAR();
<17> thank you
Return to
#mysql
or
Go to some related
logs:
waiting for the slave I/O thread to update it
libc.so.6(GLIBC_2.4)(64bit) is needed suse
kubuntu
kubuntu badblocks
kde error encountered while talking to ssh
#linux
#lisp
#python
#fedora
vt8251 fedora
|
|