How can I enable big-table option ?

2006-06-28 Thread Halid Faith
Hello I use mysql 4.1. I have a big table which has larger than 4 Gbyte. Therefore I get an error "table is full". How can I enable big-table ? Thanks

a character problem

2006-01-31 Thread Halid Faith
Hello I use mysql 4.1 and php4.3.10 and phpmyadmin2.6 and apache-2.0.53 on FreeBSD5.3 I add any text as news with phpadmin on web. it works well. But I have a problem. I see the line as ( '' test ) on web (internet explorer) When I add a text which contains ( ' test ) character with phpmyadm

a character problem

2006-01-31 Thread Halid Faith
Hello I use mysql 4.1 and php4.3.10 and phpmyadmin2.6 and apache-2.0.53 on FreeBSD5.3 I add any text as data with phpadmin on web. it works well. But I have a problem. As example if I add a text to mysql table with phpadmin. My text contains as below; "Halid 's car is expensive" I will see abo

apostrophe char problem

2006-03-02 Thread Halid Faith
Hello I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on FreeBSD5.3 I add any text as data with phpadmin on web. it works well. But I have a problem. As example if I add a text to mysql table with phpadmin. My text contains as below; "Halid 's car is expensive" I will see a

How to limit usage of mysql server's memory/cpu for each databases ?

2007-05-05 Thread Halid Faith
I use mysql4.1.22, php4.4.6 and apache2.0.59. I want to put an quota for each databases and mysql users. How can I do that mysql will limit each database's memory usage? Because some mysql users sometimes use much memory while doing a sql query. Also How can I put an quota for each databases as dat