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

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,

Re: Password for Root

. * # killall mysqld * Verify that MySQL daemon is not running * # ps -jef | grep mysqld * Start MySQL the normal way, and all is good. For Red Hat this is: * # service mysqld start * Verify if MySQL daemon is running * # ps -jef | grep mysqld That's it. Jett Tayer and Ehrwin Mina

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

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.

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

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

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

wrote: dear sir, nice to meet you. now i have installed the MySQL-ServerClient(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 Mina

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-separated, then use a free csv-to-mysql utility eg

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,

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