RE: [PHP-WIN] Transfering database

2004-05-26 Thread George Pitcher
Sudeep, This is a php list, you are asking a MySQL question with no relevance to php. Check the MySQL manual for Load Infile commands. I have to admit I can never get them to work on my versions of MySQL and have tended to use other methods to load tables. As I said before, with MySQLFront, you

RE: [PHP-WIN] Transfering database

2004-05-26 Thread Svensson, B.A.T. (HKG)
Well, if you could be so kind to 1) tell what kind of RDBMS you want to load the data in, and 2) in wich format the data is in the file (a file extension is not sufficient to tell this), then actually somebody might be able to give you a proper answer as well. If the answer on 1) is MS SQL, and

Re: [PHP-WIN] Transfering database

2004-05-26 Thread Jeroen Serpieters
On Wed, 26 May 2004, Sudeep Zamudra wrote: > > I have dumped my entire database into files with extension '.sql' (separate file for > each table). Now please tell me any function or statements if any to tranfer the > contents of the file(i.e table structure and table contents) into a new databas

[PHP-WIN] Transfering database

2004-05-26 Thread Sudeep Zamudra
Hi everyone, I have dumped my entire database into files with extension '.sql' (separate file for each table). Now please tell me any function or statements if any to tranfer the contents of the file(i.e table structure and table contents) into a new database which is on another database serve

Re: [PHP-WIN] Re: Hello and first question

2004-05-26 Thread Ross Honniball
My preference is to use $_REQUEST over $_POST and $_GET. Also, if you are really keen on short variable names, you can use the function: extract($_REQUEST); and it will create short variable names. You might want to look this up in the manual for more details (to do with name collisions etc.) R

[PHP-WIN] Re: Hello and first question

2004-05-26 Thread Justin Patrin
Chris Patrick Carias Stas wrote: I have problems running php scripts under w2k. for example, a form to send a mail. I has 3 fields, name, email and msg. The actions goes through POST to a file send.php. In send.php i try to use the variables $name, $email and $msg, but it says they are not decla

[PHP-WIN] Hello and first question

2004-05-26 Thread Chris Patrick Carias Stas
I have problems running php scripts under w2k. for example, a form to send a mail. I has 3 fields, name, email and msg. The actions goes through POST to a file send.php. In send.php i try to use the variables $name, $email and $msg, but it says they are not declared. The same script works fine u

RE: [PHP-WIN] Output Control

2004-05-26 Thread William CANDILLON
I just want to see the numbers before 10 seconds in my browser like in shell mod. -Message d'origine- De : Luis Moreira [mailto:[EMAIL PROTECTED] Envoyé : mercredi 26 mai 2004 17:21 À : William CANDILLON; [EMAIL PROTECTED] Objet : Re: [PHP-WIN] Output Control William CANDILLON wrote: >I

RE: [PHP-WIN] Output Control

2004-05-26 Thread William CANDILLON
I just want to see the numbers before 10 seconds -Message d'origine- De : Luis Moreira [mailto:[EMAIL PROTECTED] Envoyé : mercredi 26 mai 2004 17:21 À : William CANDILLON; [EMAIL PROTECTED] Objet : Re: [PHP-WIN] Output Control William CANDILLON wrote: >I want to execute my script in a b

Re: [PHP-WIN] Output Control

2004-05-26 Thread Luis Moreira
William CANDILLON wrote: I want to execute my script in a browser as with the shell mode. Example: static $i = 0; while ($i < 10) { ++$i; echo "$i\n\n"; sleep(1); } ?> I've tried this but it's doesn't work : static $i = 0; while ($i < 10) { ++$i; echo "$i\n\n"; flush(); sleep(1); } ?> What exa

[PHP-WIN] Output Control

2004-05-26 Thread William CANDILLON
I want to execute my script in a browser as with the shell mode. Example: I've tried this but it's doesn't work : -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-WIN] mysql rollback

2004-05-26 Thread Sudeep Zamudra
Could u just give me what should be the statement to rollback a database for eg "abc" [EMAIL PROTECTED] wrote:what verion of mysql do you have? Early version of MySQL didn't include the rollback functionality. Do you not have any mysql_dumps of the databases and/or tables? (Its vital that you ba

Re: [PHP-WIN] mysql rollback

2004-05-26 Thread Svensson, B.A.T. (HKG)
How did you lose them? I don't know about mySQL, but in general DELETE, INSERT and UPDATE are logged while DROP and TRUNCATE are not. If you do /not/ use auto commit /and/ did /not/ do commit, then you can use rollback to undo a delete/insert/update. Else you need to restore the database from t

[PHP-WIN] mysql rollback

2004-05-26 Thread Sudeep Zamudra
Help please, i lost all of my database tables all of a sudden. It was in for example a database called "abc". Can i retrieve the entile table and it's comtents by any means. Thru any Rollback statement. Help please - Do you Yahoo!? Friends.

Re: [PHP-WIN] database migration... URGENT

2004-05-26 Thread Xavier Serna
I believe that you can do this with DBManager Professional Freeware Edition, from DBtools software. (Win appz) hope this helps, Xavier - Original Message - From: "Sudeep Zamudra" <[EMAIL PROTECTED]> To: "php mailinglist" <[EMAIL PROTECTED]> Sent: Wednesday, May 26, 2004 12:34 Subject: [P

[PHP-WIN] database migration... URGENT

2004-05-26 Thread Sudeep Zamudra
Hi evryone, I need help...I have mysql database dump files that need to be dumped into a new database server. There... i dont find any application such as phpmyadmin OR mysqlAdmin and that makes my job difficult. So please tell me how to migrate my current database to the new one. Any s

[PHP-WIN] database migration... URGENT

2004-05-26 Thread Sudeep Zamudra
Hi evryone, I need help...I have mysql database dump files that need to be dumped into a new database server. There... i dont find any application such as phpmyadmin OR mysqlAdmin and that makes my job difficult. So please tell me how to migrate my current database to the new one. Any s

[PHP-WIN] databse migration... URGENT

2004-05-26 Thread Sudeep Zamudra
Hi evryone, I need help...I have mysql database dump files that need to be dumped into a new database server. There... i dont find any application such as phpmyadmin OR mysqlAdmin and that makes my job difficult. So please tell me how to migrate my current database to the new one. Any s

Re: [PHP-WIN] MS SQL Query question

2004-05-26 Thread Jordi Canals
Dr. Robert Probst wrote: IN MY (not MS) SQL I would try mysql_data_seek ($result, 0); to move the internal pointer to the first data row I dont know at the moment if there is a similar function in the ms area. maybe it helps For MS-SQL, you mean mssql_data_seek($result, 0) ;) http://es2.php.

Re: AW: [PHP-WIN] MS SQL Query question

2004-05-26 Thread Svensson, B.A.T. (HKG)
http://nl3.php.net/manual/en/function.mssql-data-seek.php On Tue, 2004-05-25 at 12:52, Dr. Robert Probst wrote: > IN MY (not MS) SQL I would try > > mysql_data_seek ($result, 0); > > to move the internal pointer to the first data row > I dont know at the moment if there is a similar function