RE: where are the .MYI and .MYD files?
To Jimmy Guerrero, Paul DuBois and Fred Ballard, Your information was very valuable, I already solved the problem, thank you. Misingo :-) > Hello, > > A default install should drop data and databases into C:\Program > Files\MySQL\MySQL Server 5.0.\data > > If you run something like: > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could someone help this guy :-?
Paul DuBois wrote: Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html If a column is NOT NULL and contains no DEFAULT clause in its definition, the default is the implicit default for the column's data type. That's with strict mode disabled; in strict mode, columns with no DEFAULT clause must be given a value. This behavior sounds pretty logical to me, besides the fact that it is designed like that. Why would you try to put a NULL value in a column that you explicitly have forbidden to contain NULL values? In my opinion you don't know what you are doing when you use a CREATE query in which you define a column that can't be NULL and after that add a default value of NULL. So it seems logical that MySQL defined a default value for every type. So it is not comparable with M$ Access. If he says that you can do this with PostgreSQL, then I get the feeling that it is a flaw in the software. And might cause unexpected errors in programs. I guess I am also biased as I am very fond of MySQL... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Could someone help this guy :-?
Behrang Saeedzadeh wrote: Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html I think the answer to his questions lies in the manual: http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html If a column is NOT NULL and contains no DEFAULT clause in its definition, the default is the implicit default for the column's data type. That's with strict mode disabled; in strict mode, columns with no DEFAULT clause must be given a value. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL mailing list's strange responses
In the last episode (Sep 10), Behrang Saeedzadeh said: > Everytime I send an email to this maling list I get a strange reply > from MySQL like this: > > Sorry. Your message could not be delivered to: > > ml-mysql,FirstClass Server (The name was not found at the remote site. > Check > that the name has been entered correctly.) > > Could someone explain why am I getting these delivery failure messages > while my emails are delievered successfuly to the list? I bet the bounce message isn't generated by mysql's servers, rather some subscriber is behind a broken emails erver that sends its bounce messages to the "From:" header in the email instead of the envelope-sender. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL mailing list's strange responses
Hi, Everytime I send an email to this maling list I get a strange reply from MySQL like this: Sorry. Your message could not be delivered to: ml-mysql,FirstClass Server (The name was not found at the remote site. Check that the name has been entered correctly.) Could someone explain why am I getting these delivery failure messages while my emails are delievered successfuly to the list? Regards, Behi -- "We can only see a short distance ahead, but we can see plenty there that needs to be done." - Alan Turing "Science is a differential equation. Religion is a boundary condition" - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Could someone help this guy :-?
Hi, Could someone help this guy work around this problem in MySQL: http://www.redhillconsulting.com.au/blogs/simon/archives/000347.html -Behi -- "We can only see a short distance ahead, but we can see plenty there that needs to be done." - Alan Turing "Science is a differential equation. Religion is a boundary condition" - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: solidDB
At 12:39 PM 9/9/2006, you wrote: Hi, Are there plans to change the default engine of MySQL from solidDB to InnoDB, as InnoDB is now an Oracle product? Regards, Behi And while we're on the subject, how good is SolidDB? Is it better than InnoDb? If we wanted a fast reliable transactions for 24/7 database, should we choose InnoDb or SolidDb? TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--On September 9, 2006 4:28:29 AM -0700 deafmickey <[EMAIL PROTECTED]> wrote: What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. *blinks* OK nevermind. You're not going to be capable of doing what you want to do. What you want to do requires control of the mail server, and an understanding of how they work. There are plenty of howto's and FAQs that cover all of this elsewhere though. MTA == Mail Transfer Agentyou might know it as an SMTP server. Thanks Mel Michael Loftis wrote: --On September 9, 2006 12:11:15 AM -0700 deafmickey <[EMAIL PROTECTED]> wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)") or die(mysql_error()); ?> PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW-- tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- "Genius might be described as a supreme capacity for getting its possessors into trouble of all kinds." -- Samuel Butler -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
solidDB
Hi, Are there plans to change the default engine of MySQL from solidDB to InnoDB, as InnoDB is now an Oracle product? Regards, Behi -- "We can only see a short distance ahead, but we can see plenty there that needs to be done." - Alan Turing "Science is a differential equation. Religion is a boundary condition" - Alan Turing Behrang Saeedzadeh http://www.jroller.com/page/behrangsa http://my.opera.com/behrangsa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
What is MTA? I am not sure if GoDaddy supports Postfix. I will phone Godaddy to find out. Thanks Mel Michael Loftis wrote: > > > > --On September 9, 2006 12:11:15 AM -0700 deafmickey <[EMAIL PROTECTED]> > wrote: > >> >> I would like to create a MySQL to protect my subscribers and clients from >> receiving a spam emails. >> >> I can create a new table for MySQL and write new script for PHP >> >> MySQL: >> mysql_query("CREATE TABLE members( >> members_id INT NOT NULL AUTO_INCREMENT, >> PRIMARY KEY(id), >> email_address VARCHAR(50)") >> or die(mysql_error()); >> >> mysql_query("CREATE TABLE spam_free( >> id INT NOT NULL AUTO_INCREMENT, >> PRIMARY KEY(id), >> members_id (INT), >> fake_email VARCHAR(50)") >> or die(mysql_error()); >> >> ?> >> >> PHP: >> After my client / subscriber sign up as a member of my organization, php >> autmatically creates a new fake email address with my domain name i.e. >> doe @ mydomain DOT com in it. >> >> PROBLEM: >> I couldn't find a code or syntax that make mysql to redirect email to my >> subscriber from my client's email client and vice versa. >> >> Once our database matches sender's fake email address, MySQL would >> redirect sender's email to our member with a real email otherwise die. >> >> Is any one of you know the code that can get mysql to work and redirect >> email without go through php? (not use webmail). >> >> I believe its possible but I do not know what code for MySQL. > > > MySQL is not an MTA. This is the job of your MTA. Postfix supports > lookups via mysql, might want to try there instead. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6222963 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Shell
Hi Steve, You have to edit a file called ".tcshrc" which resides in your users home directory, and add ":/usr/local/mysql/bin" to the PATH environment variable. The tricky part is, this file is not visible to any text editor (for example BBEdit), so I always use a command line editor, for example (start terminal): vi .tcshrc Then use the down arrow key to search through the file to see if you find a line that begins with "setenv PATH". If not, add the line: setenv PATH "${PATH}:/usr/local/mysql/bin" Otherwise add ":/usr/local/mysql/bin" to the end, for example: setenv PATH ".:${PATH}:$HOME/bin:/usr/local/mysql/bin" To insert in "vi" press i. When you are done inserting press ESC. To delete a character enter "x". To quit and save, enter ":x". To abort changes, enter ":q!". On Sep 8, 2006, at 8:54 PM, Pastor Steve wrote: Greetings, Does anyone know how I can set up my shell so that the mysql command works without navigating to the directory? I am using Mac OS 10.2.8 and 10.4 shell> mysql –u name –p ?? Thanks, -- Steve Marquez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL: Spam Free (Send/Receive) Emails. HOW?
--On September 9, 2006 12:11:15 AM -0700 deafmickey <[EMAIL PROTECTED]> wrote: I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)") or die(mysql_error()); ?> PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. MySQL is not an MTA. This is the job of your MTA. Postfix supports lookups via mysql, might want to try there instead. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL: Spam Free (Send/Receive) Emails. HOW?
I would like to create a MySQL to protect my subscribers and clients from receiving a spam emails. I can create a new table for MySQL and write new script for PHP MySQL: mysql_query("CREATE TABLE members( members_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), email_address VARCHAR(50)") or die(mysql_error()); mysql_query("CREATE TABLE spam_free( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), members_id (INT), fake_email VARCHAR(50)") or die(mysql_error()); ?> PHP: After my client / subscriber sign up as a member of my organization, php autmatically creates a new fake email address with my domain name i.e. doe @ mydomain DOT com in it. PROBLEM: I couldn't find a code or syntax that make mysql to redirect email to my subscriber from my client's email client and vice versa. Once our database matches sender's fake email address, MySQL would redirect sender's email to our member with a real email otherwise die. Is any one of you know the code that can get mysql to work and redirect email without go through php? (not use webmail). I believe its possible but I do not know what code for MySQL. Thank you so much. Mel -- View this message in context: http://www.nabble.com/MySQL%3A-Spam-Free-%28Send-Receive%29-Emails.-HOW--tf2242963.html#a6221195 Sent from the MySQL - General forum at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]