| |
| |
| |
|
Page: 1 2
Comments:
<0> greetings mysql seers.
<1> How do I copy or move a backup.sql to a MySQL database?
<1> mysql -u root -p database < file.sql?
<2> yeah dont forget the dtaabas name
<2> mysql -u root -p p***word database < file.sql
<3> ... that won't work NeoFu7ure
<3> Alexender: had it right..
<3> the -p will only result in getting asked for a p***word
<3> not --p***word=myp***
<0> hrm. do versions require diffenences? like in the dump or import?
<3> yes
<3> upgrading tend to be less cumbersome than downgrading
<2> K_F can you try and resolve acc001.owuk.net for me
<2> mysql -uroot -pp***word database < file.sql
<2> sorry
<3> ;; ANSWER SECTION:
<3> acc001.owuk.net. 1800 IN A 195.195.109.176
<2> hmm
<3> ;; Query time: 4297 msec
<2> oooch
<3> NeoFu7ure: iirc you can't use -p like that
<2> i just added it
<2> yeah can K_F
<3> hmm, yeah
<2> hehe
<2> you are rtight tho
<2> no spare will result in p***word promp
<3> in?
<2> t
<2> leme try that again
<2> You are righ tho, no space will result in a p***word prompt
<3> "a space"
<2> mysql -uroot -pp***word database < file.sql is correct
<2> mysql -u root -p p***word database < file.sql is correct
<3> yeah
<2> will expect the database to be "p***word"
<3> jup
<2> i still cant resolve that acc001.owuk.net
<0> has anybody here upgraded from 3.23 to 4.0? is it recommended? ...on fedora core 1
<3> NeoFu7ure: http://dnsstuff.com/tools/ispdns.ch?name=acc001.owuk.net&type=A
<3> uhm, not that one
<3> treebark: 1) upgrade OS
<3> 2) upgrade MySQL
<3> and 4.0 as well is old
<3> should go for 4.1 or 5.0
<0> i'm using 4.1 in development atm
<3> NeoFu7ure: http://www.dnsstuff.com/tools/lookup.ch?name=acc001.owuk.net&type=A
<0> ...but have client data on a remote dedicated server running 3.23
<0> ..tough to upgrade the os of a remote machine...so i'm working with it, but i hear you.
<3> server running fedora smell oddly in the first place
<0> perhaps. is your opinion based on understanding of issues or preference?
<3> "understanding of issues"?
<0> issues with fc1
<3> In the words of Manuel: "I know nooooothing"
<3> I know nooooothing. I'm from Barcelona.
<0> then fedora core 1 is fine, but yeah, i'd upgrade if i could. i do on machines that i can.
<3> </sarcasm>
<3> hehe
<2> <CLONK>
<3> NeoFu7ure: hopefully you got the Faulty Towers reference
<2> yeah
<2> course i did im from the UK
<3> treebark: obviously didn't
<2> lol
<3> but yeah, that is a must see show
<3> I actually bought the DVD set not too long ago
<2> yeah
<2> excellent
<3> nice to have an archive
<2> great british humour
<3> had been 10 years since I saw it before that
<3> yeah, good old 70's humor
<3> 75 was it?
<3> great show anyhow
<3> but it is 0320 here, I should get some sleep
<3> g'night
<4> sup
<2> hey beebum
<4> looks fine to me
<4> 24.93.41.125
<4> that's one of the ones i use
<2> leme try
<2> nah i still cant resolve
<2> :@
<4> strange, i got to that site just fine
<4> i may get lost in cyberspace for a moment
<5> what is 'or' with sql request?
<6> or
<5> :P thx
<7> Hi everybody !
<7> I have a question : is it possible to execute a query from a string with mysql ? (something like that : exec ('drop table' + table_name) <- work on sqlserver)
<7> directly from mysql console, not with an application like php
<8> hello
<8> i try to learn php and mysql
<8> i want to find some examples
<8> can you give me an hint?
<8> an example of creating an user and p***w in a database
<8> thank you
<9> how do i create a mysql user? i have installed mysql-4.0.26-win32
<4> grant
<9> ?
<4> http://dev.mysql.com/doc/refman/4.1/en/
<4> you should read chapters 2 and 3
<9> i've searched through that but i didnt find anything..
<4> the manual is searchable. search for 'grant'
<9> ok thanks
<9> in linux was useradd ...
<4> not in mysql on any os
<9> ok found, thanks:)
<3> beebum: thank you for handeling that one, Sisqo was close to being out of here
<4> heh
<3> there, http://www.kfwebs.net/news/474/Active24+Windows+hosting+problems is updated
<4> cool
<10> damn I wrote the wrong thing
<10> fixed :)
<4> heh
<10> mind though two things, I first looked at only today's development, but decided on a greater perspecitve
<10> but still wrote "today's development"
<10> the marketing has been on stability / reliability
<10> then they go about with a 16 hour downtime
<10> ... good move
<4> lol
<10> that is active24 ...
<10> try http://www.p***ive12.net :)
<4> active24 what? active 24 minutes/day? ;)
<10> hehe
<10> thought it was fun to bring up p***ive12.com/.net anyways :)
<10> danger of selling domains, too easy to add new ones
<10> I have way too many of them
<4> ;D
<11> INSERT INTO inscripcion VALUES ('','$matricula','$nombreeste','$apellidoste','$curso','$fechanacim','$lugarnacim','$nacioste','$edad','$direccionste','$telste','$celste','$emailste','$hermanos','$nombrepadre','$apellidopadre','$dirpadre','$naciopadre','$pr<
<11> I get an sql error: #1064 - You have an error in your SQL syntax near 'I' at line 1
<11> anyone could help?
<3> 1) this isn't a PHP channel, ask strictly SQL questions here
<8> hello
<8> i need a little help
<8> i have an sql file
<8> how i made a databse from it and opened with phpmyadmin?
<8> thank you
<3> rtfm
<8> what is that?
<3> read the "fine" manual
<4> http://dev.mysql.com/doc/refman/5.0/en/index.html
<8> ok. thx
Return to
#mysql
or
Go to some related
logs:
#linux
#linux
#AllNiteCafe
cashmier plant
#windows
what is the name of dilbert's company's competitor?
piruj
#linuxhelp
pinoymp3
xxl kuwaity
|
|