[PHP-DB] MYSQL_CLIENT_COMPRESS

2003-06-06 Thread Armand Turpel
Hi, Is there any body who have experience with the flags in mysql_connect() in php = 4.3 . Especially the MYSQL_CLIENT_COMPRESS flag. Give it sense, to use this feature if both, apache/php and the mysql server reside on the same machine? Thanks, Armand -- PHP Database Mailing List

[PHP-DB] mysql_connect() -- flags

2003-06-01 Thread Armand Turpel
Hi, Is there any body who have experience with the flags in mysql_connect() in php = 4.3 . Especially the MYSQL_CLIENT_COMPRESS flag. I dont know if it works or not. I cant make any difference in performance tests on localhost. Should php must be compiled with a special flag to get work this?

[PHP-DB] BACKUP/RESTORE - file rights

2003-06-26 Thread Armand Turpel
Hi, Doing a backup of db tables under mysql using $sql = ' BACKUP TABLE test_table TO backup '; give the backup files the rights of the mysql server. I my environemt this is: user: mysql group: daemon If the apache isn't a member of

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Armand Turpel
Hi, You have only to modify it to your environement It works with mysql = 3.23.52 // Get all table names of the database // $sql = ' SHOW TABLES FROM test_db ; $db-query($sql); while($row = $db-fetchRow( 'DB_GETMODE_NUM')) {

Re: [PHP-DB] MySQL Backup, final script !!!

2003-06-26 Thread Armand Turpel
I use an db abstraction class. You have to replace this by yours. Of course you got a Fatal error: Call to a member function on a non-object because such an object dosen't exist in your script. First you have to connect to a database using mysql_connect() and using mysql_query and