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
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
. 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
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
server through socket 'var/lib/mysql/mysql.soc
(2)
What is wrong. Please help.
Regards,
Harpreet kaur
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
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
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
Date: Tue, 23 Apr 2002 16:08:23 +
the 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]
Subject: Re: cron job help running mysql/php script
Date: Fri, 12 Apr 2002 14:06
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 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
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,
11 matches
Mail list logo
