#apache #archlinux #asterisk #centos #debian #gentoo #haskell #kde #kubuntu #lisp #math #mysql #perl #python #ruby-lang #rubyonrails #suse #ubuntu #vim #wikipedia 0 1 2 3 4 5 6 7 8 9 10 11 12 13
Top Prev 5412 5413 5414 5415 5416 5417 5418 5419 5420 5421 5422 5423 5424 5425 5426 5427 5428 5429 5430 Next
#mysql
<archivist> float is not precise 0<>0
<archivist> often its some small no like .000000000001
<T`> oh.. what happens if i dont saw what length i want the decimal to be.. like instead of decimal(11,5).. if i do decimal(5) ?
<elaine> CareBear: oh that's odd. I don't understand this and I'm probably doing this wrong. I've started the daemon without first starting the server (using mysqld_safe) and that works
<CareBear\> elaine : The daemon is the server.
<elaine> in the link i pasted earlier, it said to start the server with mysql_install_db and then start the daemon
<CareBear\> mysql_install_db creates privilege databases.
<CareBear\> And should be run exactly once per server instance.
<elaine> oh i see ... sorry my bad - didn't read the line properly. it does say initialise db
<elaine> I'm sorry I'm really new to this.
<CareBear\> Food.
<mt3> Ok, I have the 'other photos in this category' section working now, thanks guys
<rawtaz> hey all :)
<rawtaz> i have a question.. i know the major majority of webhosts do not allow external access to mysql, at least when there's a shares mysql server (which is mostly the case). i'm wondering what the main reasons to their restriction is? is it security in the authentication part on the server, security in the protocol used between server and client, or something else? perhaps the fact that ppl tend to have insecure passwords, and that there's been some sec
<rawtaz> i have tried to find this info on google, but there isn't much about it. it like it's just a fact..
<nils_> well the protocol ist not encrypted by default so that might be a consideration
<Getty> never heard of that limitation
<Getty> you mean they are not allowed to access an external mysql outside of the ISP?
<rawtaz> nils_: oh ok. so passwords and all data is sent clear text?
<rawtaz> Getty: sorry i was a bit unclear. i mean that the hosting company does not allow external hosts to access the mysql databases of the users
<nils_> rawtaz, I don't know exactly, I think there is some sort of challenge system, but I think it's the data that is more interesting
<nils_> and the more applications you open to outer access the more potential security holes you have
<rawtaz> nils_: ok :) do you knowif they're going to encrypt it anytime soon?
<rawtaz> nils_: indeed
<nils_> rawtaz, there is support for SSL already.
<Getty> rawtaz: ah that is clear
<Getty> rawtaz: cause of security
<Getty> rawtaz: why give anybody the possiblity to hack the SQL?
<Getty> even if mysql itself is secure, there could be a security hole at any moment
<nils_> rawtaz, it might also be helpful to assure that you can only use your database with THEIR webspace so you can't overload the server.
<Getty> my mysql server doesnt even has a real IP
<nils_> Getty, how do you connect to it if it doesn't have an IP?
<Getty> if xen would give me the possiblity to share a socket between domUs i would even dont give him any IP
<Getty> nils_: internal IP
<nils_> oh well non-publically-routed ip adresses are still real ;)
<snoyes> axisys: -N
<axisys> snoyes: excellent!
<mindeq> hi all
<mindeq> please tell me what's command to install tables from a *.txt file to a database ?
<snoyes> mindeq: what's in the text file? SQL statements, or just rows of delimited data?
<mindeq> i made useing phpmyadmin > export
<snoyes> and which type of export did you choose?
<mindeq> now i choosed sql
<snoyes> ok, then you can import it by going to the Import tab, and selecting the file as indicated.
<mindeq> hm
<mindeq> but in that server where i'm going to imprt sql .. there is no phpmyadmin
<mindeq> i have to type in a bash ..
<snoyes> then you do mysql < /path/to/the/dump/file
<mindeq> k i'll try, thx
<snoyes> Depending on how you exported it, you might need mysql dbName < /path/to/file
Previous Page Next Page