| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> whats the quickest, most efficient way to load a data file that's in fixed column width format (no delimiters)
<0> I'm thinking running it through sed to split up the columns with tabs (and remove whitespace) and into mysql...
<1> ok, running the fix script with --skip-grant-tables active worked.
<1> everything's up and running :)
<2> I have two tables POSTS: (title, description, post_time, post_id) & PICTURES: (picture_id, post_id, filename) I'm trying to grab a list of posts in order by time and with each single post have it grab one random picture, there will be multiple pictures ***igned to each post but i only want to select 1 random picture that's ***igned to that particular post, and i want to be able to grab at least 15 posts all in one query.... any suggesti
<3> !m zardinuk load data infile
<4> zardinuk: (Problems with NULL Values) : http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html
<3> erm..
<3> !man load data
<4> (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<3> !m zardinuk load data
<4> zardinuk: (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<5> can some one tell me how can i get some value from mysql db and use it in bash shell scripting
<5> like
<5> echo "select username from users where username=$user" | mysql -u$dbuser -p$dbp*** $dbname
<5> now i want username to be reditect to some variable so that i can compare
<3> L|NUX: ./bin/mysql mysql --skip-column-names -Be "select user from user where user='root'"
<5> hum
<5> humm
<5> thanks alot
<6> I'm looking for the uber'ist mysql geek.... to run a messed up mysql cluster setup by
<7> How do I get mysql to enable me to log in remotely? 4.1.11.
<8> set a user and p***wor
<8> p***word*
<7> I have root user and p***word set and then ran GRANT ALL PRIVILEGES ON *.* TO "root@%" IDENTIFIED BY "p***word";
<7> the FLUSH PRIVILEGES;
<7> It still won't let me in.
<7> ... remotely.
<7> I'm using MySQL Administrator and it can ping the server Ok.
<9> mischko: it may be a libmysqlclient.so difference.
<9> mischko: what version of the server are you running?
<7> 4.1.11
<7> I'm in.
<7> Syntax on that GRANT was wrong. Should be 'root'@'%'
<9> I was about to ask you what "SHOW GRANTS FOR 'root'@'%' " gave you
<10> anyone know of a good cheap server control panel? similiar to plesk?
<7> I deleted the goofed up user and all seems to be well.
<11> can you make mysql case in-sensitive? for table names
<10> hrm if i do run a control panel on my linux box, will i be able to control my box from my windows box?
<8> a question for MYSQL ppl... if I make lets say a table filled with users and their contact info.. is it possible for me to back up all the information within a few commands?
<9> VictorI: it is.
<9> it just isn't for database names.
<11> its case sensitive, I need to make it case insensitive
<11> sqlobject does not support capital letters in table names
<7> Ainslee, if you're wanting to control your Linux box's MySQL database from a Windows box, I'd suggest MySQL Administrator and MySQL Query Browser.
<11> bah the downsides of using an ORM tool
<7> Ainslee, they are GUI applications, not running in a web browser.
<3> Murdoc: sure
<3> !m Murdoc mysqldump
<4> Murdoc: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<12> MySQL Administrator in general rocks
<8> hmm... but what if I want a php script to do that?
<8> does this have to be run through MYSQL client?
<9> VictorI: SET GLOBAL lower_case_table_names = 1
<11> thank you
<9> available from 4.0.2 onward
<9> VictorI: as a note, you will need to create your tables while this option is enabled.
<9> I've just tested it out.
<11> I noticed that
<9> just make a dump, enable the option and import the dump
<9> the import will convert the names.
<11> btw under [mysqld] ?
<11> in my.cnf
<9> yea
<11> thanks, this helps a ton
<9> no problem :)
<13> i don't have idea how to do mysql
<13> mysqli*
<9> gin_: what exactly are you looking to do?
<13> TodoInTX, i want convert mysql to mysqli
<13> i don't know how to do it mysqli
<9> gin_: in php?
<13> TodoInTX, exactly :)
<9> http://us2.php.net/mysqli
<13> TodoInTX, i saw it but i do not understand somethings really
<9> first you need to make sure that mysqli and mysql interfaces are compiled into your php
<9> this will make it so you can have a transition period.
<9> you'll see it in the phpinfo(); screen.
<13> yes i know that script but do you know, how is called in debian mysqli name to download with apt-get ?
<9> In Fedora both interfaces are in the php-mysql rpm.
<9> it may be the same for debian but I really have no idea.
<13> i have installed, php-mysql
<9> ok but it doesn't have mysqli.so ?
<9> you need to be running php5 to get mysqli.
<13> TodoInTX, where should be that mysqli.so ?
<9> There will probably be a line in the php.ini file that lists the "extension_dir" value
<9> it would be in the extension dir.
<9> for me it's /usr/lib/php/extensions
<14> TodoInTX, hey you there man ???
<9> yea
<14> TodoInTX, check your query dude
<9> huh?
<9> what query ?
<9> oh... that one...
<10> :D i have my databases on my linux box
<10> my site is all ready to go bar the dns delegation
<15> Morning all
<15> I have an error message "Error: Commands are out of sync; you can't run this command now" while attempting a select. The message makes sense, but I still can't see what I'm doing wrong - anyone have any ideas?
<16> hi
<16> a winblows user is asking me how to upgrade his mysql server on his machine
<16> how to do that? (i don't know in winblows, never used at least mysql on it)
<16> any link of a tutorial i can send to him? i'll appreciate it
<17> )
<15> Zaki :- http://savage.net.au/Perl/html/upgrade-mysql.html <-- I've not tried this myself but a google for "windows upgrade mysql" finds quite a few.
<15> afaik the windows side of things is as simple as "Add Remove Programs" to remove one version and then a binary installer to install the new one. As for backing up data and user rights - thats beyond me but should be the same as under linux.
<18> hmm
<10> hrm i'm trying to ***ign a user and a p***word to a database and it says effecting 0 rows, any ideas why?
<16> MrCraig, thanks alot = )
<15> np
<19> Ainslee, without knowing anything at all about what you're doing no
<10> kestas: just moved my databases from one server to another, the databases on my new server haven't got a user and p***word ***igned, so i've done that, but it said effecting 0 rows when i did it
<19> Ainslee, oh I thought you were talking about a custom app, nm
<19> no idea
<10> k
<20> hi guys!
<20> I appear to have made a blunder, wonder if anyone can help? I've got a table which does auto numbering, but it seems to have gone out of sync, as I accidently changed the number to a record and now every future number is following that record
<20> is there a way to reset it?
<20> hi
<20> hi AmigaNetscud
<20> hi tearfate
<21> hey
<20> :D
<20> whats up
<21> hmn i donno,i still havent start any mysql thingy
<20> why man?
<21> i havent read the instructions
<21> how about u?
<20> ahh
<20> i am running mysql but i got a problem with a table i screwed up
<21> ic
<21> well,sorry i cant help ya
<20> no worries dude
<20> I will figure it out
<21> oh nice
<22> Hm, I have the Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) in /var/www/bmgt/index.php on line 45 error in my php script. starting the mysql-client does not work either, altought the socket seems to exist. any input on that one?
<22> this is an ubuntu linux system
<19> you sure the socket exists and mysqld is up?
<23> hi
<22> *checking* mysqld fails on startup ...
<22> what does mysql refer to as "system log"
<23> that would prolly be syslog
<23> ****
<23> i have virtigo again
<24> how to set the root p***word in mysql ?
<23> nikls: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<23> sheesh my testicles are squashed to ****
<23> this laptop is heavy
<23> hi Arthur
<23> Arthur Daley?
<24> how to add a newuser and p***word
Return to
#mysql
or
Go to some related
logs:
#centos
how to become superuser in gnome in ubuntu
gnome-terminal paste shift+ins
#oe
ubuntu firestarter minimize
dri geode debian
trackman wheel and xorg.conf
Call to undefined function: ctype_alnum()
irc client xfce
rug suse unable to create installation source
|
|