On Wed, 25 Jul 2001, Paul DuBois wrote:
> I doubt if "they" are trying to irritate you. The maximum size of a MySQL
> database depends on your file system constraints, not on the size of
> a LONGTEXT.
> Some OSes have a max file size of 2GB, for example; others don't.
Linux ext2 filesystem onl
On Mon, 2 Jul 2001, craig riley wrote:
> Hi All,
> I have recently installed MySQL on my windows 2000 machine and
> everything is great except for the fact that it doesnt't seem to recognize
> upper case table / column names? This wouldn't be a problem if I was just
> developing locally
On Fri, 29 Jun 2001, @maury wrote:
> Greetings to all.
> I am new in the list. I need to know like I can consent with Code PHP to a
> database in MYSQL.
> Thank you for the Help that you can offer me.
> Amaury
there are many mysql function in php, mysql_query, mysql_connect, etc. PHP
manual wi
On Tue, 29 May 2001, Signe Hasseriis wrote:
> Please tell me how to select the 10 (or 5) newest records or posts from a MySql
>table.
>
> Best Wishes
>
> Signe Hasseriis
>
IMHO, there's no fair way.
May be this trick works. add a field with type timestamp to your table,
for example
'modifi
On Sat, 5 May 2001, David Loke wrote:
> Hi Guys!
>
> I am a web server system administrator. I would like to enable the users of
> my server to be able to install MySQL individually. That means each user
> will have their individual MySQL root access. And from there, their PHP can
> connect to t
Hi,
I think mysql support space in column name and table name, using left
tick " ` " like
create table `my foo` (`foo column` char(10) primary
key);
But phpmyadmin is broken with this. So, What about the standard?
TIA
-ilham-
-
On Wed, 25 Apr 2001, arijit das wrote:
> Sir,
>
> I have downloaded the binary stable version of
> MySQL from the site www.mysql.com.The package I
> downloaded is ..
>
> mysql-3.23.37-pc-linux-gnu-i686.tar.gz
>
> After unzipping and untaring,I entered then
> directory
> mysql-3
On Wed, 25 Apr 2001, Hunter Hillegas wrote:
> As I'm having a lot of problems with the source distro, I'm considering
> moving to your RPMs.
>
> The manual suggests that there are a lot of problems with Linux and threads,
> etc... and to use the prebuilt binaries if you can...
>
> I've been usi
On Thu, 5 Apr 2001, MCA Department PESIT wrote:
> hi there,
> my data directory is /var/lib/mysql . i have created a .my.cnf file
> here. i have restarted mysql and now i am not sure whether the entries are
> being read from the cnf file. can you tell me how to confirm this ?? thanks
> in
> > First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error
> > echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute
> > ./configure,the prompt is configure not found.I don't know what is the
> > reason.I think maybe the tar of Solaris is not work in good
On Mon, 2 Apr 2001, Anonymous Individual wrote:
> Greetings:
>
> I accidently dropped (my thunderous stupidity!!!) our mysql
> database. There were a few usernames and other databases.
>
> I expected hell to break loose (it may still happen!), but
> strangely enough, I noticed that I was still
Hi,
I can't find MySQL 3.23.37. Please tellme where I can dl it. Where is the
really latest release?
regards,
-ilham-
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
On Mon, 19 Mar 2001, Curtis Maurand wrote:
> Hi,
> Just a quick quesiton, I have a table that contains difined as
>
> create table picks(
>handle char(30) primary key,
><...>
> total int unsigned);
>
> there is a user table that has a list of handles and other user info. handle
On Mon, 19 Mar 2001, Andres M.V. Paglayan wrote:
> Hi you all,
> I´m trying to resolve how to manage a large resultset (about 500),
> showing only 20 rows per page and then to have the option to show more results from
>several buttons,
> like when you search something with a lot of pages in
Hi, after a few days, mysql take too much memory and sometimes causing
swap
memory exhausts. I'm sure that only one client accessing mysql server,
but I see too many threads. So I shutdown MySQL periodically. I use
mysql-large.cnf configuration file. If the client was killed by
KILL signal, or t
On Thu, 1 Mar 2001, nirmala wrote:
> Hi,
> We have installed Mysql on our server(UNIX) . When I am telnet into the
> server and try to start Mysql by below procedure, I am getting problem.
> Anyone can help me.
>
> [/usr/home/tree/www/treebc.com] : {2} % cd mysql/bin
> [/usr/home/tree/www/tr
MySQL version is currently 3.23.33 and always available at www.mysql.com
regards
-ilham-
On Fri, 23 Feb 2001 [EMAIL PROTECTED] wrote:
> Hai,
> Pls let me know at the earliest where I can download SQL 7
> Thanks in advance
>
> Vinay Talwar
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
>
> ---
On Tue, 20 Feb 2001, freelsq wrote:
> I write a cgi problem of c++, and I compile it and run it normally in mysql 3.22.25.
> but when I change the mysql to 3.23.32, I recompile the program and run it,
> It display a error msg like this:
>
> shell>./test
> ./test.fgi: error in loading shared l
On Mon, 19 Feb 2001, [iso-8859-1] diego López wrote:
> Hi all,
> i installed successful Mysql ver 3.25.33-1
> after that i changer the root password and when i make a connection looks
> like i am connecting with the user @localhost instead the root user
>
> [root@halley bin]# mysql -u root mysq
On Mon, 19 Feb 2001, Chris Aitken wrote:
> Hi Everyone.
>
> Just a quick question I worked out once before on my lonseome and the mysql
> manual, but it was longer ago than yesterday and it a blur how I did it.
>
> What I need to do is. I have a table, and in that table there are
> severa
create directory in your mysql data directory, like
/var/lib/mysql/mydatabase. copy your .frm, .ISD, ism to that directory.
now you have database named mydatabase.
--ilham--
On Fri, 16 Feb 2001, Ryan Ahmed wrote:
> Q:--have you heard about that guy who finally
> discovered what a woman is all a
copy or link your libmysqlclient.so.10.0 to /usr/lib. Or edit
/etc/ld.so.conf. Add path your libmysqlclient.so.10.0, and run ldconfig.
You must have root access.
--ilham--
On Fri, 16 Feb 2001, Alex Le Fevre wrote:
> I just installed MySQL version 3.23.32, and all
> appeared to go well. However,
On Fri, 16 Feb 2001, Kelly Zhu wrote:
> Try installing mySQL. Please help me out with these questions:
>
> 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was
> 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one?
Yes Youare right. beware of 386, 586, or
Hi, I get trouble with redhat 7
i compile the rpm source with this command
rpm -bb MySQL-3.23.32.src.rpm
then I install the binary rpm.
when I run mysql, i get problem with show tables and show databases. it
return some rows, but the contents is none.
mysql>show databases;
Databases
++
|
Connection refused, maybe mysqld is not running.
for general trouble shhoting,
try perror
--ilham--
On Thu, 15 Feb 2001, mik wrote:
> ERROT:2002:Cann't connect to local MySQL Server throught socket
>'/var/lib/mysql/mysql.sock' (111)
> [EMAIL PROTECTED]
>
>
> ---
25 matches
Mail list logo
