choosing datadir from create-statement

2002-09-25 Thread Hussein Morsy
Hello , i have version 3.23.52 Why CREATE TABLE user4( id INTEGER , passwort VARCHAR(10) ) DATA directory=/usr/local/mysql/data/test; doesent works (Syntax Error : because of DATA ..) - Before posting, please check:

Re: users and db visibility

2002-08-04 Thread Hussein Morsy
how can i make MySQL show only what db are available to the user? i.e., when a user logs in from a terminal application and types: 'show databases;' mysqld --safe-show-database or in my.cnf: safe-show-database With this option, the SHOW DATABASES command returns only those databases for

reload my.cnf without restarting

2002-08-04 Thread Hussein Morsy
Is it possible to reload changes of my.cnf without restarting the Server ? The reason is, that i want to toggle the log-file output of mysqld. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the

reload my.cnf

2002-07-11 Thread Hussein Morsy
Hello, when i change my configfile my.cnf, i have to restart my server. is there another way without restarting mysqld ? thanks Hussein Morsy Duessldorf,Germany - Before posting, please check: http://www.mysql.com