Anyone know a good list for mysql under the hood?

I posted a question about running mysql in an Apache module. Maybe I need a list with a different focus. Please suggest. -Danny Swarzman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqlclient in Apache

odule, the call to mysql_real_connect() fails. Anyone have any idea why this is happening? Anyone have a suggestion of an email list that is more appropriate for this question? -Danny Swarzman -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

unexplained sigsegv, aborted backtrace

I have an unexplained crash I am trying to figure out. This is a pretty static system, that has been running fine for a couple years. It crashed at 7:45am which is after any nightly bakups have all been done, so not even under any load. All other aspects of the system such as i/o,ram,cpu, number

NULL or NOT NULL in relational design

be i guess, consistency; because you now have a value (NULL) which is not present in the country table. The country_id is an example, but you can guess there would be more examples you can think of. If I am not clear enough please let me know; and I can be more specific. Danny -- MySQL Ge

Re: doc for beginner admin

How about a start in the dev.mysql.com and browse for documentation. Start with the differences of all kinds of installations ;-) and using the [.]my.cnf file[s]. Cheers, Danny Bayrouni wrote: Hello, I would like to understand the mysql administration, is there any good doc for beginners

Re: Table Lock issue on insert

interesting and i am trying to get this error on my mysql databases by changing the bufferpool and inserting a lot of data; Best regards, Danny Brittingham, John wrote: They are InnoDB and max_write_lock_count=4294967295. The same thing happens when I create a copy of the table. -Original

Re: Table Lock issue on insert

Hi john, When did you start getting this error message? There aren't any trouble with MyIsam tables? Danny Brittingham, John wrote: They are InnoDB and max_write_lock_count=4294967295. The same thing happens when I create a copy of the table. -Original Message- From: Danny S

Re: Table Lock issue on insert

the error gone? Danny Brittingham, John wrote: I am having trouble with table lock. The query is as follows: INSERT INTO USERS_PER_HOUR SELECT count( DISTINCT ( CUID ) ),`TV_LOG_DATE`,`TV_LOG_TIME`, INTERFACE_ID FROM `TV_LOG_ALL` group by 2,3; I keep getting this error: #1206 -

Re: backslash and Update

he regexp function it doesn't work. But this sure does. Before you use the update, create a selection first with the regexp function; if that works, your update will do fine. Hope this little info helps you :-) Danny Jerry Swanson wrote: I have 290 records in the database with backsl

Re: How to insert CURDATE() as default

rm. Hope this little info helps you :-) Danny Marc wrote: I forgot to mention - I'm running MySQL 4.0.14 on Linux. And I'm not very knowledgeable on databases. I just use MySQL with Knoda to get the job done. == I've got a MySQL table that I'd

Re: STOPPING server from pid file

Hi, Did you check your error log file? Is there allready a pid file in the directory? You have to delete this one first. Hope this helps :-) Danny ali asghar torabi parizy wrote: hi to all i have mysql5.1 installed on fedoracore3 it was worked sucsessfully since yesterday. but when i

Re: Foreign Key with constant?

your ActivitySelections holds the data pure for this perpose. Hope this small info will help you on your way :-) Best regards, Danny Jesse wrote: I need to be able to add a foreign key that will allow a constant is possible. I have a table named Campers that has a field named ID. I also have an

Re: MySqld wll not start on Whitebox linux

change the permissions on the data directory to: mysql:mysql. Hopes this small description will help you on your way to run a complete mysql database :-) Danny Charles Gambrell wrote: I am running Whitebox linux 4 and have MySql 4 installed. When I run the mysqld_safe file, mysql starts then

Re: MySQL hangs each relative poor time

, see if it reacts the same as your database. can you tell me the mysql>\s values? i am just giving you some hints, to analyse the problem using trial and error. i am sorry i can't give you the full solluton; because too many factors can cause the error. Danny Roberto Rodriguez Garri

connect with myODBC to mysql through proxy

n isp address, the database name. connecting without proxy, that is directly, works fine; but i need to make a connection behind a proxy. Danny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Date storage format

Hello, Can anyone tell me what advantages there are in keeping dates and times in a MySQL DateTime field, as opposed to storing its string equivalent in a Varchar field ? Regards, Danny

Re: Recover from plain text log

Hi, I was wondering if you have solved your problem. I am quite interested excually. Best regards, Danny Todd Ellison wrote: OK, I am ready to get flamed. I have done so much stuff wrong on this MySQL server that it finally came back to bite me. I've learned my lesson and hope

Re: insert into... select... duplicate key

I am not familiour with Cold Fusion but: cant you use 'show columns from table' ?? and use the result object? This normally works in e.g. C or PHP danny Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote: I am using Cold Fusion and as I stated in my original message,

Re: insert into... select... duplicate key

utomate an export and use the load datafile to import the information; but then again you have to rewrite the datafile. Best regards, Danny Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote: That is the effect that I am looking for, but exactly the method that I am trying to avoid. If

Re: insert into... select... duplicate key

ill automatticaly be applied :-) Danny Schimmel LCpl Robert B (GCE 2nd Intel Bn Web Master) wrote: Here is the problem that I am having. I am trying to make a copy of a full record in a table that has a primary key with auto-increment. The real problem is that I want the statement to use SELECT * so t

Re: mysql_hex_string() c-api

I thought it was something like that ... I just found it strange allready. I'll give it a try, thanx. Danny Paul DuBois wrote: At 19:43 +0200 8/16/05, Danny Stolle wrote: Hello all, can somebody explain to me the c-api mysql_hex_string(). when i debug my example in DDD i get the ful

mysql_hex_string() c-api

i use the values which are used in the insert-string and convert them into hex using this function? the example provided in the documentation is not realy helpfull though. hopefully i am clear, otherwise please let me know. Thank you. Danny Stolle Netherlands. -- MySQL General Mailing List

Replication stops on ALTER TABLE ; keep on getting "duplicate column names"

thread with "SLAVE START". We stopped at log 'CentracDB-bin.013' position 2989111 Any idea on what could be causing this ? Regards, Danny

Re: Good Oracle Forum

Daniel Cummings wrote: This forum has been very helpful. There is always somebody that is willing to respond to queries. Does anybody know of a good Oracle forum? TIA Dan Dan, You could try http://www.lazydba.com/ Best regards, Danny Stolle Netherlands. -- MySQL

Separate disk for logs, DRBD ...

ith 3 disk each - 1 for the OS, the other for Data, and the last one for Logs. If the Logs disk crashes, will MySQL be able to write logs to the Logs disk on the 2nd server via DRBD ? Regards, Danny

Re: Create an Innodb database ?

ngine by setting the mysqld-option: --default-storage-engine=type similair to --default-table-type=type in your .my.cnf file. So now also my question: When to use innodb instead of myisam? What performace advantages does this engine have? Danny Stolle Netherlands -- MySQL General Mailing Lis

Re: mysql "forgets" user passwords

Michael Stassen wrote: Danny Stolle wrote: Chris Fonnesbeck wrote: I have mysql 4.1.12 installed on OSX 10.4, and have run into the curious problem that mysql forgets my user password (but not my root password) when I restart the server. When I attempt to log in, I get: ERROR 1045 (28000

Re: mysql "forgets" user passwords

'localhost' (using password: YES) Yet, when I go in as root and re-grant permissions with the user password, access is restored. When I reboot, I get the error again. What could possibly be causing this? Thanks, Chris Fonnesbeck Sorry again ... forgot the mailing group ... "Did you &#

General-list comment

Is there a problem with the mysql-general list? I haven't had any messages? Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Doubt on MySQL for Linux...

n find the installation program and tutorials to help you get through MySql If you are new to Linux, then perhaps reading some stuff about linux first. Good luck and enjoy :^) Best Regards, Danny Stolle Netherlands EmoeSoft (http://www.emoesoft.nl) -- MySQL General Mailing List For list arc

Re: mysqlshow question

Berman, Mikhail wrote: Hi Danny, Thank you for helping me here. Yes, I am aware of need to have the space between --host=xxx and --user=xxx, and command I am executing actually has a space. It looks like you believe that my problems related to security of remote logon. That is something, I am

Re: mysqlshow question

-h -D - mysqladmin -u -p -h flush-tables are you granted for a remote logon? does your mysql-client tools hang as well? the statement show a no-space between '--host=xxx--user=xxx' it should be '--host=xxx --user=xxx' or are you aware of that? Best Regards, Danny Stolle N

Re: strange database grant to mysql database

d on. Best Regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie mysql.sock question

Paul Mitchell wrote: On Tue, 14 Jun 2005, Danny Stolle wrote: if i start my mysqld it creates a mysql.sock because of an option in my.cnf: socket="/tmp/mysql.sock" when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed. does your system errors when start

Re: help joining tables in a query

James M. Gonzalez wrote: -Original Message- From: Danny Stolle [mailto:[EMAIL PROTECTED] Sent: 15 June 2005 21:09 To: James M. Gonzalez Subject: Re: help joining tables in a query James M. Gonzalez wrote: Greetings, I'm facing a difficult query at the moment. I have tried

Re: discuss: user management: conclusion

Danny Stolle wrote: hi, i would like to discuss 'user management' in mysql. Working with Oracle you can assign users to roles giving them privileges provided by that role. MySql doesn't have Roles. I have read (Managing and Using MySql, O'Reilly) 3 options on managing u

Re: CREATE TABLE and specifying DEFAULT

he also got the nulls after ID_streettype_spec_hosp. he is working with version 5.0 mysql server. this has got to be a bug, or there must be something else going on. Danny Stolle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Newbie mysql.sock question

uot; when i `mysqladmin -u root shutdown` the database, the mysql.sock is removed. does your system errors when starting mysqld? Best Regards, Danny Stolle EmoeSoft, Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: discuss: user management

Peter, that is an interesting formulation which you gave. can you please comment that with an example? would you create roles for users who are assigned the same privileges and individual users who have multiple roles? Best Regards, Danny Stolle Netherlands Peter Brawley wrote: Danny /&g

Re: discuss: user management

George, from a MySql point of view, how would you deal with security on a site? would you than create individual users? Best Regards, Danny Stolle EmoeSoft, Netherlands [EMAIL PROTECTED] wrote: Danny, My 2 cents (American dollars): From a security standpoint (if you are a financial

Re: discuss: user management

would somebody create roles?' is an interesting question. i have no direct answer to this question. the only thing i would come up with is: when you have a lot of tables and you have to change a privilege on several tables. you have the choice for changing that for 40 users each or 5 roles each

Re: discuss: user management

other privileges? he will get a new or already created role userID, but would still be able to logon using the previous user id. why wouldn't you choose for the 3th option or 1st option? what disadvantages do you think would option 1 and 3 have? Best regards, Danny Stolle EmoeSoft, Nether

discuss: user management

ust plain simple (or stupid) what are your experiences on user management in a MySql environment. Best regards, Danny Stolle Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE and specifying DEFAULT

fer euh .. would that be on a windows platform ;^) ?? i am running the 14.7 on a linux distro and i have no trouble since ... danny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: CREATE TABLE and specifying DEFAULT

fer euh .. would that be on a windows platform ;^) ?? i am running the 14.7 on a linux distro and i have no trouble since ... danny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to read TINYBLOB fields from the database

ields works just fine And if i do the same way on blob fields i see just garbage like "&*(^yuhg789" But i know that fields holds a number or word. So i think its something to do with converting binary-format to ?. Danny Terweij. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to read TINYBLOB fields from the database

a TCL environment (with an tcl mysql library). So you feel my question... How to read human readable values from those fields so i can process them furter with tcl ? Thank for any reply. Greetings, Danny Terweij -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

RE: Long Running Queries

uot; would mean indexes on columns specified in your where criteria. On this List, people mostly post table structures, as well as the queries they are firing, or else it really doesn't help. -Original Message- From: Danny Willis [mailto:[EMAIL PROTECTED] Sent: Thursday, October

RE: Long Running Queries

What do you mean by "appropriate indexes?" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 3:43 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Long Running Queries You need Appropriate Indexes on the tabl

MySQL backup not backing up all tables

x27;m a newbie with MySQL, so I don't know what other info to provide. I appreciate your help. Danny S. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL backup not backing up all tables

x27;m a newbie with MySQL, so I don't know what other info to provide. I appreciate your help. Danny S. * Adventure Cycling Association Inspiring people of all ages to travel by bicycle. 800/755-2453, 406/721-1776 www.adventurecycling.org -- MySQL General

Q: Can't Connect to MySql Server

Hello, I am from Indonesia and newbie in Mysql. Why if I execute command MySql in dos prompt, appear in screen " ERROR 2003 : Can't connect to MySql Server on 'localhost' (10061) Thanks Dani - Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want.

Restoring database doesn't restore all tables

, I check my DevDBs database, and it has been updated, but not all tables that I'm expecting to be restored have been restored. Further, the DevDBs directory has only about 250 megabytes of data, rather than the one gigabyte I am expecting. Any help would be appreciated. Danny

Long Query Times

Hi all, I am curious to know if the query times I'm seeing are reasonable or not. Here's my situation: I am using a database to keep up with web statistics. The table is currently growing at about 2 million records a day. The sample table I am working with has right at 4 million rows. When I exe

Re: BLOB images in Crystal Reports

Crystal was pulling the data through MyODBC, Mascon was just used for inserting the image into the database. hth danny On Thu, 2003-10-09 at 16:20, Director General: NEFACOMP wrote: > I want to ask you one thing: > Is your Crystal Report accessing the database through the Mascon U

Re: Compression: Security or Zipping?

ffic, like you would get when trying to decompress a 10k part of a large zip file. hth danny On Tue, 2003-10-07 at 10:49, Director General: NEFACOMP wrote: > Hi group, > > I have read in the MySQL manual that the client/Server Compression protocol adds > some security to the applica

mysqlhotcopy generates a segmentation fault

1.18, perl 5.8.0, libdbi-perl (1.35), libdbd-mysql-perl 2.1026 Danny. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: getting NULL in auto_increment column

gerald_clark writes: >Danny wrote: > >>Can you update an auto_increment with NULL in MySQL? Obviously if you >>try and put a NULL in directly it will increment to the next integer. >>Is there some way to actually get a NULL in there instead of the >>integer? >&

getting NULL in auto_increment column

Can you update an auto_increment with NULL in MySQL? Obviously if you try and put a NULL in directly it will increment to the next integer. Is there some way to actually get a NULL in there instead of the integer? - Before postin

Re: From Win2000/IIS to Linux/Apache ?

been a long time Linux fan) because the IIS boxes were driving me up the wall (poor reliability, inflexibility and the torrent of fixes and patches). Ever since then i've been a devout LAMP (Linux, Apache, MySQL & PHP) fan. The platfo

Re: Managing replication logs

I too would be interested in a good way of clearing the binary log files (preferably non disruptive to the server ;-) The only thing thats saving me so far is that the systems capacity is 320Gb. danny Anirudha Kukreti wrote: hi all i have established a two way replication setup my problem is

Re: Query

ctStopTime FROM radacct; danny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To uns

Re: advice

living on the "edge of a knife", running a production system on 4.0.1/2/4/5 for the last few months, had some minor problems with 4.0.3 but every other release has been quite solid. So, no, I dont think you'll run into any prob

Re: My big table is locking for few minutes

some user have "Too many connections" error. I've "solved" problem with wait_timeout=120 instead of 28800 but this is not a good solution. I assume you are using mysql_pconnect()? That way, PHP will reuse old connections instead of opening up a b

OT Re: Mysql, PHP and a wrapper

e option '--with-mysql' in the './configure' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNAT

Re: MySQL as a desktop DB

t, when dealing with large databases? Depends on your hardware, but in the MySQL world 300,000 records is considered "small". Either way, i think you'll get a lot more performance out of MySQL on a single user system than access. H

Re: How much stable is MySQL in a production environment?

db and a joy to work with. We have roughly 300 users, local and remote (spread all across the uk on broadband connections) and the system remains in use 24/7. It's been running solid now for seven months. danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

Re: Access denied in MyODBC

' IDENTIFIED BY "password"' allows access for that user and my testuser can use any database. danny Sándor Tamás wrote: | Sure I have. In fact if I use 'Grant', I don't have to 'flush'. But I've | done it too. It didn't help. | | SanTa | |

Re: Store pictures in DB

in the database that get used to "sign" the certificate by crystal reports. The database seems to run fine but the signature pics rarely exceed 10k. IMO, if you have large pictures its best to store the filename in the db and put the pics somewhere else. danny - -- Dan

Re: The Important question

to use pretty good parts. Anyway, I swapped the ram out for some nice Kingston ram and switched the FSB to 133Mhz again and still no problems. HTH Danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email

Re: Report writer

d a little like going back to dialup after having months of time on broadband ;-) danny NZEYIMANA Emery Fabrice wrote: | Can you please help me? | | If you can help direct me where to get a report writter running on Windows. | By reading your post, you know some report writters that run

[Fwd: Re: MyISAM to InnoDB]

S and temporary tables. (keep it simple eh?!?) so i think the shift will be quick and easy. I have a windows of about 3 hrs to down the server make the changes and get it operational again so I though it wise to check first! Thanks again all, Danny - -- Danny Ha

MyISAM to InnoDB

id be pleased to hear from you! ;-) Many thanks and best regards, Danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Ve

Re: MySQL on Redhat 7.3

module installed. you may want to go find and install this. as with any (re)installation i recommend you make a backup of your database first (usually /var/lib/mysql) if you have important information there. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

Re: My Replication Story

started jumpin' under real load. I know this probably isn't of much use to you, i'll try writing up a few perl scripts to create some "virtual load" and see what happens then. If there's anything else i can provide for you to help trace this bug d

Re: How to use Auto Increment

. | | How can I do it in MySQL. after inserting into the auto_increment table, do a 'SELECT LAST_INSERT_ID()' which will return the last autoincremented value. You can use this value in your second insert statement. danny - -- Dan

My Replication Story

the master. any pointers gladly taken, however small.. best regards to you all, danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SI

Re: help with installation

I think you need to install both the mysql-client and the mysql-server? What does the output of "rpm -a" say? (this lists all the rpm installed) What does "whereis mysqladmin" say? - Original Message - From: "Steve Dickey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July

Re: About insatallation on Linux

Whenever you install someting like mysql on Linux RH you should consider using RPM (Redhat Package Manager) Go to the www.rpmfind.net and do a search for mysql - Original Message - From: "Javier Gonzalo Gloria Medina" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 06, 2

Re: How to access mysqladmin from IE?

Besides using Phpmyadmin to edit the data. I actually prefer to use something like webmin to manage my data. Do a search on Webmin on the internet. - Original Message - From: "Aqua" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 12:42 PM Subject: How to access

Re: help starting up mysql

Hello, What version of UNIX are you running? Solaris, Linux, FreeBSD, BSDI? You can find that out my typing in uname -a - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 11:01 AM Subject: help starting up mysql > Hi, > I hope I'm at t

Compare 2 resultsets from 1 table

93 BBB| 143 | 22 CCC| 344 | (NULL) <- There are NO field2=1 where field1=CCC DDD | 287 | 38 etc. How can I do this? Thanks, Danny - Before posting, please check: http://www.mysql.com/manual.php (t

shutdown of MySQL fails during system reboot or halt

Hello there, I have an issue where upon system (YellowDogLinux v2.2) reboot or halt, if the mysqld is running i get the message that shutting down mysql: FAILED Has anyone experienced this? Or can someone perhaps help me understand what is going on? Sincerely, Danny

shutdown of MySQL fails during system reboot or halt

Hello there, I have an issue where upon system (YellowDogLinux v2.2) reboot or halt, if the mysqld is running i get the message that shutting down mysql: FAILED Has anyone experienced this? Or can someone perhaps help me understand what is going on? Sincerely, Danny

Dual master/slave config

chine should then (manually) reboot and the database should start to catch up with be new master. - Are the any of you that have experience with this kind of setup? How did you do it? Any info on this would be great. Cheers, Danny Kruitbosch sql, mysql,

Re: Dual master/slave config

ailover. The >failed machine should then (manually) reboot and the database should start >to catch up with be new master. > >- Are the any of you that have experience with this kind of setup? How did >you do it? > > >Any info on this would be great. > > >Cheers, >

Stop query after first match

d limit the results afterwards by using LIMIT 1). This is mainly for boosting the performance of mys queries. Actually where using mysql to dynamically assign ip addresses to our dial-in users. We query the database for available addresses -> there are more than 1 available but I only need 1! Th

help on mysqlimport

I try to run the import test as listed in the document. mysqlimport: Error: The used command is not allowed with this MySQL version, when using table: imptest My server version: 3.23.49. What is the problem? How can I fix it? Thanks! Danny

Re: Rename a Database?

mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -

login script

Hi Ok, This must be a fimiliar login script. I want to change the target of werk.htm in the header to a specific frame. How to do that? something like in html Danny FROM user WHERE username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW'"; $result

error connecting to mysql using JDBC

MySQL reported this error when i tried to connect using JDBC : Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException the funny thing about the error is that it only happens once in a while. Meaning that an SQL statement mig

query in UDF??

on that do the query with the variable given by the user... if it's impossible, can you restrict a user to only 1 query that he cannot modify? Danny - Before posting, please check: http://www.mysql.com/manual.php (the

Re: Enquiry

I bet you downloaded the source code version and not the binary version. check your download. Daniel Katcher 202-619-7643 ( voice ) 202-619-7655 ( fax ) [EMAIL PROTECTED] >>> "Amit" <[EMAIL PROTECTED]> 04/07/01 12:40PM >>> Dear Sir, This a mail from a new established software company. We are

Re: Security Mysql

Look very carefully at the mysql database by typing in mysql -u root -p mysql Look at the manunal for how you can INSERT INTO the user table or how you can use GRANT On Thu, 05 Apr 2001, J.Heegsma wrote: > >%_Dear Sir/Madam, > > I am a student and my teacher want's to try to break in into

Using dual processor solaris box

processor makes it faster than if I were to get mysql running on both processors? Or maybe I am even wrong about using pthreads being the method to have mysql take advantage of both processors? -- struct Programmer/Analyst 'Danny Rathjens' {this.place = "MyCity.com";} "How

Re: delete

In some RDBMS there is something called ROLLBACK. However, I am not sure if MySQL does support features such as ROLLBACK, If mySQL doesnt support ROLLBACK then you need to do a recovery from your previous backups. On Sat, 03 Mar 2001, Pål Wester wrote: > When you delete somthing... is there

Re: !!! Mysql hangs after some days on FreeBSD 4.0I-Helll

-Hello - If you are running FreeBSD 4.0 why not install mysql using /usr/ports/database/mysql-server.3.xxx make install make clean On Tue, 13 Feb 2001, pdewaha wrote: > Hi, > I've mysql 3.23.32 running on FreeBSD 4.0. > It runs a site with heavy traffic and heavy > database

Re: CREATE TABLE / Telnet (Linux / Unix server)

The .sql or txt file has to be on your LINUX machine. However, I recommend you should create the .sql or txt files in the LINUX machine using vi , pico or whatever your favoprite text editor mitght be. Looking forward to your feedback. dannyh [EMAIL PROTECTED] On Mon, 12 Feb 2001, C.o.m.b.u.

Re: Fwd: MySQL problem

Have you create a startup script in /etc/rc.d? I believe you haven't created a startup script and you should type in ps -gax to see if mysql is running. On Tue, 06 Feb 2001, Vadim Selitskiy wrote: > Hi > How are you? > No, I used rm command to delete, because rpm told that it is unable to > r

Fwd: MySQL problem

-When you deleted the rpm version of mysql did you use the rpm command to dlete mysql? - What version of mysql are you trying to install? - Maybe, look at deleteing all the current mysql rpm with the rpm command and try it without the --no-deps option. - Or install a prevous version of mysql?

  1   2   >