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
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'))
{
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
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
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?