| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> hi anyone here using the mysql-administrator under linux?
<1> Sieg: you could restart with --skip-grant-tables and then load the data
<1> flamingcow: probably not
<1> ligi: probably
<2> i have a problem for mysql ...who can help to me?
<1> Daveman: moooOOOOoooo!!!!
<1> sanalav: 42
<3> :D
<4> inviso: ok, tks
<1> Sieg: I would also use --skip-networking if you're connected to a network when you skip the grant tables
<2> is mysql db have a admin p***?
<1> sanalav: by default, no
<5> evening
<1> hey Jax
<5> evening Invisible_Magi
<5> !
<1> lol
<5> :D
<6> mysql spams my syslog when SLAVE is startd
<5> you guys know if there are any guidelines to when to use XML attributes over nodeValues ?
<1> Jax: buh?
<6> i turned all log's off, but it still logs a lot
<1> nelius: continously? Or just on startup?
<5> i guess there are only semantical guidelines
<6> Jan 31 23:11:43 d80-237-145-132 mysqld[1214]: 060131 23:11:43 Slave: connected to master 'slave_user@192.168.2.1:3306',replication resumed in log 'mysql-bin.000005' at position 3368981
<6> inviso: continoulsy!
<2> how can i add admin p*** in to mysql?
<5> run: mysqladmin -u root p***word 'yourP***word'
<1> !m sanalav securing initial
<7> sanalav: (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<6> inviso: any idea?
<1> nelius: looking
<6> i don't even understand the message of the log :-(
<2> Jax: ty
<2> inviso: ty
<8> hey
<8> im having trouble setting up remove access to mysql
<8> it works, but it's painstakingly slow
<1> nelius: didn't find any logs like that on my box. Going to look at my config
<8> the authentication seems to take forever
<8> any ideas on what might be causing this?
<1> Exnor: reverse dns lookup against a non-existant dns server
<8> hmm yeah i thought about that, and the mysql server is running in a chrooted environment
<8> so i checked the resolv.conf
<8> and it all looks ok there
<6> inviso: i get about 3 logs per second... thats not good :-)
<1> nelius: can you throw your /etc/my.cnf up in a pastebin?
<6> mhh, lets see, i've never worked with pastebin
<1> Exnor: Try disabling reverse dns lookup and see if that helps
<1> !m Exnor dns
<7> Exnor: (How MySQL Uses DNS) : http://dev.mysql.com/doc/mysql/en/DNS.html
<1> nelius: see /topic
<8> will try cheers
<9> Hey all, I am running 4.1.16 and I used phpmyadmimn to export data only (no stru) to reimport into another table. I am getting errors where The "mysql said:" shows nothing. What am I supposed to get from that?
<1> probably hitting php timeouts. phpMyAdmin isn't really appropriate unless you don't have much data
<6> inviso: just pasetd it
<1> nelius: url please
<6> http://hashmysql.org/paste/viewentry.php?id=1382
<6> a lot is uncommented, cause i copied it from my first conf. this is a second server listening on port 3304
<8> inviso: that fixed the prob
<1> Exnor: excellent :)
<8> inviso: i guess im not missing out on much by disabling that
<8> inviso: my user rules are not based on host so i'm ok
<8> (i guess)
<8> cheers
<6> inviso: http://hashmysql.org/paste/viewentry.php?id=1383
<6> inviso: this is a more complete snipset of my log
<6> inviso: seems there is a problem reading a peace from the master, but i have no idea how to fix that
<9> inviso: If you were speaking to me then, no, I don't have alot of data,
<1> nelius: yeah, looks like replication is broken. I'd fix that first and be thankful for the log messages :) I can't help much in that regard
<1> Wolftech: how long before you get that message?
<9> inviso: A second or two. I posted the code I was trying on: http://pastebin.com/532925 maybe you can see something that I don't.
<1> Wolftech: perhaps a max size of some sort in PHP? It just cuts off at that point?
<10> good evening. I have a table A(start datetime, end datetime). How can I create a trigger which, upon insert, updates all existing rows setting end = NEW.start ?
<9> inviso: I can check that, I hadn't realized that php had that kind of control over mysql though?
<10> it gives an error "can't update ... already used by statement which invoked this stored function/trigger"
<11> Wolftech php has a timeout (30 secs default) as well as an upload limit
<9> inviso: I don't see anything in the mysql section of the php.ini that deals with a max size or anything. Suggestions?
<11> both adjustable in php.ini
<11> its a general setting
<9> archivist: I have the upload limit at 10mb and I just changed the timeout to -1.
<9> archivist: I just need to restart apache to test.
<12> how do i empty a database?
<11> 0 for infinite iirc
<1> dfgas: "empty" it?
<12> remove all data
<1> !m dfgas truncate
<7> dfgas: (TRUNCATE Syntax) : http://dev.mysql.com/doc/mysql/en/TRUNCATE.html
<9> Nope, still got the same behavior/error with no desc.
<11> phpmyadmin may be getting in the way
<1> Wolftech: time to go hunting error logs.
<11> and apache has limits set as well
<11> sql import via phpmyadmin is borked
<1> for all sorts of reasons
<9> inviso: I tried to find them first but was unsuccessful.
<9> archivist: Huh? Please define?
<1> Wolftech: Not much we can do but guess without a decent error. If you really want a gui, any reason you aren't using mysql administrator?
<11> phpmyadmin trys to do too much
<5> can php make FKs ?
<9> inviso: I am using linux. Is there a linux vers of it? I haven't looked yet.
<5> didn't find it
<1> stuff it shouldn't try to do
<1> Wolftech: yup
<9> inviso: On my way then.
<9> :)
<1> And don't even get me started on webmin... Web.. Administration.. of my OS!?!? buh
<9> inviso: I look at it this way. If the people that workon/develope an app suggest something then it's good enough for me. :)
<9> inviso: no doubt. I have only used it for very specific things. Everything else I do manually.
<11> never tried webmin, too modern, i still use vi
<13> inviso
<1> omi
<13> In my application number of reads will be !slightly! larger than the number of writes
<13> less than factor of 1.5
<1> that's quite unusual
<13> I'm building a configuration manager/distribution server. the only time that database will be read is when it is time to update configuration to some server. and that happens when something is modified in the database
<1> nothing ever just looks up the configuration?
<13> the other time is when someone wants to get a layout of the network, but that will be very rare
<1> well, your other option is to hack up a stored procedure that emulates the behavior of the connect prior construct. Also, I don't know what data you're storing in hierachy, but node data shouldn't cause the node indexes to change. Only the addition or deletion of nodes (servers I suppose?) would affect node position
<1> omi: Regardless, you've got two different approaches to look at now. Pick the one that works best for you
<14> i got a question, when i import LARGE .sql files (thousands of lines) via phpmyadmin in firefox, the browser always freezes... is there a way to configure the browser to not timeout
<13> this application will generate configuration files for dns servers, router configs, firewall rules based on which cl*** the server belongs to
<1> ltR^: Short answer: Don't use phpmyadmin for that
<13> I think what I'll do is for now get the basis of the application going then do benchmarking
<1> omi: always a good plan :)
<14> inviso, i can't connect to the database via the program i downloaded
<13> :)
<13> In fact, I think there will be data that is more likely to be read than written to, I might in fact try to conbine recursive extraction and preordered traversal
<14> i got one more question
<14> what's the best resource to learn mysql?
<14> any good sites
<13> a project and a deadline
<11> using it
<9> inviso: Ok, got it installed. I have used the win ver before but I am not seeing any way to import data at all much less from a .sql file. Ideas?
<15> <17> edobefe: Define "database was updated" <-- each time a database gets a new record
<16> why is wrong with this or why it isn't working. TIAS i already did
<16> http://pastebin.com/532977
<17> edobefe: Databases don't get new recors you know ...
<17> edobefe: Databases consist of Tables
<17> edobefe: You can INSERT new Row into a Table, but not into Database itself
<1> Wolftech: building a current version
<9> Is there a way to use the cli for inport data into a db using a .sql file? (I've never attempted this before so I have no clue)
<1> Wolftech: yup, mysql -u user -p < myfile.sql
<9> inviso: Huh? I don't follow.
<1> Wolftech: I'm building a current version of mysql-administrator so I can take a look :)
<16> what is the reason this dont work.. http://pastebin.com/532977
<1> !tell us about doesn't work
Return to
#mysql
or
Go to some related
logs:
rp8_linux20_libc6_i386_cs2_rpm ubuntu
snd_pcm_dmix_open unable to create IPC semaphore
Cannot open display nvidia-settings
rdate connection refused ubuntu
ubuntu sudo update-alternatives --config java
ubuntu switch resolution
hda3 arsss
samba bad_network_name
#xorg
#gentoo
|
|