| |
| |
| |
|
Page: 1 2
Comments:
<0> hi, are there any transaction suppor on mySQL 3+ ?
<0> transactions support
<1> just gonna throw a question out there....
<1> whenever i input dates into a mysql table and then extract them via a cgi-script ....
<1> the dates are followed by 00:00.0
<1> anyone know why this is and how to get rid of it?
<2> anyone here ?
<3> XenReborn: nope
<4> we had a user that rang up and bitched saying "My computer wasn't even turned on between 9 am and lunch time - there's no way I did 1.6 gigs" we checked his raw_data.... 1918 addressess visited between 09:00 and 13:00 and one of them was 69.50.167.10...
<4> I tell you what.. I wish my computer could bittorrent and be turned off... think of all the money I'd save on power
<4> and that's why I keep a 50+ million row table...
<5> i need some help
<1> don't we all
<6> salut
<7> how can i see whats the root p*** by defualt
<7> on linux
<8> there isn't one by default. you have to set it
<7> how do i set it on linux
<8> http://tyson.homeunix.org/notes/mysql.html
<9> can anyone tell me whats wrong with this?
<9> Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/
<9> ..
<9> with this line .. $RowCount = MySQL_NUMROWS($Results);
<9> =(
<7> thankzzz
<10> the query failed saf
<9> oh.. so the problem is in the query?
<9> ok thanks ! :D
<7> mysqladmin: connect to server at 'localhost' failed
<7> error: 'Access denied for user 'db_user'@'localhost' (using p***word: YES)'
<7> i m getting this error
<7> how can this b fixed
<8> typically that means you typed the p***word wrong
<7> how can i set the set p***
<7> when i trying to set the p***
<7> its giving me error
<8> what error?
<7> linux:/var # mysqladmin -u root p***word 'muslims'
<7> mysqladmin: connect to server at 'localhost' failed
<7> error: 'Access denied for user 'root'@'localhost' (using p***word: NO)'
<8> are you sure there wasn
<8> 't already a p***word set?
<7> than y its not accepting
<7> mysqladmin -u root -h hostname p***word 'muslims'
<7> shall i try this command
<8> sure, but i don't think it will change anything
<7> same error
<7> is there any config file
<7> or what the command to reconfigure mysql on linux
<8> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<11> hi!
<7> thankz
<7> it worked
<11> Hello to everybody, I'm having a problem, could anybody help me?
<11> I have MySQL Server 5.0 installed on windows
<11> It crashed but I saved the data directory
<11> I don't know how to recover it
<11> I overwrite the old data directory but the service does not start
<8> the data tables and the "mysql" table are two different ballgames
<11> and can i recover my data from the data directory I saved?
<8> did you backup the mysql table?
<8> yes, but you need a myslq table
<11> I just could copy the whole Data directory
<11> I don't know if there is any way of solving my problem with it
<8> the mysql table (db rather) controlls everything
<8> permissions etc
<8> do you have that backed up?
<11> mmm
<11> whre is it normally?
<11> I've saved the WHOLE mysql directory
<11> where mysql server is installed
<8> the one with the executables or the one with the data?
<11> everything I guess
<11> bin, data, share, scripts
<8> they aren't in the same place
<11> ...
<11> Where is the data then?
<11> isn't it on the ibdata1 file?
<11> i use innodb
<8> i don't use innodb but mine are in /var/mysql/mysql
<11> I'm forced to use windows in our local machines :(
<11> but i also have this mysql dir
<11> :)
<11> with the myi and myd files
<11> isn't it? I've got it too
<8> yes, that's myisam
<11> well, then I think I have all the data
<8> the dir "mysql" contains all the files (tables) for access privs
<11> but I don't know how to get my data back :( with the hundreds of hours dedicated
<8> in theory, you can just copy the directories back into place. but i've never done that myself
<11> The fact is...
<11> I do this but my server doesn't work :(
<11> same server
<11> same version
<11> everything is the same but nothing works
<8> you copy while it's shutdown and then restart?
<11> yup
<11> but when I start again nothing happens
<11> my server just doesn't work
<8> what error?
<11> let me see
<11> can't connect to MySQL server
<11> error 2003
<8> how did you try to start the server and what error did you get?
<11> well
<11> in windows mysql installs a service
<11> before I overwrite the folders with my data everything works ok
<11> after that, the service is down and it's impossible to repair
<8> well, windoze is flaky
<11> xDDD
<11> I'm gonna restart it
<8> in theory, you kill the "service" copy the date, and then start the service again
<11> this is what i do, but the service does not start again
<8> with what command?
<8> what errors do you get?
<12> anyone here?
<11> let me install it again, i'll be back in a moment
<12> im having a problem, when triying to insert greek chars like alpha in a utf-8 collation,
<12> am importing it from a csv file, which is saved in utf-8 too.
<8> black2019, you don't have to re-install the whole thing. just use the mysql_install_db script
<8> later, i've got to go out to the shop for a while
<11> c u later on then
<1> anyone around running a pc with excel that can try a simple web query for me?
<1> i have a mac and excel on mac doesn't support web queries
<13> does anyone know the name of the login page file? I need to add a message to it. It's not index.php, it's not main.php
<8> login.php?
<13> that's what I woulda thought, but that doesn't exist. I think it actually is index.php but first figures out if you're authenticated and shows a different screen based on that.
<13> argh.
<8> whatever php app you are using probably has a channel somewhere that can help
<13> I'm using phpMyAdmin
<8> yep, there's a channel for that
<1> does anyone know if sql can add values in a table for you
<14> hah
<14> only if you ask nicely!
<1> pretty please?
<14> heh, you ask nicely in a different way
<14> try looking in the manual for the INSERT sytax
<1> i'm new
<14> thats cool
<8> http://dev.mysql.com/doc/refman/5.0/en/tutorial.html
<1> ok
<14> yea you read those docs you will be doing good
<15> I'm interested in hiring a C Programmer with 4 years experience with Linux to work from home.
<14> heard that
<14> im looking for a jr php developer, can work at home also
<10> hehe wtf
<10> knox, there was some guy in here the other day that said he had 4 years kernel development exp :)
<10> errno or something
<10> !seen errno
<16> errno (dimple@modemcable142.132-70-69.mc.videotron.ca) was last seen quitting 3 days, 26 minutes ago stating (Quit).
<10> not sure that was him though
Return to
#mysql
or
Go to some related
logs:
#linux
#MissKitten
#linux
uselib24 mambo
#javascript
getdataback file signature
zimbablue
#AllNiteCafe
appendtext richedit
passing char * modify
|
|