Mysql and php Installation for Linux.
Hi, I am trying to install Mantis on Linux but I am totally new for linux as well as for Mantis. I have managed to install Linux. I was not sure which components are required for Mantis So I have selected all the components. Now my Linux is UP and need you help for the further installation. 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 PROTECTED]
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 _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 as source_locator,m.medium_name as source from cch_dubber_dublist_view11 a left outer join lib_copy_view m on a.material_id=m.material_id create view cch_dubber_dublist_view_b1 as select a.playlist,a.material_id,a.destination_locator,a.destination,a.air_time,a.traffic_duration,a.comment,a.title,a.device_name from cch_dubber_dublist_view11 a,dev_device_view d inner join lib_copy_view c on d.device_name= c.medium_name where c.material_id = a.material_id AND c.media_locator = a.destination_locator AND d.device_name = a.device_name CREATE view cch_dubber_dublist_view11 as select distinct a.playlist as playlist, a.material_id as material_id, a.media_locator as destination_locator, a.video_source as destination, a.traffic_duration as traffic_duration, a.comment as comment, a.title as title, b.device_name,a.traffic_start_time as air_time from dev_device_view b inner join cch_playlist_view a on b.source_name =a.video_source where (A.material_id is not null) and (A.material_id <>'') and (a.TRAFFIC_START_TIME IN(SELECT min(TRAFFIC_START_TIME) FROM CCH_PLAYLIST_TBL WHERE CCH_PLAYLIST_TBL.MATERIAL_ID =a.MATERIAL_ID)) union select distinct a.playlist as playlist, a.material_id as material_id, a.media_locator as destination_locator, a.backup_video_source as destination, a.traffic_duration as traffic_duration, a.comment as comment, a.title as title, b.device_name,a.traffic_start_time as air_time from dev_device_view b inner join cch_playlist_view a on b.source_name=a.backup_video_source where (A.material_id is not null) and (A.material_id <>'') and (a.TRAFFIC_START_TIME IN(SELECT min(TRAFFIC_START_TIME) FROM CCH_PLAYLIST_TBL WHERE CCH_PLAYLIST_TBL.MATERIAL_ID =a.MATERIAL_ID)) _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] Re: subtracting one query from the other
Dear Dan,
Thanks for your timely help. Yes, removing the concatenation has reduced the
running time nearly 10 times . So finally my sql looks like the below,
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,a.source_locator,a.source
from
cch_dubber_dublist_view_a1 a left outer join cch_dubber_dublist_view_b1 b ON
a.material_id = b.material_id AND
a.destination_locator = b.destination_locator AND
a.device_name = b.device_name
where b.material_id is null
The number of records returned is 3566. 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
>From: [EMAIL PROTECTED] (Dan Kokenge)
>To: [EMAIL PROTECTED] ("Harpreet Kaur")
>Subject: Re: [PHP-DB] Re: subtracting one query from the other
>Date: Tue, 02 Jul 2002 00:33:21 -0400
>
>
>Hi Harpreet
>
> >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,a.source_locator,a.source from record1 a left outer join
> >record2 b on
>
>>a.material_id+a.destination_locator+a.device_name=b.material_id+b.destination_locator+b.device_name
> >where b.material_id+b.destination_locator+b.device_name is null
> >
>
>Not sure why you concatenate the fields together. This will take some time
>to bring the fields together before the compare. Why not simply compare the
>separate fields. Also why do you compare all the fields for null. Seems
>like you only need to compare the material_id, that is of course you don't
>have a matching material_id that can be null - and I doubt that.
>
>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,
>a.source_locator,
>a.source
>
>FROM record1 a
>
>LEFT OUTER JOIN record2 b
>ON a.material_id = b.material_id
>AND a.destination_locator = b.destination_locator
>AND a.device_name = b.device_name
>
>WHERE b.material_id is NULL
>-
>if you need all three you can change the where to:
>WHERE b.material_id is NULL
>AND b.destination_locator is NULL
>AMD b.device_name is null
>
>Actually this is a fairly common type command and I use it a lot. I don't
>know anything about your files. You didn't mention how large the files
>were. If they are huge the time may be ok. If not you may want to see if
>it's it indexed properly. A index on material_id at a minimum. If this file
>is fairly static, with only a few inserts and deletes a minute, then I'd
>index the hell out of it, and put an index on all 3 fields. If it's a vary
>active file with lot of inserts and deletes, then you have to be careful on
>your index scheme. Also if one file is vary large and one very small, then
>it is much faster to read the smaller file id's into arrays, and then read
>the large file and see if it has a matching id in the array. I've been
>called in to consult on problems where I've had to do 6 or 7 joins against
>huge files that I've dropped run time from hours to less than 5 minutes
>doing the array thing.
>
>HTH.. Good luck..
>Dan
>
>
>__
>Your favorite stores, helpful shopping tools and great gift ideas.
>Experience the convenience of buying online with Shop@Netscape!
>http://shopnow.netscape.com/
>
>Get your own FREE, personal Netscape Mail account today at
>http://webmail.netscape.com/
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 >Date: Tue, 23 Apr 2002 16:08:23 + > >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 on as su root >i get error message >error 1049: unknown database databasename > >but i dont have the databas eyet . I want to create a new database. > >_ >Join the worlds largest e-mail service with MSN Hotmail. >http://www.hotmail.com > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 on as su root i get error message error 1049: unknown database databasename but i dont have the databas eyet . I want to create a new database. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump
Dear group members I did a mysqldump on my machine at home to backup a database. I saved the file to the /home/backup folder at my work and am trying to restore the database using mysql databasename < /home/backup/backup_databasename.sql I get the following error: Cannot connetc to local mysql 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: cron job help running mysql/php script
I am trying different options but everytime i make a change and type crontab mycron.txt in telnet it comes to the next promp without an error message. But it doesnot do what i want it to do. How can i even test if the cron tab is finding the file. Like the php file runs fine when run from a 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 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:56 -0700 > >You might try a lynx --dump ?? > >---Steven Deaton > >- Original Message - >From: Harpreet Kaur <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Friday, April 12, 2002 1:52 PM >Subject: 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 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 > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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, regards, Harpreet _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
working with views
The following worked in MSSQL as it could handle views. Now i want to run it in PHP with a mysql server. I was wondering if there is another alternative for the below then to use temporary tables. select * from dev_device_view b inner join cch_playlist_view a on b.source_name =a.video_source 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: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Permission problem
I typed show Grants for root@localhost; and saw that the root has all permissions other then select. I can delete , insert data into the tables of all the databases but cannot select. How can i give the root@localhost 'select' permissions. show grants for root@localhost displays: Grant 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:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:26 PM To: 'MySQL Mailing list' Subject: Permission problem I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every other database. After creating this new database now when i try to type in USE MYSQL, it changes to the mysql database . 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. 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 thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permission problem
I created a new database on mysql server using Telnet. Before creating it i could log onto telnet as su root and select,delete , insert data into the mysql database and every other database. After creating this new database now when i try to type in USE MYSQL, it changes to the mysql database . 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. 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 thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 Corporations Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams Sent: Wednesday, October 31, 2001 1:23 PM To: [EMAIL PROTECTED] Cc: 'Mysql' Subject: Re: Alternative for UNION Harpreet wrote: > I had a view on sqlserver which i am trying to convert to work with mysql. > It uses a union which i believe does not work with mysql. What is another > alternative for union. > > Sql with union: > > select a.asset_id,a.material_id,b.material_id as parent_material_id from > lib_asset_tbl a inner join 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' MySQL 4.0 supports unions. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alternative for UNION in MYSQL
I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alternative for UNION
I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: concatenating fields
I am using concat in my sql and it runs fine on mysql client. But when use
din php it gives me an error:
Supplied argument is not a valid MySQL result resource in
/var/www/html/scripts/cfg_code_delete.php on line <
$ssql="select concat(category, "-", code) as fill_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 appreciated.
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 thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: My attitude (Was:Migration to mysql from MS SQL Server)
I have participated on several groups before and this was the first time i received a comment like this. I didnt wanna bother replying to it as i know people r different and i am glad we have this delete button that i rely on in such cases :) Yes i was here for an advice and thank you Mr. Ravi 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 Corporations Inc. mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: Will French [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 10:00 PM To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] Subject: RE: Migration to mysql from MS SQL Server venu:> If you can make use of MS Access and ODBC in the middle layer in venu:> the conversion, venu:> from MSSQL-->MySQL, then probably you don't need any editing. venu:> Here is the simple venu:> procedure: Yes this is true and probably a superior method for small databases (say, less than 300Mb). But if your database is large (mine is > 6Gb , with a few tables > 1Gb), then the method you outline is excrutiatingly sslllooww. Also keep in mind that MS Access has a hard coded 2Gb limit on database size. Finally I would mention that the script editing chores were, for me, valuable in that they provided me with a chance to review my schema for opportunities to take advantage of some features in MySQL not available in MS SQL (date fieldtypes where MS has only datetime, enum and set types, etc). Will > -Original Message- > From: Venu [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 4:00 PM > To: [EMAIL PROTECTED]; Pavel Hant; [EMAIL PROTECTED] > Subject: RE: Migration to mysql from MS SQL Server > > > Hi !!! > > > -Original Message- > > From: Will French [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 03, 2001 12:28 PM > > To: Pavel Hant; [EMAIL PROTECTED] > > Subject: RE: Migration to mysql from MS SQL Server > > > > > > I just did this with a rather large database. Here are the steps that I > > followed: > > > > 1. In MSSQL Enterprise Manager, use "generate scripts" to, > well, generate > > your SQL scripts. (right click on any table and select All|Generate > > Scripts). I decided to break save the index builds until after > the data was > > loaded so I actually created two script files. > > > > 2. Edit the scripts. I used notepad and Excel to modify the > scripts for > > MySql compatibility. This mostly involved using the > ever-popular search and > > replace (e.g. eliminate all the [square] brackets that MS is so fond of, > > dumping the collation sequence stuff, converting my bit fields > to tinyint, > > etc). When the text massaging was more complex, I would cut > and paste it > > into Excel then used worksheet functions like Find() Mid() Left(), etc., > > then paste the section back into notepad. Because my schema is > not terribly > > exotic, I found the field type conversion to be pretty straightforward - > > your experience may be different. > > > > 3. Get the data out of MSSQL. Some people are fond of the > newer DTS (data > > transformation services) but us old timers still prefer BCP > (which, in case > > you don't know is a command line "bulk copy program"). I > created a batch > > file with one line for each table. If you are using trusted > security model, > > a single bcp command would look like this: > > C:\Data> BCP dbname.dbo.tblname out tblname.txt -S > srvrname -T -c -t > > \t -r \n > > If you are using Sql Server authentication, then it would look > like this: > > C:\Data> BCP dbname.dbo.tblname out tblname.txt -S > srvrname -U sa -P > > sapwd -c -t \t -r \n > > The command line options "-c -t \t -r \n" tell it to convert fields to > > character data, terminate fields with a tab character (hex 09) > and terminate > > lines with a carriage-return/linefeed pair (hex 0D 0A). The > line (or row) > > terminator is decieving 'cause it looks like I just asked for a > linefeed but > > it gives you both anyway. > > > > 4. Run your create table script in mysql (i use "\. > scriptname.sql" from > > the mysql prompt. > > > > 5. Load the data into mysql. This one's easy: > > > > mysql > use dbname; > > > > mysql > load data infile 'c:\\data\\tblname.txt' > > > into table tblname > > > lines terminated by '\r\n'; > > > > 6. Assuming you didn't already build your indexes in step 4, > run the script > > to build them now. > > > > > > There are probably a million different ways to do this. This > is the way I > > did it and it worked well for me. Since
Error message
Dear list members, This is the first time i am trying to connect to my database on mysql using php. The code is : Error message: Warning: MySQL Connection Failed: Access denied for user: 'testing@localhost' (Using password: YES) in /var/www/html/contact.php on line 8 Please help. 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 thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE:Permission problem
Awesome!!! Thanks u so much Deepanshu. Yes we changed it to 755 and we can see all the pages in the browser and also in the ftp software. But i still cannot transfer files from my computer to the web directory. I can overwrite the existing pages like index.html and can see the changes in the web 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:26 PM To: [EMAIL PROTECTED] Subject: Re: FW: Permission problem --- Harpreet <[EMAIL PROTECTED]> wrote: > Also earlier i could view the default index.html > page through the web now i > get the error messgae Forbidden > You don't have permission to access / on this > server. try changing executable permission to ur web directory to 755 and same to all the files insideincluding ur home directory(!this part is imp). = Deepanshu [ KReSIT ] IIT-B [EMAIL PROTECTED] __ Do You Yahoo!? Listen to your Yahoo! Mail messages from any phone. http://phone.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Permission problem
Can the administrator grant me rights to transfer files to a specific folder and if yes how do i do it? Also earlier i could view the default index.html page through the web now i get the error messgae Forbidden You don't have permission to access / on this server. What am i missing. I am 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] Subject: Re: Permission problem I got similiar problem before.The reason that I got "permission denied" is I did not have the right to transfer file to a specific folder. >>> "Harpreet" <[EMAIL PROTECTED]> 10/01/01 10:29AM >>> Hello list members, I am running mysql on a linux server. I can connect to it using telnet and also using mysql client. I am given all the permissions. I am trying to create a few php pages and want to ftp them to the linux server . I am using WS_FTP. i can view the folder where i need to put 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 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 thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Permission problem
Hello list members, I am running mysql on a linux server. I can connect to it using telnet and also using mysql client. I am given all the permissions. I am trying to create a few php pages and want to ftp them to the linux server . I am using WS_FTP. i can view the folder where i need to put 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 Kaur Software Developer Crispin Corporations Inc. -Original Message- From: Andreas Schmidt [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 10:53 AM To: [EMAIL PROTECTED] Subject: MS-Access Hi List I want to migrate from a NT-Server to a Linux Server. Therefore I'm looking for a solution to run my existing MS-Access-Databases under MySQL. Is there a chance to point from a MySQL-DB to a MS-Access-DB in order that my data can stay within the MS-Access-DB? Andi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Host 'ip adddress'' is not allowed to connect to this MySQL server
I am trying to use MYSQL CLIENT for the first time. I have setup the mysql server and connect to it from my machine using Telnet. But everytime i try to connect using mysql client or through access 2000 i get the following error: Host 'ip address' is not allowed to connect to this MySQL 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.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
