RE: off-line development tool?
If I rember well MySQLdump is a utility. I can run that at my local machine, but how to do the reverse thing at the remote machine. I can't run much more than HTML and PHP scripts there. Is there a tool that can convert the MySQLdump export file into something that looks like a PHP script and that I could unleash a CREATE command on? Thanks, Marco From: Eric Mayers [EMAIL PROTECTED] To: Marco Bleeker [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: off-line development tool? Date: Fri, 22 Feb 2002 18:27:23 -0800 I suggest you install a MySQL Database on a local machine and do development there. When you want to push this stuff to the remote machine use mysqldump to pull the contents out of the local database. I don't think it would be appropriate for this but you might consider database replication if you want it to be a more automatic process. Eric Mayers Software Engineer I Captus Networks -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 5:59 PM To: [EMAIL PROTECTED] Subject: off-line development tool? Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/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 Marco Bleeker, Amsterdam _ Download MSN Explorer gratis van http://explorer.msn.nl/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
off-line development tool?
Hello, I am a beginning MySQL and PHP user. I will run a MySQL database on a remote hosting server, and I have only limited access to the database at that server. I want to populate my database off-line at my home machine, and then upload the whole thing (100s of lengthy entries) to the server. But I don't have direct access there. So I suppose I'll have to do something like exporting my data to a text file, upload the text file to the root of my domain at the server and re-create the database from there. I don't think I can run any tool on the server; I work with .php files there. So my question is: how would people normally go about this task. Would I need to write a script for in- and export of data, or would there perhaps be a handy tool that takes this out of my hands? Thanks, Marco Bleeker, Amsterdam _ MSN Foto's is de eenvoudigste manier om je foto's te delen en af te drukken: http://photos.msn.nl/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
Telnet
I need to Telnet into my domain in order to run some MySQL utility like mysqldump (for backup). I am not experienced with Telnet. Any pointers? Any way around it (use mysqldump from PHP?) Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | www.EcoCam.com - Nature Images Online | | Uninvited attachments are not downloaded | Keep your system clean - please - thanks | | __@ | _`\,_ |__(*)/ (*)_Ah, op DIE fiets ! - 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
delay times, threads
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and will the server always present the user with the latest database update (after a possible delay)? Suppose a user can add a new row to a database in a PHP page with a form, and after submit, the next page he will see is a page displaying part of the same database, hopefully with his new row on top. Questions: A) will he always see the new data which he entered just a second before? B) How much delay could there be. In other words, how multi-tasking is PHP; will it run the next script line, even when a previous line (a MySQL query) has not been completed yet? And will MySQL execute a next (non-update) query, when the precious one is not done yet? I think that last question has the beginnings of an answer in it... :-) Thanks a lot; this is a great mailing list! (please email me directly, I am not signed up) Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
databases disappear...
[No David, the result set that suddenly goes to 0 is, or should not be empty, it is the result of a SELECT with no WHERE - and there were no deletes yet] For the first time developing a PHP-MySQL system, I am experiencing strange things. Perhaps it is the off-line mode (Localhost) I am running Apache in, or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a database with a standard little PHP script. Then I start working on my other PHP scripts and testing them out. Of course there are mistakes, like forgotten semicolons or a left bracket where it should be a right one (parse errors), and I correct them, untill I get a nice output on my screen. But suddenly - Offset 0 is not valid for this result set. This is a mysql_data_seek() error, but that is probably a coincidence. The point is: MySQL suddenly thinks that the database is empty, as if it was destroyed. When I look in my MYSQL directory tree, I find my database in the \data subdirectory. So it is present (3 files for each table). When I look at the date stamps for the files, all maintain their creation date/time, although I did make changes to the tables during testing - except one table, with just one row in it (my user/password), did change the timestamp, but I did not access that one (it does not work under Windows)! It get weirder. I must physically delete the database from the MySQL data directory, before I can create them anew, with the same little script I mentioned above. Usually I can access the tabels again then, but quite often, I don't see the newly created tables, but the changed version from a previous test - although I deleted those from my hard disk. So I presume there is a cache somewhere, maintained by Windows, Apache, MySQL or PHP. Can I flush that cache? How can I stop this weird behaviour? I hope I am not really damaging my database, because when I will be working with the real thing later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
delay times, threads
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and will the server always present the user with the latest database update (after a possible delay)? Suppose a user can add a new row to a database in a PHP page with a form, and after submit, the next page he will see is a page displaying part of the same database, hopefully with his new row on top. Questions: A) will he always see the new data which he entered just a second before? B) How much delay could there be. In other words, how multi-tasking is PHP; will it run the next script line, even when a previous line (a MySQL query) has not been completed yet? And will MySQL execute a next (non-update) query, when the precious one is not done yet? I think that last question has the beginnings of an answer in it... :-) Thanks a lot; this is a great mailing list! (please email me directly, I am not signed up) Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
databases disappear...
For the first time developing a PHP-MySQL system, I am experiencing strange things. Perhaps it is the off-line mode (Localhost) I am running Apache in, or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a database with a standard little PHP script. Then I start working on my other PHP scripts and testing them out. Of course there are mistakes, like forgotten semicolons or a left bracket where it should be a right one (parse errors), and I correct them, untill I get a nice output on my screen. But suddenly - Offset 0 is not valid for this result set. This is a mysql_data_seek() error, but that is probably a coincidence. The point is: MySQL suddenly thinks that the database is empty, as if it was destroyed. When I look in my MYSQL directory tree, I find my database in the \data subdirectory. So it is present (3 files for each table). When I look at the date stamps for the files, all maintain their creation date/time, although I did make changes to the tables during testing - except one table, with just one row in it (my user/password), did change the timestamp, but I did not access that one (it does not work under Windows)! It get weirder. I must physically delete the database from the MySQL data directory, before I can create them anew, with the same little script I mentioned above. Usually I can access the tabels again then, but quite often, I don't see the newly created tables, but the changed version from a previous test - although I deleted those from my hard disk. So I presume there is a cache somewhere, maintained by Windows, Apache, MySQL or PHP. Can I flush that cache? How can I stop this weird behaviour? I hope I am not really damaging my database, because when I will be working with the real thing later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco (please mail me directly, I am not on the list) | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
databases disappear...
For the first time developing a PHP-MySQL system, I am experiencing strange things. Perhaps it is the off-line mode (Localhost) I am running Apache in, or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a database with a standard little PHP script. Then I start working on my other PHP scripts and testing them out. Of course there are mistakes, like forgotten semicolons or a left bracket where it should be a right one (parse errors), and I correct them, untill I get a nice output on my screen. But suddenly - Offset 0 is not valid for this result set. This is a mysql_data_seek() error, but that is probably a coincidence. The point is: MySQL suddenly thinks that the database is empty, as if it was destroyed. When I look in my MYSQL directory tree, I find my database in the \data subdirectory. So it is present (3 files for each table). When I look at the date stamps for the files, all maintain their creation date/time, although I did make changes to the tables during testing - except one table, with just one row in it (my user/password), did change the timestamp, but I did not access that one (it does not work under Windows)! It get weirder. I must physically delete the database from the MySQL data directory, before I can create them anew, with the same little script I mentioned above. Usually I can access the tabels again then, but quite often, I don't see the newly created tables, but the changed version from a previous test - although I deleted those from my hard disk. So I presume there is a cache somewhere, maintained by Windows, Apache, MySQL or PHP. Can I flush that cache? How can I stop this weird behaviour? I hope I am not really damaging my database, because when I will be working with the real thing later on, I can not afford to have to start from scratch over and over again. Is there a workaround? Thanks, Marco (please mail me directly, I am not on the list) | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
PHP and MySQL result set navigation
I do something like this, where $result is the result of a mysql_query(): ?php while ($row = mysql_fetch_array($result)) { if ($row[col] == 1) { print_entry($row); } } ? This is to fill one column on screen. Now I would like to do the same for the second column: if ($row[col] == 2). But the $result pointer has moved to the end. How to move it back to the start again? reset() won't work, because it's not an array, just an integer pointing to a MySQL result set. How to move through this result set using PHP? Or should I just run a seperate query for each column with a 'where col =' clause? That looks like pretty intensive use of computer resources... I could also turn the result set into a 2D array of rows and work with that. Sounds a bit voluminous as well... Thanks, marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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
Can't login to MySQL from PHP
Hello, I am a novice to Apache, MySQL and PHP. I have just installed these on my Win98SE machine, and want to do some off-line ('localhost') exercises before I go on the web. Apache and PHP work; I can run PHP scripts that do not access a database. But as soon as I try mysql_connect(), I get errors. I am sure it is something very basic I am missing. Perhaps it's a matter of username/password; I fooled around a bit with those, but to no effect (how are those verified? I suppose they have to be entered in 2 places?). Does anyone have a hint? Or can someone guide me through a procedure to track the problem? Which additional info do you need? Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - 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