mysqlclient in Apache

, 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 unsubscribe:http

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]

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

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 General

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

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 Stolle

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

; is 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: How to insert CURDATE() as default

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 like to have the current date

Re: backslash and Update

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 backslashes. I want to remove the backslashes. Why the query

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?

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 another

Re: MySqld wll not start on Whitebox linux

) and 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

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 Garrido wrote

connect with myODBC to mysql through proxy

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 hopefully

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

will 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

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

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 I type

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, if I were

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

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 full sql

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

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

'CentracDB-bin.013' position 2989111 Any idea on what could be causing this ? Regards, Danny

Separate disk for logs, DRBD ...

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 ?

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 List

Re: mysql forgets user passwords

' (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 'flush privileges'? Danny

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

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...

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 archives: http://lists.mysql.com/mysql

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: strange database grant to mysql database

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

Re: mysqlshow question

- mysqladmin -u username -ppassword -h host 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 Netherlands

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 many

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 starting mysqld

Re: CREATE TABLE and specifying DEFAULT

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: 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 users having multiple

discuss: user management

(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: 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, Netherlands

Re: discuss: user management

?' 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. Best Regards, Danny Stolle EmoeSoft

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

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 /1

Re: Newbie mysql.sock question

` 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: CREATE TABLE and specifying DEFAULT

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

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

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

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/mysql

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

RE: Long Running Queries

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 07, 2004 1:24 AM

MySQL backup not backing up all tables

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

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 Mailing List For list archives: http

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

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

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 Utility

Re: Compression: Security or Zipping?

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 application. Does anyone have more

mysqlhotcopy generates a segmentation fault

, 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]

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

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? No. Why would you want to? Because I have

Re: From Win2000/IIS to Linux/Apache ?

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 platform is rock solid and extensible beyone belief ;-) HTH danny

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

Re: advice

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 problems ;-) regards, danny

Re: Query

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 unsubscribe, e-mail

Re: My big table is locking for few minutes

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 brand new one each time. danny

Re: MySQL as a desktop DB

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. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2

OT Re: Mysql, PHP and a wrapper

' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using

MyISAM to InnoDB

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- Version

[Fwd: Re: MyISAM to InnoDB]

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 Haworth

Re: Report writer

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 on windows

Re: The Important question

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 : [EMAIL PROTECTED] (mailto:[EMAIL

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 - -- Danny Haworth

Re: Access denied in MyODBC

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 | | - Original Message - | From: Danny Haworth [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday

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

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 System Administrator Gas

Re: MySQL on Redhat 7.3

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 System Administrator Gas~Elec

My Replication Story

, danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla

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 - -- Danny Haworth

Re: My Replication Story

' 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 down. let me know. danny - -- Danny Haworth

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 19, 2002

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, 2002

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 the

Compare 2 resultsets from 1 table

| 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 (the manual) http

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

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, query

Re: Dual master/slave config

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 - Before posting, please check: http

Stop query after first match

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! Thanks in advance! Danny

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?

/ (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 -- _.,-*~`^'~*-,._ Danny Rathjens _.,-*~`^'~*-,._ In mathematics, you don't understand things. You just

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 a href=blabla.htm target=_parent Danny FROM user WHERE username='$PHP_AUTH_USER' and password='$PHP_AUTH_PW

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

query in UDF??

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 manual) http

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 my

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

Using dual processor solaris box

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 can I prove I am hum

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

Re: Data Modeling

For UNIX users (eg BSD, linux) there is something called dia which allows you to draw ERDs But, I assume you are looking something more like a RAD tool rather than a simple program that allows you to draw UML, ERD's etc. However, if you are intersted in dia and using Linux you can find the

Re: read-only tables

Hello Thats probably you username in user table has given you only SELECT prilvages (Select_priv) You can log in as root in mysql and UPDATE the user table to give you INSERT, DELETE privlages Refer to any sql book on the syntax of UPDATE On Fri, 02 Feb 2001, Matthew Halliday wrote: I have

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   >