| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> one way*
<1> ahh ok
<1> concatenate
<1> but is it ok if i just build a query?
<0> yes. Selects dont hurt anything
<1> Select
<1> tbl_author.surname,
<1> tbl_author.name
<1> From
<1> tbl_author
<1> oh sirry
<1> could you please check my script, list($this->author->BoundColumn, $this->author->TextColumn, $this->author->DBFormat) = array("", "surname, name", "");
<1> coz its not woking
<2> Hi all!
<2> What you can say about upgrade mysql 4.0.x to 4.1.x?
<2> it is safely?
<2> may be exist article about this theme.
<3> is it possible to add constraint in our 2 innodb?
<4> !perror 145
<5> MySQL error: 145 = Table was marked as crashed and should be repaired
<4> why do my tables crash more othen than normal? :(
<6> they should not ever crash
<6> have you tried leaving a bat in a threatening location next to your database server ?
<4> :p
<0> yeah. mySQL shouldnt crash. there can be all kinds of errors thrown, but not a crash.
<0> now if someone decided to force a reboot of the computer when some tables where locked (innodb) or in the middle of a transaction....then maybe yeah you should check the tables
<4> well
<4> i did mysqladmin shutdown 6 hours before last crash
<6> lol
<6> that is supposed to be safe
<4> i have no idea what goes wrong :(
<6> have you checked your memory and hard disk for errors ?
<0> have you checked the log file?
<6> because seriously mysql tables do not crash...
<7> when I'm doing a insert, is it "insert into myTable set (columnA = value1,columnB = value2); ?
<4> 60407 21:40:19 [ERROR] /usr/sbin/mysqld: Can't open file: 'Article.MYI' (errno: 145)
<8> cake_: no
<4> that's starting out of the blue
<8> !perror 145
<5> MySQL error: 145 = Table was marked as crashed and should be repaired
<7> Darien: how do I write thetn?
<7> *then
<8> cake_: are you adding rows, or are you changing existing data?
<0> cake_: insert into mytable(columnA,columnB....) values('some','thing');
<8> !man insert
<5> (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<7> hmm, but if I'm unsure about the order of the values, like isnt there a way to specifiy which values goes where (execept from putting it in the same order as specified before) ?
<0> Bheam: does the database/table Article exist when you call show tables/databases?
<0> cake_: the order in which you specify the columns of mytable(columnA...) values(ValueA...) is how you match them.
<9> can varchars have a length greater than 255?
<6> yes
<9> ok, is there a maximum length?
<6> yes
<9> and it is?
<6> no idea :P
<0> !man varchar
<5> (Overview of String Types) : http://dev.mysql.com/doc/mysql/en/String_type_overview.html
<9> 256?
<6> lol no
<9> thanks Ryu_95
<0> n MySQL 5.0, the range of M is 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in MySQL 5.0.3 and later.
<9> ahh
<9> A variable-length string. M represents the maximum column length. In MySQL 5.0, the range of M is 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in MySQL 5.0.3 and later. (The actual maximum length of a VARCHAR in MySQL 5.0 is determined by the maximum row size and the character set you use. The maximum effective length starting with MySQL 5.0.3 is 65,532 bytes.)
<9> oh - yeah!
<9> ok, using 5.018 so that's cool :)
<9> what does SOL mean?
<9> "If you're a tor user you're SOL as you can't see..."
<0> its an expression. S___ outta luck. Meaning um....its not good for tor users
<9> ahh - i thought it was an insult
<0> in a way it is.
<10> Hi. I'm getting this error when I try to start MySQL 4.1: 060408 6:38:54 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
<11> ttr3: check your filesystem, does the file exist?
<10> -rw-rw---- 1 root mysql 8.9K Apr 8 06:38 /var/db/mysql/mysql/host.frm
<11> strange..
<0> followed by: does mySQL have read permissions
<11> well, its owned by the group mysql
<11> and has the rw-flaxs
<11> flags.
<11> ttr3: to be on the safe side, do chown -R mysql for the mysqldir
<10> already tried, no luck
<10> hmm... backup1# perror 13
<10> OS error code 13: Permission denied
<12> what does this mean: DELETE FROM item WHERE name LIKE "Calendar Meal for %"
<12> ok, the % is a wildcard right?
<13> does anyone now how to put mysql 5 on ubuntu
<11> ttr3: check that your filssystem is OK, sounds to me you have a damage filesystem.
<10> fraggeln, i've already reinstalled freebsd once because of this, but no luck
<10> Din, this should work... http://www.linuxcompatible.org/PHP_5.1.2_MySQL_5.0.18_for_Debian_s61988.html
<12> ,like
<12> !like
<12> !man like
<5> (String Comparison Functions) : http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
<12> what's a binary string?
<14> a string containing only zero's and one's
<12> oh ok.
<13> am why error at phpmyadmin: Cannot modify header information - headers already sent by (output started at /var/www/phpmyadmin/libraries/Config.cl***.php(351) : eval()'d code:25)
<14> 1001010101 = a valid binary string 102001000 = not!
<12> here's a context "If a string function is given a binary string as an argument, the resulting string is also a binary string. A number converted to a string is treated as a binary string. This affects only comparisons."
<14> 256 in binary is 100000000
<12> TGoC: don't look like binary digit as string form...
<14> 256 decimal is 100000000 binary
<10> fraggeln, chown -R mysql:mysql /var/db/mysql && chmod -R u+rw /var/db/mysql worked
<12> TGoC: i can't make sense from the text
<12> TGoC: it's from mysql doc 12.3.1
<14> got a direct link?
<14> But uhm i doubt you want to use binary if you don't know what binary is...
<15> i'm using mysql 5.0.18, and i have a utf8_unicode_ci encoded field with a japanese character in it, when i use select * from current; the character is shown fine, but when i use a stored procedure it is displayed as ?, the stored procedure http://pastebin.com/647681 any ideas?
<13> um problem #2013 - Lost connection to MySQL server during query i get when phpmyadmin is trying to connect to mysql 5.0.19
<13> what can i do
<13> please help
<16> Hi, I know this is probably a really obvious question, but I can't easily see it from the manual - how do I move a MySQL 5.0 database to a different filesystem?
<16> My database is currently in /var/lib/mysql, this is close to being full, I have another nearly empty volume.
<6> shut down the database server , move the files, point the database server at the new filesystem, restart the database server :P
<6> or move the files and mount the filesystem in /var/lib/mysql :P
<16> I tried moving the files and symlinking the dir, then starting it up again. Now it says ERROR 1033 (00000): Incorrect information in file: './spider/domain_blacklist.frm'
<16> Still giving me this "Incorrect information" malarky
<16> Aha, fixed it, I was booting an old version of MySQL with newer tables
<17> if there is a Database prefix in mysql named photo_
<17> how can i remove it completely ?
<16> Noboru: use DROP DATABASE
<11> MarkR: he just wanted to remove the prefix, not the whole database.
<18> I am looking for a cluster solution for mysql. I found mysql cluster (ndb) and m/cluster. I want to know which is more mature and reliable
<17> MarkR, i should run DROP database photo; ?
<13> um problem #2013 - Lost connection to MySQL server during query i get when phpmyadmin is trying to connect to mysql 5.0.19 - dapper version
<11> Noboru: NO!
<17> or photo_; ?
<11> Noboru: you cant use that command, drop database will destroy ALL data in that database.
<16> Noboru: Oh, in which case, don't use drop database,
<16> I misunderstood what you wanted to do
<17> oh
<11> Noboru: there is a command called RENAME TABLE, check that one out :)
<11> Noboru: http://dev.mysql.com/doc/refman/5.0/en/rename-table.html
<17> i didnt mean that
<17> thanks,let me check that error again
<17> if i try to install that gallery progarm with default value like i used to do
<17> it says error , gallery_cat already exists
<17> if i run it with 'overwrite old database',it says
<17> INSERT INTO gallery_cat ( id, name, description, parent_id, catorder, allow_rating, allow_postcard, allow_download, allow_upload, origfolder) VALUES ('', 'Name of your category', 'Description of your category', '0', '10', '1', '1', '1', '0', '20847968');
<17> Out of range value adjusted for column 'id' at row 1
<19> http://pastebin.com/647763 Help with that would be very much appreciated. I'm not sure why I am getting a syntax error.
<19> "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 'WHERE ((unlimitedImpressions=1 AND unlimitedClicks=1) OR (unlimitedClicks=1 AND ' at line 1"
<19> I am missing the FROM bit. Ahhh. Lack of sleep.
<20> if i start making those mistakes, i just usually sleep for a few hours
<20> :)
<19> Mike_, hehe. I just want to finish this little bit.
<19> It's not even that late (1am)
<17> can anyone tell me what could cause this error in mysql ?
<17> INSERT INTO tupian_cat ( id, name, description, parent_id, catorder, allow_rating, allow_postcard, allow_download, allow_upload, origfolder) VALUES ('', 'Name of your category', 'Description of your category', '0', '10', '1', '1', '1', '0', '5750578');
<17> Out of range value adjusted for column 'id' at row 1
<21> putting a string null into a number
<17> archivist, ?
Return to
#mysql
or
Go to some related
logs:
intel 8201FB ICH6 driver
iptables: match `ipp2p' v1.3.5
hoymail
#debian
gpg --export -a FBABB737 | apt-ke
horde php5 failed to open stream: permission error
nforce 430 ltsp
#php
#ubuntu
#perl
|
|