Re: Hello how to connect MySQL with Visual Foxpro

Hi Venu, I would like to know the OS your using (for mysql server), BTW if your using window. Try installing the myodbc and configure it so that vfoxpro can communicate with it. check this site: http://fox.wikis.com/wc.dll?Wiki~VFPCommandSQLStringConnect~VFP At 06:28 PM 5/22/2006, VenuGop

Re: adding columns to a large table

At 12:53 PM 9/25/2006, Helen M Hudson wrote: I have a table with about 3million rows and I'm having trouble altering it to add 4 more columns. I'm using the MySQL Administrator and I've left it more than 24hours and its still not finished. I was going to try using a login to the console next,

Re: mysql command line execution

Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser mypasswd=dbpassword mydb=dbname myhost=localhost myport=3306 db1=mysql -u$myuser -pmypasswd -Dmydb -h

Re: mysql command line execution

At 09:49 PM 7/29/2005, Nuno Pereira wrote: Michael Stassen wrote: Ehrwin Mina wrote: Jeff, You can make a shell script or a php script or a perl script by that way you can hide the commands you need to execute. eg. Make a shell script (myshell.sh) #!/bin/sh myuser=dbuser mypasswd

re: ADDING MYSQL DATABASE

HI, If you want i can send you the help file so you dont need to browse anytime you need a command in mysql. Thank you, ehrwin At 03:13 PM 8/22/2005, Gu Lei wrote: Hi That's a problem about privileges. Try mysql -uroot. Please have a look at http://dev.mysql.com/doc/mysql/en/privilege-sy

Re: Tracking changes in the database

You can also set a plain logging of mysql activity by enabling this in my.cnf log= /tmp/mysqld.log tmpdir = /tmp/ restart mysql Thanks, At 02:32 PM 10/13/2005, Daniel Kasak wrote: Andre Matos wrote: I am using InnoDB and replication, is there any issues? Thanks. Andr

Re: timestamp

Ryan, Try to use this date functions. * DATE_ADD(date,INTERVAL expr type) , DATE_SUB(date,INTERVAL expr type) These functions perform date arithmetic. date is a DATETIME or DATE value specifying the starting date. expr is an expression specifying the interval value to be added or subtracte

Re: ~BCP for mysql~

Hi, You can try to use the command select into outfile. thanks, ehrwin At 03:29 PM 3/22/2006, Mohammed Abdul Azeem wrote: Hi, Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not, is there any other tool which can do the same operation. I need to perform a "bcp out" from

Re: Password for Root

sqld That's it. Jett Tayer and Ehrwin Mina Jett Tayer and Ehrwin Mina

Re: How to import data from Dbase3?

BG Mahesh wrote: hi How do I import data from Dbase3 into MySQL? -- B.G. Mahesh [EMAIL PROTECTED] http://www.indiainfo.com/ BG, There are tools you can use to migrate it to mysql, i use it before that i get it in the forum. You can search some forum indicating the migration tools for DB3, Foxp

Re: How to import data from Dbase3?

- From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Ehrwin Mina" <[EMAIL PROTECTED]> Subject: Re: How to import data from Dbase3? Date: Wed, 23 Mar 2005 02:21:48 -0600 Ehrin, If you have dBase III or later, Clipper or FoxPro, you can export the data comma-separat

Re: cannot connect to the mysql server.thank you.

çéè wrote: dear sir, nice to meet you. now i have installed the MySQL-Server&Client(4[1].0.15).but i cannot connect mysql server when i make a change. what is the wrong with what i do?l can i get your help? thank you very much. In what platform did you install it? thanks, Ehrwin

Re: Error 1045

hi jernej, using this command is normal: mysql -h localhost -u jk -p ENTER but you have to check the grants/permission you set to a particular database name, username with its password. use the manual for more info regarding grants. thanks, Ehrwin Miña Senior System Administrator NOC Chikka A