#mysql
05 October 2007
Total 19 pages. You are browsing page 5/19.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
05:02 <****> Fiveohthree, right-click your connection, create new database, name it "mytest"
05:03 <****> SDr, k
05:03 <****> Fiveohthree, click on the newly created database, click query (top level), new query
05:03 <****> hello, can somebody look over my question
05:03 <****> this will give you a query editor, you can do everything here, which you would normally do from the console session
05:04 <****> SDr, k
05:04 <****> SDr, query builder, query editor
05:05 <****> type: create table users(id int not null auto_increment primary key, username text, password text);
05:05 <****> this will create a dead simple user table
05:06 <****> (you can look up the messy details later)
05:06 <****> SDr switching comps brb
05:07 <****> uhm
05:09 <****> Fiveohthree, how to insert new rows: insert into users set username="susan", password="mypass";
05:09 <****> hm, another question
05:09 <****> Fiveohthree, how to query a table: select * from users where username="susan";
05:10 <****> let's pretend that mysql-server is running on ComputerA and that a client is accessing it from ComputerB
05:10 <****> where shall i place "no-auto-rehash" then?
05:10 <****> Fiveohthree, for further research, please consult with your local google about "mysql tutorial" ;)
05:10 <****> pbmh: Your dump isn't compatible with version 4.
05:10 <****> SDr, but where do i put the query command in my html page?
05:10 <****> into the client-directive of my.cnf at ComputerA or at CompuerB?
05:10 <****> Fiveohthree, oh, that's what you will need php for! :)
05:11 <****> SDr, i have seen commands but dont know where to put them?
05:11 <****> SDr, so mysql is database but php retrives it?
05:11 <****> yeah
05:11 <****> SDr, kk can you help me make a table .. then help me query it? thats all
05:11 <****> pbmh: You can probably re-export using an option to create a version 4 compatible dump.
05:11 <****> SDr, i can figure out rest from there
05:12 <****> in the query editor, type: create table users(id int not null auto_increment primary key, username text, password text);
05:13 <****> it will be displayed on navicat under tables, you can browse around it, insert new rows, etc
05:13 <****> Fiveohthree, how to insert new rows from sql: insert into users set username="susan", password="mypass";
05:13 <****> SDr, typed create table stuff ,, then hit run?
05:14 <****> yeah
05:15 <****> SDr, then close? save changes to the query?
05:16 <****> you don't have to close it, you can use it for further queries, but whatever
05:16 <****> SDr, oh i didnt have a table yet to query
05:16 <****> SDr, sec
05:18 <****> hi again
05:19 <****> how to allow to a host to connect to mysql using root access? from remote host
05:19 <****> !m kareena GRANT
05:19 <****> kareena see http://dev.mysql.com/doc/refman/5.0/en/grant.html
05:20 <****> thx
05:21 <****> SDr, kk i made the table users with the id username and password...
05:21 <****> SDr, I inserted susan and mypass
05:21 <****> SDr, but says (MEMO) under user name and password
05:21 <****> hello
05:21 <****> im trying to import a database dump
05:21 <****> and i keep getting character set errors
05:22 <****> pbmh: what is the version of the db you dump and the db you import
05:23 <****> hello
05:23 <****> I'm using MySQL 4.4 in conjunction with PHP 4.something
05:23 <****> Anyone else wana help me with mysql and php for bit?
05:24 <****>
05:24 <****>
05:25 <****> Fiveohthree, view / toggle memo
05:25 <****> will show you the text fields
05:26 <****> Fiveohthree, for select,see my earlier message
05:26 <****> pbmh - mysql 4
05:26 <****> is there a way in shh to grab the exact mysql version
05:27 <****> the dump is from a mysql 5 server
05:27 <****> SDr, there is no togle mmo in view.. or do i type that?
05:28 <****> SDr,found it
05:29 <****> SDr, so where is the file that is being made here? so i can put in the www folder
05:30 <****> uuuh, it doesn't work that way
05:30 <****> <kimseong, you there?
05:30 <****> SDr, damn
05:30 <****> mysql has tons of data files
05:30 <****> kimseong you there?
05:30 <****> SDr, so i just make a .php in www folder ther querys tables?
05:30 <****> but to display it on html, you'll need php to do the queries, and generate the resulting html file
05:31 <****> SDr, so i need to download php too
05:31 <****> Fiveohthree: it is not so simple, you need to learn about server side scripting like php
05:31 <****> Fiveohthree: start from php.net and find some tutorial to get started
05:32 <****> Fiveohthree, here's one tutorial which will introduce you to basic php scripting: http://www.webmonkey.com/webmonkey/99/21/index2a_page4
05:33 <****> Fiveohthree, for your next 16 question, please consult #php ;)
05:34 <****> so now that i got mytest table up the rest is #php
05:34 <****> yupp
05:34 <****> kk thanks much
05:34 <****> is there a way to dumb down the mysql imports
05:35 <****> so it ignores errors
05:35 <****> i keep getting coalition errors
05:36 <****> pbmh: mysql client?
05:36 <****> pbmh: there is a force option
05:36 <****> -f ?
05:36 <****> mysql client?
05:37 <****> the dump is from mysql 5.0, im importing it to a 4.0 server
05:37 <****> pbmh: then all your data will be encoded in utf8
05:37 <****> it has a bunch of 'DEFAULT CHARSET=latin1' 's
05:37 <****> your char/varchar might be too short
05:37 <****> do i have to manually remove all those
05:38 <****> pbmh: hopefully you can dump again with compatibility flag set to 4.0 or set the charset of the dump file to latin1
05:38 <****> yes i can dump again
05:38 <****> but only in php my admin
05:38 <****> the compatibility flag of mysqldump may help
05:38 <****> i dont have ssh anymore on the old server
05:39 <****> dump from phpmyadmin? that sometimes does not work very well when you import
05:39 <****> how do i set a compatibility flag in php myadmin?
05:39 <****> i don't know how and probably no such option
05:40 <****> crap
05:40 <****> dont swear in here please pbmh
Total 19 pages. You are browsing page 5/19.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last