| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> you should apt-get phpmyadmin
<1> ah yeah i used that before when i was setting up sugarsuite
<2> You should define what you are looking to do.
<2> In specifics. Databases are a tool. What are you going to do with it.
<1> Im looking to have a website where people can enter text into multiple fields and submit the information
<2> For what?
<1> I figured a database would be the best way to maintain the information entered.
<3> korhalf: yeah, will is echoing my vague question, what is the purpose and how do you want to do it
<2> A database stores that information in a manner so you can look it up easier.
<1> well i dont know how i want to do it lol, I can't really tell you more than I have already
<0> Are you writing the website in PHP?
<4> so I would like to do a select where field is like something then update those fields all with mysql .. I know there is a way I just can't remember can anyone help?
<2> korhalf, Tell us what you want to do. SPECIFICLLY.
<1> have a webpage, user enters information, those information are ***igned to tables or fields or w.e you guys call that in SQL
<2> Esotericisms, SELECT FOR UPDATE?
<2> korhalf, Stop talking about generals and how the computer will do it. What do you want?
<4> I tried that on a test table and it updates all the fields
<1> that.
<2> What kind of information? What kind of data? What are you going to do with it?
<0> I think the first thing you should focus on is getting MySQL configured correctly
<1> Lol, now I don't know what YOU'RE asking of ME
<3> korhalf: that is to general, like asking how do you cross a street
<0> korhalf: Will you be hosting the website on your server?
<1> Yes.
<0> Have you set up apache?
<1> Yes.
<0> PHP is working correctly?
<1> I have a LAMP im certain
<1> well i havent tested php with apache yet.
<0> What settings have you already configured on MySQL?
<5> i have LAP... can't install mysql ;/
<1> nothing, ive set the p***word
<3> korhalf: the best thing you might want to do is browse some websites that provide commonly used tools used in a LAMP environment
<2> Esotericisms, What are you looking to do?
<0> typically, after installing MySQL you can use this command to access it from the shell: mysql -u USER -pP***WORD
<4> I have like 700 entries in my table, I would like to find all the have a certain word in their name, and update another field for each entry found in that table with the select
<5> what if i get this:
<5> igor@almeida:~$ mysql -u root
<5> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<5> ?
<0> korhalf, I can ***ist you further if you need it.
<2> Typically you define the project, the requirements,before thinking about how it's going to be done.
<2> xwolf-, /var/run/mysqld/mysql.sock does not exist. Search your system to see if it does exist, and if MySQL is running.
<5> kSysGuard says mysql is there.
<5> there is not even a mysqld folder
<5> and i did nothing but what was written on install-binary file in the tarball
<1> jbrimble, I logged in successfully
<1> jbrimble, I also have phpmyadmin set up
<2> xwolf-, How did you install MySQL?
<5> tarball
<2> More specifics
<5> mysql-standard-4.1.18-pc-linux-gnu-i686.tar.gz
<2> Where did you get it?
<0> korhalf, phpMyAdmin does most of the work for you, you should be able to create the database and its tables from there
<5> mysql's official site
<1> jbrimble, I'm ***uming I need something to communicate with the Database from my webserver though
<1> I was thinking to do it in python because im more comfortable with it then PHP/Perl
<2> Ok. Most likely you have MySQL already installed on your system. Look for a my.cnf file.
<5> /etc/my.cnf is there.
<5> i mean
<5> /etc/mysql/my.cnf
<2> Look in it. Do you see anything that talks about a sock?
<2> And that location above?
<5> yes
<5> for the three sections [client], [mysqld_safe] and [mysqld], sock=/var/run/mysqld/mysqld.sock
<5> sockET
<2> Do you have a .sock file on your system somewhere?
<5> lemme look
<2> Check /tmp
<5> is .sock the entire filename?
<2> mysql.sock
<2> or mysqld.sock
<5> there is a mysql.sock in /tmp
<6> php
<2> xwolf-, Change all references from /var/run to /tmp
<6> Hi
<2> ho
<6> how's it going mr. will?
<2> xwolf-, YOu have another mysql version installed on your computer already. I'd look to uninstall that.
<2> M3, Badly
<6> why?
<7> Explain tells me that in a join, the left table has 18920 interesting rows and the right has 1 .. that's not a lot, so why is the query taking minutes?
<2> My wife is divorcing me. My kids hate me. I'm being audited by the IRS, I lost my job. Going to jail for child porn....
<6> omg, will
<7> will: become a country western singer ..
<6> will: sorry i asked
<2> Sounds like fun.
<5> will i don't think so... but well... should i change this one too? follows: pid-file= /var/run/mysqld/mysqld.pid
<2> Just delete or comment out the line.
<2> Mysql does not install a my.cnf So you must have had it installed somehow.
<2> Woosta, Interesting rows?
<5> i'm going to install the tarball again, ok?
<7> the 'rows' column in explain
<2> No
<2> Reinstalling it does not do anything.
<2> Everything is fine. Just make sure you uninstall the old version.
<2> Woosta, Read what the "Extra" says. What is your query?
<7> SELECT l.id FROM message_log l JOIN message_recips r ON (l.id = r.message_id) WHERE (l.company_id = 1367 AND r.company_id = 0);
<5> yes will, i'll delete all mysql installations i find ;P
<7> left: Using where; Using index ... right: Using where
<2> xwolf-, What distro?
<5> kubuntu
<2> Using an index on everytyhing? Paste your explain to topic's pastebin.
<2> xwolf-, Look at it's packagement tolls and uninstall any MySQL server stuff
<7> http://hashmysql.org/paste/viewentry.php?id=1660
<2> Woosta, How many rows does it return?
<5> will libapache2-mod-auth-mysql, libdb-mysql-perl, libmysqlclient12, libmysqlclient14, mysql-client, mysql-common, php5-mysql, python-mysqldb, python2.4-mysqldb...
<2> Woosta, Drop the ( ) around your WHERE
<5> will adept found these installed mysql packages
<7> will .. none so far .. still running!
<2> Woosta, When it's done, how many did/does it return? How many SHOULD it return?
<7> actually .. may have lost the ssh connection :)
<8> what's the correct syntax for "ego", to display the results vertically?
<2> xwolf-, I don't know...
<0> !tell us about collation
<9> But I don't know a thing about that.
<8> ego select * from table <-- doesn't work :(
<2> ego?
<7> will .. finished: 550 rows in set (9 min 52.62 sec)
<0> !tell us about tables
<9> But I don't know a thing about that.
<8> will: type help at a mysql prompt, ego is meant to display results vertically
<10> Is is possible to have grouped fields in select output without losing rows, for example, to have total sales for cities shown in every line of output, but still lines for all the transactions returned?
<2> mlambie, SELECT * FROM table\G
<8> argh! :)
<8> thanks will!
<11> Hi y'all, I want to run replication all automatically thru a bash script. I am not sure but I don't think you can do mysql commands right from a bash shell, what prog. lang. can I do this in?
<2> I have no idea what "ego" is, even though I see it in help. Who uses that anyways?
<2> rado_, mysql --help
<11> hi will
<11> kk lemme see, thx
<5> brb
<10> will: for \G is there a way to do that in batch transactions at the command line, like mysql < file.sql? All I know is the -t switch.
<2> peqe_, I think there is a mysql --flag for it
<2> mysql --help
<10> will, thanks, mysql -E
<11> will, you saying just from the bash prompt # mysql [OPTIONS][database]?
<11> but like could I do something like the following from bash:
<11> mysql> GRANT SUPER,REPLICATION CLIENT,REPLICATION SLAVE,RELOAD ON *.* TO repl@"slave.host" IDENTIFIED BY 'p***word';
<2> You can run that query from the mysql command line.
<2> mysql --help
<11> interesting...thx!
<11> but there is a p***word problem I suspect
<2> Why do you suspect a p***word problem?
<11> oh, you know how normally from bash you do:
<11> # mysql -u root -p
<11> then asks you for your p***word
<5> will if i have a mysql installation, which files should bear its configs/
<2> rado_, Put a .my.cnf file that contains the p***word in your home dir. Or specify the p***word on the commandline -pp***word
<2> xwolf-, ?
Return to
#mysql
or
Go to some related
logs:
EFNET mur
apache 2.2 dbdriver debian
FC5 labview
linux MCP2S problem
python execv spaces
#linux
#suse
#perl
spca9xx
code2diagram
|
|