Mysql and php Installation for Linux.

. Please let me know how to install Mysql and PHP machine. Please advice the necessary steps for the installation. With Warm Regards Harpreet Singh Chana Phone : @ 4326 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

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

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

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

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

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

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: cron job help running mysql/php script

browser. But nothing is happening no matter what i cange in mycron.txt file. Help is appreciated . please refer me to a tutorial where i can start form scratch as this is my first cron job. my mycron.txt file has the following one single line. * * * * * /home/harpreet/crontest.php I have the

cron job help running mysql/php script

i going wrong? I saved the above line in a text file and put in my home directory. Please help. Regards, Harpreet mysql cron help _ Send and receive Hotmail on your mobile device: http://mobile.msn.com

BCP

ted, regards, Harpreet _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.

load data infile question

all the tables except this one table which has description field with several lines. It assumes each line as a seperate field rather then one field and so create errors. Please help. Regards Harpreet _ Get your FREE download of MSN Exp

MYSQL query help

I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id <>'' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Softwar

working with views

where dev_device_view and cch_playlist_views are sql statements joining 2 tables using an inner join. Help is appreciated, regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Before posting, please check

RE: Permission problem

ant insert,update, delete,create,drop, reload, shutdown,process, file,alter on *.* to 'root'@'localhost' with grant option Help is greatly appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -----Original Message- From: Harpreet [mailto:[E

Permission problem

. And when i type in mysql> select * from user; i get error message: Select command denied to user 'root@localhost' for table 'user' Where did i go wrong .. please help... i get the same error message when i try to use ne other database even the one i created just now.

RE: Alternative for UNION

I am using version 3.23 and dont think will be moving up to 4.0. Can i somehow create a temporary table and add all the rows i need and do a select query from that temp table. Neone done this before. Thanks for ur responses and time, Regards, Harpreet Kaur Software Developer Crispin

Alternative for UNION in MYSQL

lib_asset_tbl b on a.parent_id=b.asset_id union select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N' Help is appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Be

Alternative for UNION

lib_asset_tbl b on a.parent_id=b.asset_id union select asset_id,material_id,'' from lib_asset_tbl where virtual_flag='N' Help is appreciated, Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Be

RE: concatenating fields

column, code_id as submit_column from sys_code_tbl order by category"; echo ""; $result = mysql_query($ssql); while ($row = mysql_fetch_array($result)) { echo "'".$row["fill_column"]."'"; } Help is appreci

RE: My attitude (Was:Migration to mysql from MS SQL Server)

for making it clear. I am still glad I joined the group as Will's post did help a lot. Neways cheer up everybody and yes i do agree 'be nice to people' - it will not only help others but ur own self. Regards, Harpreet Kaur Software Developer Crispin Corporat

RE: Migration to mysql from MS SQL Server

Can we create a php page that will use mssql_connect to connect to ms sql server get the data and then use mysql_connect and connect to mysql server and populate the table. Is this possible. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From

Error message

p. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

RE:Permission problem

browser but cannot transfer any new files. I am sure i am missing somewhere here also. Help is greatly appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From: Deepanshu Shukla [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 1

FW: Permission problem

very new to mysql and linux and am still testing different things. And thanks for ur help. regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -Original Message- From: Dan Liu [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 11:33 AM To: [EMAIL PROTECTED] Subjec

Permission problem

the files but i cant move the files to it. It can be done from the linux server but i cant do them myself from my computer. What am i missing?? like i can got from /var/www/ and then when i click on html folder it gives me error message permisiion denied. Help will be apppreciated, Regards, Harpreet

Host 'ip adddress'' is not allowed to connect to this MySQL server

SQL server please help and let me know what am i missing. An early response will be appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Before posting, please check: http://www.mysql.com/manual.