Hi Kathy,
I don't have that file in my folder, but it still
starts.
Colin.
To fix this i checked the hostname.err file in
mysql/data. From looking at this i found the lines
that gave me errors, i played around with these and
ended up getting an error like 'the socket is already
binded' or so
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi list, Peter,
thanks for the tip with gdb.
At the moment I'm not able to reproduce the cpu-hog,
I only have the backtrace of one such event.
Situation was:
After one or two updates of the master (and perhaps some
"show slave status" or "show ma
Hello,
I must installer mysql into a server with SPARC processor and Sun Os 5.8.
Which is the correct version that I try to download from mysql site?
Thanks in advanced.
-
Before posting, please check:
http://www.mysql.com
Hi again i didn't get any feed back regarding MqSql boolean
field/datatype i note that it is evident in version 4.1 my version is
3.23 ok.
Plz advice, as there is nothing in the pdf.manual about bool (boolean
true/false values) Only something is regards to MySql keywords bool.
Thus i have use
HI,
I have two questions:
1) is there a way to tell my mysql master not to log failed executions, such as
creation of existing tables, drop of inexistant databases etc?
Each of these operations lock the slave, and I believe that it' conceptually wrong
logging them, since they never took pla
Venu wrote:
>>-Original Message-
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Saturday, March 30, 2002 12:40 PM
>>To: [EMAIL PROTECTED]
>>Subject: Begging for help.
>>
>>
>>Hi all,
>>
>>Begging for help.
>>
>>Newbie so please keep solutions as simple as possible please.
>>
mysql> select max(dh.maxtid),max(d.tiden) from heaptest dh,diary d;
+-+-+
| max(dh.maxtid) | max(d.tiden)|
+--
I've been using MySQL on WindowsNT and Solaris for about 5-6 years
(don't use any NT machines anymore), and have yet to experience a
single corrupted table, mysql daemon crash or any other problem with
MySQL. There were a couple of minor snafus when I was setting things
up, but they were mostl
>Description:
when I try to start mysqld I have the following problem:
ld.so.1: ./mysqld: fatal: libz.so.1: open failed: No such file or directory
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Super-User
>Organization:
>MySQL support: none
>Synopsis:
>
Hello,
When i try to launch my server mysqld I have the follwing result:
ld.so.1: ./bin/my_print_defaults: fatal: libz.so.1: open failed: No such
file or directory
I have installed the following version mysql-3.23.49 (Official MySQL
binary)
Environment:
System: SunOS lan-ba14ub-04 5
I'm doing some benchmarks in order to understand where are the bottlenecks
in my solution and I found that a SQL query on a table with 12000 records
takes 0,87 seconds to preform (Dual 800 G4 MacOS X Server)
0,87 sec may seem fast but it is not on a solution which is going to have a
lot of traffic
Dear all.
Where is stored and/or how to remove history of command line in mysql client connected
to the server ?
After the password were changed I would like to delete trace of such activity to
prevent plain text passwords
in password('...') command against common user.
Thanks in advance.
Ma
I have a table that recieves raw data form results for an online quiz. The
boss wants to analyse the data , I have it all going to one table for
processing. From that table of "Raw Data" I pick out what I need. I want to
pick out the test name but I dont want duplicate. I made the column unique
in
On 2-04-2002 15:28, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote:
> If many other tasks are running, try to renice it (though not too much).
What does renice mean? How can I do that?
> I just ran an INNER JOIN query with a result of 21397 records in the set on
> my 867 G4 and it took around 0.5
On 2-04-2002 15:32, "Ulrik Witschass" <[EMAIL PROTECTED]> wrote:
> Also monitor top or the process viewer during the query. I noticed that
> without renicing, MySQLD never jumped over 10% CPU usage. So theoretically,
> I can run 10 queries at the same time and they would be as fast as running
> j
There is no support for sub-queroes in MySQL, so your second select is
getting kicked out. You probably want a left join for this.
On Tue, 2002-04-02 at 06:54, jim and lois flaherty wrote:
> I have a table that recieves raw data form results for an online quiz. The
> boss wants to analyse the da
mysql version 4.x does this
-Original Message-
From: David yahoo [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 5:28 PM
To: [EMAIL PROTECTED]
Subject: multiple delete for mysql
Hi all,
How can i do a delete from multiple table in mysql?
Eg :
I want ot delete record something
select id, shortdescription, title from reviews where title REGEXP
'^[0-9$].*' ORDER BY title ASC
-Original Message-
From: Jay Paulson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 6:32 PM
To: [EMAIL PROTECTED]
Subject: easy query question
I want to do a query that will find
Hello,
When using 'insert delayed' syntax and there is a timestamp field in the table
but not specified in the insert query, which timestamp is actually used when
the record ends up in the destination table? In other words, will the
timestamp value be the actual timestamp that the record was inse
What happened when you tried this experiment?
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 8:50 AM
To: [EMAIL PROTECTED]
Subject: insert delayed and timestamps
Hello,
When using 'insert delayed' syntax and there is a timestamp field in
Hello,
We have an 'outgoing' table being used to store email header information
defined as follows:
CREATE TABLE outgoing (
rpath varchar(80) default NULL,
auth varchar(80) NOT NULL default '',
ip varchar(80) default NULL,
hfrom varchar(80) default NULL,
hto varchar(80) default NULL,
perhaps you can run this more frequently, say once an hour if
it does not interfere with your application logic.
> -Original Message-
> From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:57 PM
> To: [EMAIL PROTECTED]
> Subject: help optimizing log table delet
You can use the LIMIT clause to break up a long DELETE into a series of shorter ones,
executed in a loop.
So, in pseudo-code:
Set delete_row_max = 1000 (or another appropriate value)
do
{
DELETE FROM outgoing
WHERE timestamp < last_time
LIMIT delete_row_max;
row_count = no. of
Currently there is no built-in straight-forward methods to authenticate
against LDAP Directories. However, I have heard from others who have
compiled OpenLDAP using MySQL as a back-end database.
OpenLDAP: I do not know if the possibility exists to replicate the
MySQL tables storing the Op
Have you looked at mysqlmanager?
It is still being developed and I am told it should not be used other than
for testing MySQL. There is a mysqlmanagerc (client) app that goes with
it. It looks like it is being made to execute commands remotely.
I am waiting for someone to tell me what 'bin/mysq
Andrew,
Tuesday, April 02, 2002, 10:06:42 AM, you wrote:
A> I keep on getting the following error message when trying to connect to
A> MySQL - ERROR 2002: Can't connect to local MySQL server through socket
A> '/var/lib/mysql/mysql.sock'
A> This can be fixed by creating a link from the /tmp/mys
Hytham,
Monday, April 01, 2002, 9:29:40 PM, you wrote:
HS> how can i use arabic language in the mysql tables data, my data in the
HS> table looks like Extended Ascii, and it is re-interpreted in windows
HS> programs - as MySQLMaker - into arabic, how can i let MySQL itself
HS> understand arab
Marek,
Tuesday, April 02, 2002, 3:20:45 PM, you wrote:
MW> Where is stored and/or how to remove history of command line in mysql client
connected to the server ?
If the variable MYSQL_HISTFILE is set, history is written in the file this
var points to.
In other case history is written in ~/.my
Zack,
Saturday, March 30, 2002, 10:52:40 PM, you wrote:
That appears to be a PHP script problem, not MySQL one. But first try
to upgrade MySQL to 3.23.49a and see how the behavior changes.
ZA> Hey, I'm having MySQL exhibit some really weird behavior. I am running
ZA> 3.23.41 on OS X. I'm tryin
Carl,
Tuesday, April 02, 2002, 2:54:45 AM, you wrote:
CWK> I downloaded mysqlgui linux semi static binary and installed it. I copy
CWK> my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up
CWK> it prompts for password then indicates that it can't connect. I am using
CWK> the s
jim,
Tuesday, April 02, 2002, 2:54:13 PM, you wrote:
jalf> I have a table that recieves raw data form results for an online quiz. The
jalf> boss wants to analyse the data , I have it all going to one table for
jalf> processing. From that table of "Raw Data" I pick out what I need. I want to
jalf>
Everitte,
Monday, April 01, 2002, 11:28:31 PM, you wrote:
Eeoen> I have the 3.23.49 Version of MySQL and it is saying the load data command
Eeoen> does not work with this version. I also read in my book that any version
Eeoen> past 3.22.15 should be able to complete this function. Please advise
Bob,
Tuesday, April 02, 2002, 12:49:55 AM, you wrote:
BL> ./safe_mysqld --user=mysqld --datadir=/db/
BL> ./safe_mysqld --user=mysqld --datadir=/db/
BL> 020401 16:55:04 mysqld started
BL> 020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
BL>
soracchi,
Tuesday, April 02, 2002, 2:55:37 PM, you wrote:
s>Description:
s> when I try to start mysqld I have the following problem:
s> ld.so.1: ./mysqld: fatal: libz.so.1: open failed: No such file or directory
Seems it's not a bug, looks like that zlib is not installed on your
box.
Liivar,
Tuesday, April 02, 2002, 10:52:01 AM, you wrote:
LP> How I can use ',' instead of '.' in a number values in mysql. I changed
LP> charactermap but nothing.
LP> MySQL 3.23.41 RH7.2
No, you can't use ',' in a numeric values. If you want to store data
separated with a ',' you can store as a
At this 09:33 2/04/02 +0200 Roger Baklund told us all something interesting :-
>* Gordon Stewart
>[...]
> > http://homepages.slingshot.co.nz/~gordon52/3.txt
>[...]
> >while ( $row = mysql_fetch_array($result) ) {
> > echo("" . $row["JokeText"] . "");
>[...]
> > But how do i list the ac
I have setup replication between two servers. Everything works great.
I wanted to change the location of the bin-log file. I tried
'log-bin=/somedirectory/replication.log' but I get this error
'replication.1 not found (Errcode: 2)'. I took this from the manual:
|--
On Tue, Apr 02, 2002 at 08:53:27AM -0600, Rick Emery wrote:
> What happened when you tried this experiment?
I just did the following:
In one client connection, issued 'lock tables outgoing write'.
Then in another client connection, tried to do an 'insert delayed' without
specifying the timestam
Hello everybody,
I am running mysql-3.23.47 on FreeBSD 4.5, and everytime I use myisamchk I
get the following error:
><
[root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a
correct index
Hello everybody,
I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I
get the following error:
><
[root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
myisamchk: error: '/opt/db/mysql/netcard/d_usuario.MYD' doesn't have a
correct index
Hi everyone,
I am trying to understand what's going on here and I hope you can help me.
The swe7 characters set in swe7.conf has some really strange mappings in it.
For instance, the to_upper array maps ASCII 0x7E (a tilde) to 0x5E (a "hat"
aka Ctrl character). Why doesn't a tilde remain a tilde?
A few weeks ago, my mysql 3.23.46 server spontaneously started changing
its data directory to /var/tmp/ once or twice a week, and once or twice
a day for a short span. Nothing in the error file. Anyone seen anything
like this or have any idea what's going on? I changed the data directory
to a
I think that this question might be kinda of stupid for all of you but I
couldn't find a good answer... When we use the MySQL internal function -
Password('string') - MySQL inserts that string codified into the database, so
that people that look for that doesn't know the real password. But i h
Okay, here's a hint...
4.2.9 in the manual (;o)
Basically, if you encrypt the password, then you have to look it up using
the password function, too.
Ken Hylton
Programmer Analyst IV
LEC Systems & Programming
Billing Concepts, Inc.
7411 John Smith Drive
San Antonio, Texas 78229-4898
(210) 949
If user_id and passwd are fields in your table and the passwd field is
encrypted :
SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
> -Original Message-
> From: Ramiro Varandas Jr [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 11:49 AM
> To: [EMAIL PRO
--- Ramiro Varandas Jr <[EMAIL PROTECTED]>
wrote:
> I think that this question might be kinda of stupid
> for all of you but I
> couldn't find a good answer... When we use the MySQL
> internal function -
> Password('string') - MySQL inserts that string
> codified into the database, so
> that
From: Kenneth Hylton <[EMAIL PROTECTED]>
> Basically, if you encrypt the password, then you have to look it up using
> the password function, too.
What he means is this:
SELECT user_id FROM user WHERE PASSWORD(user_pass) = PASSWORD('my_var')
---
Rodney Broom
Programmer: Desert.Net
sql
--
From: Lee, Andrew <[EMAIL PROTECTED]>
> If user_id and passwd are fields in your table and the passwd field is
> encrypted :
> SELECT user_id FROM user WHERE passwd = PASSWORD('plaintext_user_pass')
Woops, I was typing too fast Ramiro. Andrew's query is right and mine is wrong.
---
Rodney Broom
Hi everybody:
where i can find a forum than works with php,mysql. for my site. or the
source code for one.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
I want to use MySQL to connect to a UniData database and 'replicate' (via ODBC)
some UniData tables. Has anyone used MySQL in this way? Do I need MySQL and
MyODBC?
-
Before posting, please check:
http://www.mysql.com/manual
y'all are kidding, right?
On Mon, 1 Apr 2002, Dan Zarrella wrote:
> i've read the bit on google about thier pigeon rank thing, sounds like a
> cross between reality and alittle aprils' fools to me, either way id
> apreciate a better explanation of this technology and how it may be
> implem
you can try http://phpnuke.org
Thank You
<><><><><><><><><><><><><><><><>
Daniel Negrón
Lotus Notes Administrator / Developer
KB Electronics, Inc.
954.346.4900x122
http://www.kbelectronics.com
<><><><><><><><><><><><><><><><>
|+>
|| Javier
From: Curtis Maurand <[EMAIL PROTECTED]>
> y'all are kidding, right?
http://www.google.com/technology/pigeonrank.html
---
Rodney Broom
Programmer: Desert.Net
sql
-
Before posting, please check:
http://www.mysql.com/ma
Hi,
I just installed MySQL 3.23.49 on NT and executed the following
commands:
UPDATE USER SET password=password("test1") WHERE host="localhost";
UPDATE USER SET password=password("test1") WHERE host="%";
Now, after doing 'mysqladmin reload', I cannot connect...
> mysql -p
> Enter password:
I have MACOSX 10.1.3.
PHP runs fine with no problem could someone help me install or direct
me to where i can get instruction of how to install MYSQL on my
machine please.
-
Before posting, please check:
http://www.mysql.com
Hi all,
I have a mysql table, which gives the error read-only when I use LOAD DATA
INFILE command. How do I change this, I read the online manaul with no
success.
Thanks.
-
Valerie Brooks
Fujitsu Software
3055 Orchard Dr.
Sa
Here's a good one:
http://www.xmbforum.com/
-Original Message-
From: Javier Gloria [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 11:27 AM
To: mysql
Subject: mysql forum
Hi everybody:
where i can find a forum than works with php,mysql. for my site. or the
source code for o
How about newsgroups for php? They have a couple on php/mysql I
believe and they respond quite quickly... Look at php.net
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 12:12 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE:
What is the best method to backup all your MYSQL DATBASES with not a lot
of down time. I have read about using "mysqlhotcopy" and "mysqldump"
are these the best methods. Also what procedure is followed in backing
up the databases. I'm basically looking for the must accurate and
reliable way of
Assuming you have the developer tools installed, it compiles just fine:
./configure
make
make install
if you don't have the dev tools, check VersionTracker. Someone probably
has the binaries packaged up.
On Tuesday, April 2, 2002, at 01:11 PM, Bensin Joseph wrote:
> I have MACOSX 10.1.3.
> P
We use mysqldump.
It is fast and easy. restoration is not hard.
If you want more a more percise restoration option, look at using the
change-log. It wil allow you to revert back in time to a state of the DB.
-RG
On Tue, 2 Apr 2002, Kory Wheatley wrote:
> Date: Tue, 02 Apr 2002 11:26:58 -0700
>
I regularly back up all my databases with mysqldump:
mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
MySQL-Backup-DATE.tar.gz -z tmp.sql && rm -f tmp.sql
I use a script (to determine DATE) in conjunction with cron to back all
databases up nightly, and I also have the script
Hi all,
I hope I am not too far off the topic here. I actually need help with cgi,
and mysql.
Please refer to the this file to see the program itself:
http://www.jhanna.com/ExtraPage4.txt
What I need to do is to break apart the subroutine, and do some
manupulations on it before displaying the out
Hello,
I am having a problem connecting to a mysql database.
My url string is as follows:
private static final String url = "jdbc:mysql://localhost:3306/test";
and I call the DriverManager with:
DriverManager.getConnection(url, userName, password);
The output of this is:
--SQLException--
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
David McInnis
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 10:40 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: backup databa
* Gordon Stewart
> (I'll assume you can do EVERYTHING in PHP as you can in dos... ??)
yes, almost... when you say 'dos', I assume you mean the mysql client
console. There are a couple of things you can do in the client console that
can not be done with the client api... like using \c to cancel a
Will you never put your files on the net? If so, what will you expect to
find at the remote server? Your character set?
IMO forget character mapping and use BINARY option at fields creation,
usally the contains will be upercase or lowercase, not both. The only
exeption I can think is to index - or
I have INVOICE table here is the layout:
+-+---+--+-+-+--
--+
| Field | Type | Null | Key | Default | Extra
|
+-+---+--+-+-+--
--+
| ID
From: David McInnis <[EMAIL PROTECTED]>
> Could you share your script for doing the date thing with the rest of
> us? That sounds useful.
> > From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
> > mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar -cf
> > MySQL-Backup-DATE.tar.gz
There is a great page with instructions and binaries for this stuff at
http://www.entropy.ch/software/macosx/
Michael
Bensin Joseph wrote:
> I have MACOSX 10.1.3.
> PHP runs fine with no problem could someone help me install or direct me
> to where i can get instruction of how to install MYSQL
I have the following query:
select *, max(event_date) as high, min(event_date) as low from schedule
where event_date between '2002-03-01' and '2003-04-30' group by
week_ending,meeting_id order by name, event_date, start_time
If I order by event_date, start_time, name, I get the proper results.
Sure. Just create a new file called something like mysqlbackup.sh and chmod
it to make it executable. Change any of the vars you want, and it should
work (but remember to update the e-mail part of it to use whatever e-mail
client you want, unless you just want to leave that part out)
This is a cu
I thank all the people that helped me... was very usefull, I tried each one...
But i'm using ASP with a DSN Connection
Check the code:
Set MyConnection = Server.CreateObject("ADODB.Connection")
MyConnInfo = "DSN=MyDSN;UID=MyUser;PWD=MyPass;"
MyConnection.Open MyConnInfo
SQL = "INSERT INTO user
I granted all privileges to [EMAIL PROTECTED], and everything
worked well.
thanks a bunch,
c.
"Land, Christopher" wrote:
> [EMAIL PROTECTED] -- perhaps?
>
> C:~
>
> -Original Message-
> From: Chris Huisman [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 10:51 AM
> To: mysq
Folks,
The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried
running the OPTIMIZE TABLE command on it, as recommended on this list for improving
performance.
Yesterday there were 75,000 records in my database.
Today, there are 13,000 records.
Apart from the Op
How do you set up the server.xml and web.xml files to use connection
pooling in Tomcat using the org.gjt.mm.mysql.Driver JDLC driver (version
mm.mysql-2.0.11)?
I have set up and used a simple data source, but I can't get the pooled
one working - do I need to set it up differently?
Originally, I
We use mybackup.pl - a perl script found on sourceforge (well, not
anymore I just looked). It creates a compressed tarball of each
database, with a file for each table. The files can be used with the
mysql client without change to rebuild a table. It also can be setup to
rotate the backups base
It's easy shell.
-
#!/usr/bin/bash
DATE=`/usr/bin/date '+%Y%m%d%H%M%S'` # or '+%Y%m%d'
mysqldump -uUsername -pPassword --all-databases > tmp.sql && tar \
-cf MySQL-Backup-${DATE}.tar.gz -z tmp.sql && rm -f tmp.sql
-
-RG
On Tue, 2 Apr 2002, David McInnis wrote:
> Date: Tue, 2 Apr 2002
Im going to take a shot in the dark since I have not messed with ASP in
years
Have you just tried to verify the data is there with a simpler script?
Just do the connection script then the user_check then see if it is
still there. If it was PHP I would be able to find it.
-Original Messa
Hi,listers,
I am using java servlet and mysql to develpe a
application. i am wondering can i put jtable in
session?
Thanks in advance
bin
__
Find, Connect, Date! http://personals.yahoo.ca
---
[EMAIL PROTECTED] writes:
>Not sure what to tell you - check to see if you have logging enabled on your
Logging is not enabled.
>
>This is a longshot, but you might have had a corrupted index that
>inaccurately reported 75k records when you really were only at 13k, and
>optimizing the table did s
Stéphane,
> I have INVOICE table here is the layout:
>
>
+-+---+--+-+-+--
> --+
> | Field | Type | Null | Key | Default |
Extra
> |
>
+-+---+--+-+-+-
Hello, All:
We have encountered the problem to install Mysql-3.23.49 version on Linux
Redhat 7.1.
1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed
data--format violated.
Can anyone offer some assistance o
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=mysql_fetch_array($r)) {
$retval.=" - %s",$a["url"],$a["picurl"],$a["url"],$a["title"])";
}
It just gives me a parse error on the page for the $retval. = line
Thanks!
-
While this should be on the PHP list, here's the problem. You're not doing a
printf or whatever function that is that replaces %s with values - you're
just assigning the string to $retval. It should look something like:
$retval .= printf(" ...yadayada");
look up the syntax - I never use printf,
i got a problem thats keep on coming and coming, it's like this:
first time i run WINmySqladmin and try to make a database on my localhost
(http:/localhost:82/PHPmyadmin/index), it will give no problem, so i make my
database and connect it to my PHP scripts, so it worked :). But now, when i
re
sounds like you have a problem in your phpmyadmin config file, I forget the syntax I
stopped using phpmyadmin some time ago, but I remember those error messages.
opinion: if the mysql database is on your network, you can try mysql front as a tool
to add databases, tables, users, and everything
Hi all,
I d like to now is there any way to optimize mysql table space judging from
the
data there is in.
My table can be read only.
I put some arbitrary varchar(x) which ddn t correspond to true max len in
table.
Is there a free gpl tool to diagnose my tables ?
Thanks.
___
$retval = .= " ".
"- ".$a["title"]."";
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=
Hi all,
I d like to now is there any way to optimize mysql table space judging from
the data there is in.
My table can be read only.
I put some arbitrary varchar(x) which ddn t correspond to true max len in
table.
Is there a free gpl tool to diagnose my tables ?
Thanks.
query -> sql
What would the script look like if I'm on Win2k ?
Mark
-Original Message-
From: Rodney Broom <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 12:22 PM
Subject: Re: backup databases
>From: David McInnis <[EMAIL PROTECTED]>
>
>> Could you share
On Tue, 2 Apr 2002, Mark Stringham wrote:
>
> What would the script look like if I'm on Win2k ?
Good luck!!
But seriously; there is a $300 software package out there (can't remember
name) that will give your billy-boy OS some unix shell-like capabilities,
including TAR. It was featured in like
Check out cygwin.com. I think it's free. Great for unix guys having to
run on NT.
Dave
On Tue, Apr 02, 2002 at 05:25:15PM -0600, Russell E Glaue wrote:
>
> On Tue, 2 Apr 2002, Mark Stringham wrote:
> >
> > What would the script look like if I'm on Win2k ?
>
> Good luck!!
>
> But seriously; th
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue <[EMAIL PROTECTED]>
To: Mark Stringham <[EMAIL PROTECTED]>
Cc: Rodney Broom <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Date: Tuesday, April 02, 2002 4:25 PM
Subject: Re: backup databases
Maybe... after some long hours and many lines. I am not sure. I know it
won't necessarilly be easy.
You'd be better off using PERL.
You can download the windows binary of PERL for free. (www.perl.org)
You can install PERL anywhere you want on the system just so long as your
PERL scripts point a
forgot to mention.
you'll have to use ZIP, since TAR is not available on Windows (unless
you use the previously mentioned software packages).
-RG
On Tue, 2 Apr 2002, Russell E Glaue wrote:
>
> Maybe... after some long hours and many lines. I am not sure. I know it
> won't necessarilly be easy.
Does any know if mysql has any kind of stored procedures?
If not, is there any plans on including them?
-matt
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On the mysql-internals mail list we had a thread going about this. I was
suggesting something like embedding PERL into MySQL to produce something
like PERL/SQL (similar to PL/SQL in oracle).
Unfortunately, although promising and liked among people of the list,
there are no plan right now to devel
>Description:
mysql 3.23.49 uses libtool 1.3.5. That version of libtool happens to be broken
on Tru64 4.0F PK3. It fails 17 of 49 tests that come with the libtool package.
libtool 1.4.2 passes all of its tests on this platform. The problem I have
when building mysql 3.23.49 is that libtool does
Hi, I just now signed up for this list a second ago and thought I'd say
howdy to everyone.
I'm not sure what the typical discussions are like on this list, so I'll
go ahead and ask anyhow.
If there is another list that would be better suited to this type of
question, please let me know.
A fr
1 - 100 of 119 matches
Mail list logo