[PHP-DB] MySql backup

2003-11-25 Thread Robin Kopetzky
Question - if I stop MySql using WinMySqladmin on NT4.0, will I be able to completely backup the data directory or do I need to do something else? This is a commercial application that I need to backup, so it's mighty darned important. Any help is appreciated. Robin 'Sparky' Kopetzky Black Mesa C

[PHP-DB] PHP/DB speed

2003-12-21 Thread Robin Kopetzky
Good afternoon! I am writing a project and have a speed concern... The code I am using is thus and is retrieving around 2,500 records: $result = mysql_query($sql) while ($row = mysql_fetch_array($result)) { build stmt } Is

[PHP-DB] Clueless abt Error with MySql

2003-09-08 Thread Robin Kopetzky
Good Evening! I have installed Mysql from RedHat 8.0 and am having difficulties starting mysql. I check the my.cnf file and it appears fine as all files it calls for are in the right directories. When I attempt to start mysql, I get a cannot connect through mysql.sock. What is causing this or put

[PHP-DB] RH 8.0 Mysql help

2003-09-09 Thread Robin Kopetzky
Would some kind soul who has installed MySql on a RH8.0 box please email me (off list) and help me get this running?? I have installed it a dozen times, followed the post-installation and testing from the Mysql manual and STILL can't make this run. I need this for a e-commerce site like yesterday!!

[PHP-DB] Authentication question

2003-10-03 Thread Robin Kopetzky
Good evening! I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What "GRANT" statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it right. Specifically, I need the user to

[PHP-DB] Confused

2003-10-05 Thread Robin Kopetzky
I need to setup a user, 'commerce' with a password, that can be accessed from any web server in our farm 'blackmesa-isp.net'. What "GRANT" statement do I need to make this work? I've tried a bunch of the examples in the manual and can't get it right. Specifically, I need the user to CONNECT, SELECT

RE: [PHP-DB] Confused

2003-10-05 Thread Robin Kopetzky
To answer your question, yes, I'm using mysql. No, I did not intended for everyone to go thermonuclear over this question. Next time, I'll go elsewhere since some one got P.O.'d about my posting twice. Sparky -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.ph

[PHP-DB] Is this redundant? {OT}

2003-10-06 Thread Robin Kopetzky
Good afternoon. I found this code in a program I'm renovating and think this is very redundant. Also, it does slow queries down while doing all of the conversions. prod_id in the mysql database is declared an integer. where prod_id = '" . (int)$prod_id . "' and Question: since $prod_i