| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> what like mysql -u admin -p myp***
<0> ?
<1> I've tried to install mysql-client via pkg or ports, php-mysql was installed via pkg_add
<1> yes matthewcrane
<1> but don't put in p***, let it ask you for it
<1> just mysql -u user -p
<2> mathewcrane: don't forget a USE <mydatabase>; command after it prompts you
<3> Or add db name on command line ;)
<0> ok done my comman finally, when i have execute a comman in sssh how to exit saving my changes
<1> could this have something to do with my problem?
<1> drwxr-xr-x 3 root daemon 512 May 26 02:04 libdata
<1> drwxr-xr-x 2 root daemon 512 May 26 02:04 libexec
<1> drwxr-xr-x 6 root daemon 512 May 26 02:52 local
<0> do i just close the window
<1> I know I couldn't get php to write text files unless I made the directory chown apache:apache
<4> matthewcrane: is it cold outside ?
<0> cold and wet
<1> (that local directory is where the php module is)
<5> hi
<4> oh in that case most definitely close the window
<4> unless your house really really needs airing out
<0> mwah hah
<5> i gotta question about create table...checksum=1
<0> seriously do i need to do a an exit and save command first to save my changes in ssh
<5> how can you retrieve that information (checksum) back from the db?
<6> Ive got a postion in my replication binlog file, I tried one of my slaves with stop slave; set global SQL_SLAVE_SKIP_COUNTER = 1; start slave; but it does not work. I guess this number could be the last in the log file. is there a tool to check this?
<2> SkyBlue: all of the .SO's used by the MySQL module must also be in your chroot jail
<4> matthewcrane: that question does not make any sense - ssh is a remote terminal tool
<2> or linked form there
<4> there are not any changes you could make that could be saved by it
<2> or it ain't gonna work
<4> if you have something like pico open through the ssh then you should save your changes before closing it :P
<1> yep...they are, as well as everything in /usr, practically
<1> look here: http://livenudefrogs.com/~anubis/servers/apache_perl_mysql_chroot.shtml
<1> I followed that one
<1> well, that was one of the ones I've tried, the latest
<2> something is preventing PHP mysql .SO module from loading
<2> you need to find out what
<2> that is not in our power to remotely diagnose for you
<1> could it be chown?
<1> php won't work right in htdocs/ if it's not owned by apache user
<1> mysql has to be owned by _mysql
<1> well, the sock file anyway
<2> for the last time, this is not a mysql issue
<2> and now you go on ignore list
<2> bye
<1> lol, God bless u
<1> LD
<1> :D
<6> which is the first log position in a replication log file? in 4.0 format of these files was cleartext, one could just open it with an pager/editor but in 4.1 it seems binary
<7> Konfuzius: Binlogs were never in clear text
<7> Konfuzius: It is the same way in both 4.0 and 4.1. Use mysqlbinlog tool
<4> or learn the algorithm and open it in a hex editor :P
<8> is there a way to only insert a value into a table, if the column doesn't already have that value?
<8> without throwing an error if it does have that value
<4> sure
<8> how would you do it?
<4> the mysql insert statement has an update clause
<4> or something like that
<6> salle: thanks, will give it a try
<8> !m zaydana insert ignore
<9> zaydana: Nothing found
<8> doh
<8> oh, its in the insert page
<4> zaydana: just read the manual page on insert
<4> and it will tell you all about it
<8> yeah... having a look now
<7> zaydana: You can do it with REPLACE
<10> hi there
<7> zaydana: Or with INSERT ... ON DUPLICATE KEY UPDATE ...
<8> salle - theres no key tho
<7> zaydana: Then add some keys
<4> zaydana: it is never a good idea to have a table without a key
<8> its just a single column, a temporary table storing the result of a select
<7> zaydana: By the way can you elaborate more on what you are trying to do?
<8> cos i'm going to use every row later on
<11> how can I pipe/save the output of a mysql command line select query into a file?
<7> zaydana: When you say "insert" do you mean INSERT statement?
<8> yah
<8> INSERT ... SELECT statement, anyway
<7> andrewbryson: There are some cases when it's perfectly OK to run tables without keys
<7> andrewbryson: Althouth the theory regards that as a deadly sin :)
<7> zaydana: What you describes sounds like a Primary Key constraint :)
<4> salle: yes there are but the trouble is that if you change the table structure or end up with duplicates it is difficult to handle
<4> much better to always have a key
<4> in my opinion it saves a lot of unnecessary h***le
<8> well, the only time i'm ever going to use this table is to do "SELECT *"
<8> and possible to truncate it :-p
<4> you should never do select * either :P
<8> ok, select group_id then
<8> effectively the same thing
<7> zaydana: If you want to: "only insert a value into a table, if the column doesn't already have that value:"
<7> zaydana: That's exactly what Primary Key is for :)
<8> ok...
<8> so if I made the column the primary key
<7> zaydana: Just define the table with PK on that column upon CREATE .. SELECT
<8> ah k
<8> and then, if i try to add the same key again, it won't throw an error or anything?
<4> of course it will :P
<8> doh
<4> what would be the point of a primary key that did not throw an error if you tried to insert a duplicate ?
<8> yeah, thats what I thought :-p
<4> although you could use the insert statement to make it update instead
<4> on duplicate or whatever it is
<8> hmm... how bout set it as primary key, then add "IGNORE" to the inset statement
<8> I think that should work too
<8> insert*
<0> how can i view the permissions set on a user in mysql?
<4> select * from mysql.user;
<8> o0o, "replace" is exactly what I wanted.
<0> hey andrew it ype in that line and nothing happens
<5> do you have any standard way of checking whether record has changed since your last query in mysql4? using timestamp last_updated field is not the best idea, since in mysql4 it's precision is 1 second (yes, it can easily happen that two users update the same row the same second, and i query the db in between that updates)
<12> heyas
<12> is it possible for mysql 5 to use a restricted token 'call' as a column name in mysql5 in a certain configuration?
<8> minddog - call is used to call a stored procedure, so i'm guessing not
<12> zaydana, I'm being told by a developer that they can, they have no idea why.
<8> huh?
<12> create table ( ... call int not null, ... ) somehow works according to them on their test mysql 5.0.21 server
<8> oh
<12> I don't believe it.
<8> wouldn't know then
<13> minddog use backticks `call`
<14> hi hi
<12> archivist, must be their mysql client is inserting backticks for them.
<12> thanks for the help guys
<15> This is the correct way to make a 2 fielded database right, to save email and name in?
<15> $query="CREATE TABLE subscribe (id int(6) NOT NULL auto_increment,email varchar(15) NOT NULL,name varchar(15) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))";
<13> what does your server say
<15> got it fixed, on the output script i had misspelled my dbase
<15> thanks anyway archivist :)
<16> hi allis ther
<16> is there a way for me to get the month in day of the year?
<17> !m roders date functions
<9> roders: (Year 2000 Compliance) : http://dev.mysql.com/doc/mysql/en/Year_2000_compliance.html
<17> grr
<17> !m roders time functions
<9> roders: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<18> hi, why i cannot do an insert into a table called user in my own db ?
<19> hello
<18> something like: insert into user (bla, bla, bla) values (me, mine, myself)
<19> could anyone tell me whats wrong with this syntax please (im new to mysql):
<19> create table products {
<19> id int(10) not null auto_increment,
<19> title varchar(100) not null,
<19> description text not null,
<19> image_url varchar(200) not null,
<19> price decimal(10,2) not null,
<19> primary key (id)
<19> };
<13> what does your server say
Return to
#mysql
or
Go to some related
logs:
openwrt sonicwall
#openzaurus
#sql
Shinekaze
#openzaurus
easyubuntu public key
python like conch
#python
qmsn php
migrating from freebsd to linux
|
|