Hello, I need some advice regarding a scrolling list that I've built
from a query. I can generated the scrolling list just fine, but when I
try to put the subroutine within a table (cell), all I get is a hash
reference:
-+-+
Date
Did you check the mysql db, host, and user tables to make sure that
'localhost' and 'administrator' have appropriate permissions to use your
desired database? This issue caused me much frustration until I had
things set right. You should see something like the following. I'm
assuming that your
Please disregard. I finally found the answer -- I need mysql client
software on the local box -- in the online documentation.
Brian
-Original Message-
From: Brian Warn [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 07, 2002 3:40 PM
To: 'MySQL List'
Subject: DBD::mysql for
If I want to load DBD::mysql on a box where mysql is not installed, do I
need to install some mysql components? I'm doing this because I'll be
connecting to a remote box from my perl script to query, etc. mysql on the
remote box. While using cpan to install the DBD::mysql module, I received
the
utput will give me the total diskspace occupied by the
table?
Brian
sql,query
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 8:58 AM
To: Brian Warn; 'MySQL List'
Subject: RE: 3.22.32: max table size
Quoted from http://w
As show table status doesn't appear to be supported in this older version
I'm using, how did you who used this version get max table size information?
I haven't been to find anything from the list archives/manual about this.
Brian
sql,query
---
Hi,
I want to build a temp table which I can query to sum values. If I try
"create temporary table tbl_name select some_query_here", then I get an
error that tells me that I have an error with my sql syntax near 'temporary
table tbl_name select some_query_here'. Am I correct in thinking that thi
When I run the code below, information about the first column in each
table in my list is excluded. Any ideas why?
@table_listing=`cat /usr/local/file.txt`; # contains table list used
below
$dbh =
DBI->connect("dbi:mysql:database=dbname;host=hostIP;port=port_number",
"user", "password") or di
I'm stuck right now with using v. 3.22.32. Yes, I know I need to
upgrade, but I can't for various reasons. Anyway, I need to do a select
count(distinct column) from table query, but can't since this version
doesn't support it. How can I do this?
Thanks,
Brian
As I recall when I set this up on my machine, you have to identify your
machine in the host table (identify it as a permitted host), the db
table (let mysql know to what db's, as what user, with what permissions
you're allowed to connect), and I believe the user table to the mysql
db. With these
Yes, I gave it 644 permissions.
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: "BW (ST)" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:58 AM
Subject: RE: 'tmp/mysql.sock' (2) error
> > I'm trying to use a socket be
Hello,
I want to use two text columns as my primary key. From the DuBois book, I see that I
cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns cannot
be indexed. Besides upgrading to v. 3.23+, is there any workaround to this? One
column will simply store really l
I've had good success with DB Tools: http://dbtools.vila.bol.com.br
- Original Message -
From: "Muhammad Asif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 8:11 AM
Subject: MySQL tool
> Is there any tool available for managing graphically databases,tables
If the contractor didn't use a my.cnf file, check your
$MYSQL/bin/safe_mysqld file. Somewhere around line 124 (v. 3.22.32 on
solaris), you should find and entry such as:
nohup $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR
$MY_OPTS\ >> $err_log 2>&1
on my redhat box, the entry
I vote for VanDyke's CRT as well -- lots of features and ~ $30 (US) for the
license.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 3:04 PM
Subject: Re: Telnet into MySQL
>
> Any good ones for the Windozes version..When I use just regul
Hello All,
Is there some way, when mysql server is running, to change an option? I want to
change skip_networking to OFF without doing a server restart.
Thanks,
Brian
I'm looking at different ways to backup a database from a solaris 2.8 box to a solaris
2.7 one. In addition to the standard system backups that our sysadmins do during the
week, I want to do a full backup of the database to a box where I have much more disk
space than the one where the product
Hello,
I'm trying to change the location where mysql.sock is written on server startup from
/tmp to another location. I've discovered that, on machine (solaris 8; mysql
v.3.22.32) reboot, that the /tmp directory changes it's permissions to 755 (owned by
root). Since safe_mysqld runs as mysql
Might be a case of the blind leading the blind here (list folks: please
correct me if I'm way off base ...)
I believe that one way to do this would be to create a file with any SQL
commands you want to run and then redirect it to mysql via back ticks:
`mysql -uroot < sql_command_file`;
Normally
Hi,
How do I restore a copied database that I've created with mysqldump? I have both the
DuBois book and, of course, the online manual handy. I'm obviously looking in the
wrong area of them because I can't find anything (I thought the keyword 'restore'
would net me something, but no joy). I
Make sure in (solaris + ksh) /etc/profile or $HOME/.profile that
/usr/local/mysql/bin is in the path for the user under which you run mysql:
e.g.
PATH=/usr/bin:/usr/local/bin:/usr/local/mysql/bin
-Brian
- Original Message -
From: "Ngu Nguyen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
I followed the instructions at the top of the mysql.server file and it works
great for me:
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind
# Mysql daemon start/stop script.
# Usually this is put in
) for the files... Set the
same ownership and permissions for the 'data' directories (if you've placed
them somewhere else on the system (linked to 'var' via symbolic links).
- Original Message -
From: "Foresight Systems Ltd." <[EMAIL PROTECT
I finally did find a discussion in Monty's book on p. 417 about this.
Thanks,
Brian
- Original Message -
From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 03, 2001 11:20 AM
Subject: Re: ownership/permission problems
>
> >I haven't had any success
After installing the server and client RPMs on my RH 7 box and verifying that
everything worked properly as root. Since I want mysql to run as the mysql user, I
searched for every directory where mysql occurred and changed ownership from root:root
to mysql:root. I can start safe_mysqld fine a
25 matches
Mail list logo
