load data infile question

I want to transfer data from a table in sql server to mysql. I use C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to write the data to a text file and then use load data infile ‘/var/www/html/tblname.txt' into table tblname; It works fine for all the tabl

BCP

I am using C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa –P sapwd -c -t \t -r \n to create a text file from a sqlserver table . Th text file shows a tab after every field except the last field. How can i get it to put a tab even after the last field. Help is appreciated, re

cron job help running mysql/php script

I wrote my first cron job to run a php script once every minute. The command i wrote is as follows: * * * * * * lynx http://domain ip address/scripts/crontest.php It doesnt seem to work as i tell it to populate the log table in the database. It runs fine when run through the browser. Where am i

Re: cron job help running mysql/php script

crontest.php file and the mycron.txt file under/home/harpreet folder. Thanks, Regards, Harpreet Kaur >From: "Steven Deaton" <[EMAIL PROTECTED]> >To: "Harpreet Kaur" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, ><[EMAIL PROTECTED]> >Subjec

mysqldump

cal mysql server through socket 'var/lib/mysql/mysql.soc (2) What is wrong. Please help. Regards, Harpreet kaur _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hot

Re: mysqldump

The mysql is working now and i can get into it. But when i type mysql databasename < /home/backup/backup_databasename.sql To restore a database do i need to have the database created first. i get an error message error 1044: access denied for user @localhost to database databasename If i log o

Re: mysqldump

Dont worry. It worked. Yes i was supposed to create the database before using the restore command as it couldnt find the database. Thanks neways, Regards, Harpreet kaur >From: "Harpreet Kaur" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: mysqldump >Dat

Default current date

How can i set the default values of a datetime field in a mysql table as the current date. I am trying alter table copy_tbl add create_date datetime default now() but it does not work. Please help. Regards, Harpreet Kaur _ MSN

Re: [PHP-DB] Re: subtracting one query from the other

. The time it takes is 18 seconds. My boss wants it to run in 4-5 seconds. If the number of records r more like 4-5000 then it takes even longer. How can i reduce the time even further. Can i index the tables or nething will that help. Help is greatly appreciated. Thanks, Regards Harpreet Kaur

Re: [PHP-DB] Re: subtracting one query from the other

a and b r not tables but views. i am using multiple views . The sql for the views are as follows: CREATE view cch_dubber_dublist_view_a1 as select distinct a.playlist,a.material_id,a.destination_locator,a.destination,a.air_time,a.traffic_duration,a.comment,a.title,a.device_name,m.media_locator

using a php page to reboot linux

Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur