Let's make a difference
I'm doing a little something for the earth, and I thought I'd invite you to join me: http://friends.earthscreen.com/?r=UQF0KDIIICdXCWoICigCi=gmail[EMAIL PROTECTED]p=2z=1tc=23 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Let's make a difference
I'm doing a little something for the earth, and I thought I'd invite you to join me: http://friends.earthscreen.com/?r=EQFEKDIIICdXCWoICigCi=gmail[EMAIL PROTECTED]p=2z=1tc=23 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
regarding supersmack
Can i generate date type values with super smack.The format specifiers show only string and integer . Thanks -- sreedhar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help in storing and retreving images
__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need help in stroing and retreving images from database
Sir , Iam working on Mysql5.0 version. Can I store .jpeg or .png or .gif etc imagefiles in database. If so where can I get the tutorials or sample code to insert and retrive the images from mysql database. Any help is welcome. Thanking you , Sreedhar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help
Isn't MySql supports large amounts of data to be stored in databases. What is the maximum number of records that can be handled or stored in Mysql. Is there any limit. If i want to store large amounts of data then is it necessary to migrate to another database. Please reveal this . Any help is welcome. Thanking you , Sreedjhar. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help in running MySql in PHP script
Hi, Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT and IE as web browser and executed the php script,but got a fatal error describing that undefined fuction mysql_connect() in the file and not getting the desired output. I had uncommented the php.ini file the entry named 'extension=php_mysql.dll' and also set the path for PHPRC = c:\php , also the PATH variable to c:\php;. But still Iam not getting the desired output in browser. Kindly tell me where iam going wrong. Any sort of help is welcome. thanks, Sreedhar. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help in running MySqli (extension) in PHP script
hi, I use php 5.0,Mysql 5.04 ,IIS 5.0 ,IE in windows2000 NT os and still got errors in running php script with Mysqli functions. when I execute the Php script with Mysql functions in it, it gives fatal error undefined function Mysqli_connect() on line no etc.,, in browser. IS that correct, can I use Mysqli functions in this because I am using Mysql 5.04 (beta) version in PHP documentation it was told that those who are using Mysql 4.0 or higher can use Mysqli in php scripts. if so how i can install Mysqli ( Extension MYSQL) in PHP. I doesn't understand the command use --with-mysqli= mysql_config_path/mysql_config configuration option where mysql_config_path represents the location of the mysql_config program that comes with MySQL versions greater than 4.1. where should I type this command in order to install the mysqli extension so that I can use the Mysql 5.0 version in php script. Any help is welcome. Thanks SReedhar __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help in locating configuration file
Hi, Iam using Mysql5.04 What does it mean, To install the mysqli extension for PHP, use the --with-mysqli=mysql_config_path/mysql_config configuration option where mysql_config_path represents the location of the mysql_config program that comes with MySQL versions greater than 4.1. in this,is mysql_config file is same as my.ini and the path to it in windows 2000 NT (on my system is )c:\Program Files\mysql\mysql server 5.0 ; is it correct, then after editing the php.ini file why doesnot it is working. Any help is welcome. Thanks Sreedhar __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help in running MySql in PHP script
Hi, Iam using mysql 5.04 , php 5.0 with IIS 5.0 webserver and written some scripts and executed on IE webbrowser but getting an fatal error undefined function mysql_connect() in the code kindly tell me where iam going wrong and also tell the mysql username how to find it out becoz when Iam opening the Mysql from start button it only asks the password and doesnot prompt for an username tell the porcedure to create a new user an tell me how to identify the current user in Mysql. Is there any special code to be written in .ini file of php to link Mysql with php to run the Mysql code in php scripts,if so please tell the code required in detail. Any sort of help is welcome. Thanks Sreedhar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NEED HELP IN IF STATEMENT
Can u please execute the following procedure in MySql and tell me where I had gone wrong because on my system the same code is giving error near line := 'TRUE' CREATE PROCEDURE cart_items_validate (IN mcustid INT ,IN mprodid varchar(10), OUT mvalidate varchar(10)) BEGIN DECLARE rowexists INT(6); select count(*) into rowexists from esr_cartitems_data where customer_id=mcustid and item_id=mprodid; if rowexists0 THEN mvalidate := 'TRUE' else mvalidate := 'FALSE'; end if; END; Any help is welcome . Thanks, Sreedhar. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need hlep for creating a Package in MySql 5.0.4 beta nt
Is there any statement in MySql 5.0 to create a package of my own i,e create package Pack_name ( ) etc., if so please give the syntax of that or what to do if I want to create a package of my own in mysql 5.0 . Any help is welcome. Thanks , Sreedhar __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need help in syntax for create package or compile etc
Is there any statement named create and complie java source named .. syntax in the mysql for creation of a java source file for loading data from java files or retriving data etc . Any help is welcome . __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help with stored procedures in mysql
__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Need help with stored procedures in MySQL
Hi, Iam looking to migrate an Oracle database to MySQL and trying to write a simple stored procedure in MySQL 4.1 .I reffered few examples posted and used the statements from them but I get errors while creating procedures create procedure helloworld (out p_text VARCHAR(30)) BEGIN set p_text = HELLO WORLD ; END // After pressin enter key an error message is displayed ERROR 1064(42000): you have an erro in your SQL syntax; check the manual that corresponds to your mysql server version for the right syntax t ouse near 'procedure HElloWorld ( OUT p_text = 'HELLO World' ' at line 1 Any help would be appreciated . Thanks, Sreedhar. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to Deploy MySQl with VB
Hai .. Iam Sreedhar , If iam not wasting ur time - please help me out. Prob: Is it neccessary to instal MYSQL Software in clients place to do transactions with database. for example: If an an application is developed using MS-Access and VB then we have to add .MDB file in PD . There is no need to Install MS-Access. My Question is , What are the files we have to add (MYSQL files) at the time of Package and Deployment? Waiting for ur reply Sreedhar Love, Sreedhar Reddy .D - Do you Yahoo!? Free Pop-Up Blocker - Get it now
How can i acheive 'Triggers' in MySQL
Hi all, How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. Regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I connect and run PHP program through crond service.
Hi all, I am doing a small testing project on Library. I wrote a PHP program to list out the people and their mailid's who took book and had not returned from MySQL database. Using the mail command i could able to send remainder's to them. But now i would like to make this as auto mail. so my PHP program should connect to crontab page. How can I connect and run PHP program through crond service. Thanks in advance and happy valentien's day. Regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSTALLATION and CONNECTION problem
Hi All, To Update current version on my new Redhat LINUX server I uninstalled MySQL 3.23.26 rpm and installed all MySQL3.23.47 rpms. When I tried to connect through shell mysql -u root mysql Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). Please let me what's the problem how can i slove it. Thanks in advance. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: INSTALLATION and CONNECTION problem
Hi all, I solved my problem. Problem because another old mysql service running on the same port. regards, sreedhar - Original Message - From: sreedhar [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 6:33 PM Subject: INSTALLATION and CONNECTION problem Hi All, To Update current version on my new Redhat LINUX server I uninstalled MySQL 3.23.26 rpm and installed all MySQL3.23.47 rpms. When I tried to connect through shell mysql -u root mysql Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). Please let me what's the problem how can i slove it. Thanks in advance. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is MySQL-MAX.
Hi , I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1 If I would like to update to newer version I found the following What is MySQL-MAX. RedHat packages (rpm) MySQL 3.23.47 Server (i386) (1.4M) where as ordinary MySQL RedHat packages (rpm) MySQL 3.23.47 Server (i386) (6M) Is the sizes will be this much different. Which can better to download and use if I want transaction security to tables. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSTALLATION and CONNECTION problem
Hi All, To Update current version on my new Redhat LINUX server I uninstalled MySQL 3.23.26 rpm and installed all MySQL3.23.47 rpms. When I tried to connect through shell mysql -u root mysql Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2). Please let me what's the problem how can i slove it. Thanks in advance. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is MySQL-MAX.
Hi , I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1 If I would like to update to newer version I found the following What is MySQL-MAX. RedHat packages (rpm) MySQL 3.23.47 Server (i386) (1.4M) where as ordinary MySQL RedHat packages (rpm) MySQL 3.23.47 Server (i386) (6M) Is the sizes will be this much different. Which can better to download and use if I want transaction security to tables. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can I create InnoDB table
Hi All, How can I create InnoDB table. If I tried create a InnoDB Table on my RedHat Linux MySQL 3.23.26 . Can any body give details that how can I create InnoDB table. Thanks in advance, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'Automating Mailing Facility'
Hi All, Is there any possiblity 'Automating Mailing Facility' like in MS-SQL in MySQL. If not, which mid range database is suitable for me for my project. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I establish a ADO Connection to work with PHP and MySQL on Linux
Hi all, My Database on Linix. Can I establish a ADO Connection to work with PHP and MySQL on Linux. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is Triggers Possible in MySQL
Hi All Is Triggers Possible in MySQL. If Yes, It is like in other RDBMS. regards, SREEDHAR - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
equivalents to ROLES in SQL-Server in MySQL.
Dear all, Is there any equivalents to ROLES in SQL-Server in MySQL. regards, Sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can i autostart MYSQL
hi all, How can i autostart MYSQL while starting of my LINUX server. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can i RollBack or Commit using PHP in MYSQL
Hi all, How can i RollBack or Commit using PHP in MYSQL. i have not found any commands through PHP Doc. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
commit and rollback commands through php
How can i say commit or rollback using php. i didnot find any commands for commit or rollback for mysql in php. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NOT NULL field accepting NULL
Hi All, In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What might be the problem. please let me know. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: NOT NULL field accepting NULL
Hello,
CREATE TABLE tblTEST(field1 VARCHAR(20) NOT NULL, field2 VARCHAR(20) NOT
NULL);
INSERT INTO tblTEST (field1) VALUES (NULL);
INSERT INTO tblTEST (field2) VALUES (NULL);
INSERT INTO tblTEST (field1,field2) VALUES (NULL,'HELLO');
not accepting NULL values; but
INSERT INTO tblTEST (field1) VALUES ('HELLO');
This statement inserting empty value in 'field2'.
field1 field2
HELLO
so how can we make INSERT statement to fail if value of NOT NULL field is
not supplied.
thanks
regards,
sreedhar
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: sreedhar [EMAIL PROTECTED]; mysql [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 11:25 PM
Subject: Re: NOT NULL field accepting NULL
At 7:12 PM +0530 12/12/01, sreedhar wrote:
Hi All,
In MySQL, Even i declared a field as NOT NULL it is accepting nulls .What
might be the
problem. please let me know.
regards,
sreedhar
That's not enough information.
Let's see the CREATE TABLE statement, a sample INSERT statement, and
the resulting record.
-
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
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump is not generating references
hi all, mysqldump is not generating references. how can i get it. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is type casting available
hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. thanks in advance. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is type casting available
hi Benjamin, thanks, here shortname is varchar and pcallid is integer. i need shortname and pcallid as ' callno' of length 6. pcallid starts from 1 .. 999. to get effect like for callnumber 'xxx001' i plan to add pcallid by 1000 and pick last 3 characters and concat with shortname. simply concat(ShortName , substring(Cast( (.PCallID + 1000) as varchar(10) ),2 3) ) as 'Call No' here i would like to cast (.PCallID + 1000) as varchar thanks, regards, sreedhar - Original Message - From: Benjamin Pflugmann [EMAIL PROTECTED] To: sreedhar [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Monday, December 10, 2001 5:32 PM Subject: Re: is type casting available Hi. On Mon, Dec 10, 2001 at 05:13:21PM +0530, [EMAIL PROTECTED] wrote: hi all, how can i cast a variable either from integer to varchar or varchar to integer in mysql. That's not possible in the way you ask for. Values will get automatically converted to the column type in question. In expressions, MySQL doesn't use varchar, but simply string, integer and floating point. You can force a string to an integer by adding 0 (like 'SELECT 1234+0') and an number to a string by some string functions (like 'SELECT CONCAT(10)'). I assume, there are no explicit casts, because if you want to add some number, you get the conversion implicitly by using '+'. If you could provide an example why you need explicit casts, maybe we could give a more precise answer. Bye, Benjamin. -- [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timely backup
hi Thomas, Thanks for advice. My database is on LINUX. Can give bit details of cron. Even link regarding that also sufficient. thanks in advance. regards, sreedhar - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: sreedhar [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 6:20 PM Subject: Re: timely backup On Thu, 29 Nov 2001, sreedhar wrote: Can you tell how can i do my database backup timely i mean in regular intervals with out explicitly doing by us. Sreedhar, It depends. You have not been extremely verbose describing your actual requirements or your system, but you might look into - a cron job doing the backup by starting a script regularly - replication Thomas - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
timely backup
Hi, Can you tell how can i do my database backup timely i mean in regular intervals with out explicitly doing by us. thanks in advance, regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlgui
hi glenn, try to connect from another system on network. because it is client software. if i am connecting from another system on network it is connecting. urs, sreedhar - Original Message - From: Glenn English [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 3:58 AM Subject: mysqlgui RH7.2 When I run 1.7.5 either static or semi static, I get Can't connect to local MySQL server through socket (111) Host name is localhost (120.0.0.1 doesn't work either). I do have access rights - running as root. -- Glenn English [EMAIL PROTECTED] - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL to MS' Access '97
¿ÿ^:ô[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Can I Set CurrentDate As Default Date
hello, I got problem when I tried to have CURRENTDATE as DEFAULT date. For this I gave sql statement as CREATE TABLE XX(..,fldDate DATETIME DEFAULT NOW() NOT NULL, ..); NOW() CURDATE() both will give Current date. But I am getting syntax error. If i give some Date like 10/31/2001 it is taking as default. thanks in advance for any advice. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Can I Port Database From SQLSERVER To MySQL
Hello, How can i port database from SQLSERVER to MySQL. I tried using DTS of SQLSERVER but it is failing to port data. thanks in advance for any advice. regards, sreedhar - 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
