| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> I'm going to be storing stats that will record how many times a file has been downloaded. What's the best way to do this? I don't think grabbing the download number from a field and incrementing it would be the best unless that is the only way... is there a way to auto_increment when I update a field or something?
<1> foo: update field set foo=foo+1 ?
<0> Darien: hmm, I didn't know that could be done. Thanks :)
<1> sure :)
<2> your really not supposed to store calced values
<2> should do a downloads table that inserts the filename and timestamp
<2> then sum the total for that filename
<3> I had to move a blog from one server to another, the blog is in Japanese. I did a mysqldump on one server and push it into another database on a separate server. and I lost the encoding. I can't read the japanese on the new server. is it an option on the server ? an incompatibility ? an option on the dump ? anyone have a solution for me PLEASE ? thnaks.
<4> somekool: you have to set the encoding at the time of population, or it may/will strip bits.
<4> translation: your stored data is now incorrect, and you have to reload.
<3> infi I need this option when I'm doing the mysqldump from the source, or whaen I'm inserting the SQL ? or both ?
<4> somekool: both
<4> somekool: what character format are you using (utf8 I hope)
<3> i dont even know
<3> I suppose it is
<5> Is there not a way to tell a running mysql daemon to start logging slow queries?
<3> infi, is it related with the Collation of the table ? what does it do when you change that ? or is it only a phpmyadmin settings ? (collation) ?
<3> what does it do to do something like that ? ALTER TABLE `articles` DEFAULT CHARACTER SET ujis COLLATE ujis_japanese_ci
<3> infi I really don't understand encodings
<4> somekool: altering the tables to use ujis now won't do any good, it already stripped the bits.
<3> how about my original ? why can I read the japanese on the webpage, but not in phpmyadmin ?
<6> can anyone give me some ***istance with an error i'm getting with mysql 4.1 - i get an error 28 from the storage engine (a quick web search says that error 28 means out of disk space), yet i'm not anywhere close to capacity. ideas?
<7> df -i
<7> maybe you are out of inodes
<8> fmay: you run out of tmp space maybe?
<6> inodes good, nowhere near capacity
<6> HarrisonF: does mysql use /tmp by default, or somewhere else?
<3> infi doing an alter table default charset/collation on my source would it corrupt the data ?
<4> I'm not sure, as I think it would depend on from what, to what. but I'd imagine in most cases it would.
<6> HarrisonF: aha! /var/tmp, and it filled up rather quickly
<9> hi ...I have multiple db's on a server and I want to sync them with another server .....do the mysql server's need to be the same version ? also what the best way to do this
<10> porkpie: do the DBs need to remain in constant sync ?
<9> yeah
<10> ok that's pretty straight forward.
<10> only the source server would be permitted to modify the tables then.
<10> is that a problem ?
<11> Hi, on my system any user can see/list all the databases. I solved this by "revoke show databases on *.* from user@localhost" but whenever I restart mysqld I need to redo this! How can I fix this? I tried to add "safe-show-database" to my.cnf to no avail!
<9> TodolnTX:OK I have 2 webservers server A currently hosts the db's server B needs to access these db's ....
<9> TodoinTX:it would be good the have a 2way sync ...
<10> porkpie: there really isn't an easy to use/explain way to do that in MySQL.
<10> one way replication is simplest.
<10> if you have two webservers that need access to one db then just create a grant to allow access from the 2nd as well as the first
<9> TodoinTX:thats what I was doing but ...I can't get the grant syntax to work :(
<10> !m porkpie grant
<12> porkpie: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<13> Hi all. sorry to jump in and just want help, but I'm having a weird issue with mysqldump. I'm using mysqldump on other boxes just fine, but with this one in particular, it keeps complaining about my command syntax as incorrect.
<9> GRANT ALL PRIVILEGES ON *.* TO foo@"%" INDENTIFIED BY 'somep***' WITH GRANT OPTION;
<10> '%' means any network host
<10> I.e. not localhost
<9> I have tried localhost as well but it fails
<13> For example "mysqldump --opt -uroot -pmyp*** mysql" should do a straight dump. But on this problematic machine, it keeps giving me the usage responce.
<9> 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
<13> I've gone through the manual page in depth, and I'm doing to correctly. So I'm at a bit of a loss..
<8> Ryushin: it should say something at the very top
<13> Verbose doesn't even tell me which part of the syntax that it's having problems with.
<13> HarrisonF: Yea, "Usage: mysqldump [OPTIONS] database [tables]" and the other two standard lines.
<8> what is the exact command you issue, copy and paste it
<13> ysqldump -v --opt -ucccoit -pp***wordgoeshere mysql
<13> The paste didn't have the "m" but it's there.
<13> Yea, I can see you thinking, yea, that should work.
<8> should be fine
<8> what version is it?
<8> mysqldump --version
<13> mysqldump Ver 10.9 Distrib 4.1.10a, for redhat-linux-gnu (i386)
<13> mysqlcheck works fine. As do the other commands.
<8> try doing it with: mysqldump -v --opt -ucccoit -pp***wordgoeshere --databases mysql
<9> is it possible to grant *.* to a new user
<13> nada.
<13> Yea, see, this is just insane. It should work. What bugs me is that it's not telling me what is wrong.
<8> dunno, for some reason it isn't getting the "mysql" part
<8> it thinks you aren't specifying a database name
<8> if a --option or -o is wrong, it will tell you
<8> try it with --all-databases
<13> Okay, want somthing scary, mysqldump -v --opt -ucccoit -pp***wordgoeshere started dumping stuff.
<13> I left off the database part all together.
<13> Hey, maybe there is a alias.
<8> or something in a configuration file?
<13> Nope. I'll go through the config file in details. I'm not the one that set this sql installation up. So maybe something is there.
<8> i bet --all-databases is in a configuration file
<8> run:
<8> mysqldump --print-defaults
<13> Crap, that was it. He set up a .my.cnf file and it wasn't reading the default /etc/my.cnf.
<13> Thanks HarrisonF.
<13> his cap.
<14> Hey, how do I view what fields are inside a table?
<14> ?
<14> I'm just trying quickly to check something out.
<4> desc table;
<14> Ahh, okay.
<14> thank you.
<14> and to change stuff, it's MODIFY table SET a = b WHERE field = c; right?
<4> no.
<4> !m andares tutorial
<12> andares: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<14> oh.
<14> infi: It doesn't seem to tell me how to modify a table.
<14> Only how to create and so on. =/
<4> !m andares alter table
<12> andares: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<14> infi: But I don't want to alter the structure of the table itself.
<4> then you want update or insert, which are likely farther along in the tutorial than you read.
<14> UPDATE
<14> that's it.
<14> modify table cl***ic set x = 30.00 where accname = 'andares';
<14> this doesn't work though.
<4> UPDATE cl***ic SET ...
<14> oh.
<14> hmm.
<15> hi folks!
<15> i got a quite weird problem.
<16> Are there any ER diagram tools?
<15> i'm coming from a mysql 4 server to a mysql 5 server.
<15> suddenly my mysql_real_query stops working.
<15> sprintf(query, "SELECT * FROM continents_long ORDER BY continent");
<15> if(mysql_real_query(&db, query, 255)) {
<15> this gives me the following error: 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
<15> i can compile this on the mysql 4 server and it works like a charm.
<17> hi all
<17> http://pastebin.com/567655 table IMPORT error.
<17> anybody can help me please. ?
<4> noph: try mysql_real_query(&db,query,strlen(query)). and what is the actual return value from mysql_real_query() ?
<4> noph, use snprintf, by the way.
<4> in this case it doesn't matter, but it's a good habit to form.
<4> TheBest: what version of MySQL is that running on?
<15> infi: ill have a look
<17> Your MySQL connection id is 165 to server version: 3.23.58
<17> infi 3.23.58 FC3
<4> TheBest: 3.x doesn't support ENGINE=foo
<17> so i cant install theat table ??
<4> no, there's another keyword. hold
<17> ok i wait.
<4> I dunno if DEFAULT CHARSET or COMMENT will work, either ;)
<4> !m infi create table
<12> infi: (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<4> TheBest: TYPE=MyISAM
<17> ERROR 1064: You have an error in your SQL syntax near 'TYPE=MyISAM' at line 1
<4> just don't specify it, then. it was the default type in 3.23 anyway.
<15> infi: Whao, strlen(query) did the thing!
<15> infi: thanks alot.
<15> infi: weird that it works on 4.
<15> the 255.
<17> so what i must to do to edit in VNSB_database.sql ??
<15> i malloc the querystring to 255.
<4> noph: if you use malloc, you're feeding it garbage after your query then.
<4> use calloc
<4> or zero the string with bzero or memset.
<17> mysql> use calloc;
Return to
#mysql
or
Go to some related
logs:
friendshipness quotes
mythtv ubuntu wintv-150
debian /dev/hdi not found
changin localhost gentoo
#gentoo
call to undefined method MDB2 execute
#ai
umbuntu change permissions
eggdrop ftp.so
sony sz hibernation crash
|
|