[PHP-DB] install mysql from source
Does anybody install mysql from source and able to insert binary data into mysql? I have tested it in the source installation MySQL server in RedHat 7.2 with PHP and found that the image can only be stored and retrival from mysql using PHP when the image's size is smaller than 1K. Although, I increase the size of mysql's max_allowed_packet, net_buffer, table_cache. But when I install MySQL rpm and do nothing change to mysqld configuration, it works properly when I insert and retrival image from mysql even the image's size is larger than 500K. Anybody know the reasons? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: storing binary data in mysql
I have tested it in the source installation MySQL server with PHP and found that the image can only be stored and retrival from mysql using PHP when the image's size is smaller that 1K. Although, I increase the size of mysql's max_allowed_packet, net_buffer, table_cache. "Fred" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D :[EMAIL PROTECTED] > Why do you think it cannot store binary data? Are you recieving an error > message. If so, what it is? > > Fred > > Fai <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > I use MySQL rpm to install in RedHat 7.2 in one of > > my pc. Then I store binary data such as image in > > MySQL and it works normally. > > > > However, I install source MySQL in RedHat 7.2 in > > another pc. But it cannot store binary data. > > > > Does anybody know the reason? Is that it need some > > special configure option when compiling MySQL from source? > > > > Thank you very much! > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] storing binary data in mysql
I use MySQL rpm to install in RedHat 7.2 in one of my pc. Then I store binary data such as image in MySQL and it works normally. However, I install source MySQL in RedHat 7.2 in another pc. But it cannot store binary data. Does anybody know the reason? Is that it need some special configure option when compiling MySQL from source? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql optional file - my.cnf
Does any body know how to prevent mysql server looking for user specific optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in his home directory to affect the mysql server behaviour. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] sql problem
SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summmary=@A WHERE type=1; What does @A: mean? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql grant problem
When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query: DESC tbl_name_1; he can see all the structure of that table. This makes that peter does not know which column he can use. This also is the case that the user still can see all the database in mysql server when he issues "show databases" even if he only has the right to use one database althought we can use the "--skip-show-database" command at the start up. Does any body know how to solve these problems? Or this is mysql server's restriction while compare with Oracle or MSSQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] auto_increment in mysql
The version you use may be lower than 3.23 because auto_increment sequence number begin at 1 for MySQL version up to 3.23. "Russ Michell" <[EMAIL PROTECTED]> ? news:[EMAIL PROTECTED]... > I may be semi-new to this MySQl lark but I'm sure auto_increment starts > at 0. > > Russ > > #---# > > "Believe nothing - consider everything" > > Russ Michell > Anglia Polytechnic University Webteam > http://gertrude.sipu.anglia.ac.uk/webteam > [EMAIL PROTECTED] > +44 (0)1223 363271 ext 2331 > > www.theruss.com > > #---# > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] auto_increment in mysql
In mysql, the auto_increment start at 1 default, But, how can I make the auto_increment start at 0? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql grant problem?
When we use grant as following: GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by "peter"; Then peter can only select the field of col_name_1 on the tbl_name_1 of db_name_1. However, when peter issue the query: DESC tbl_name_1; he can see all the structure of that table. This makes that peter does not know which column he can use. Does any body know how to make peter only can see the column which he has right to use it when he issue DESC tbl_name_1. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] what is connection id?
1. What is connection id? We will see this like "your mysql connection id is 12" when you enter into the mysql client programme. 2. Why will the connection id in mysql increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] connection id in mysql
Does any body know why the connection id in mysql will increase when you exit the mysql and login again? But I think the connection id should be cleared when user exit mysql. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Does php have build-in function to copy a directory?
How to use php to copy a whole directory including all files in that directory into another directory? Thank you very much! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] using php to generate html file?
Does any body know how to use php to generate html file? That is when a user input for a webpage title, webpage background color or image in a php page, and then we can generate a html file which contains the properties of user's input such as background color. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]