Hello
I use TQuery for select requests and TTable for update, insert and delete, it's easier
than typing an SQL sentence :-)
My problem has been resolved by a checkbox on the MyODBC driver: I checked "Safety
(check this if you have problems)" and I've no problem anymore. Strange or magic,
isn
Hi!
I am currently installing and testing the latest
stable version of mysql with an sunblade 1000
workstations (2 cpu, 750 MHz, 1 GB RAM).
Does anybody know some hints how to tune
the OS (solaris performance tuning).
Thanks in advance
Wolf
--
Cal Evans wrote:
>
> mysqldump products >products.sql
> grep s/products/products1/ < products.sql > products1.sql
> mysql < products1.sql
>
> Assuming that nothing else in the database is named products. (i.e. you
> don't have any fields or tables named products) If you did have fields or
> tabl
Hi all,
I begin to validate MySQL with InnoDB on our platform. I use a DBI perl
test which manages a data pool reflecting exactly the rows stored in DB.
This test internally builds some new data to insert and chooses rows to
delete and update (the tables are chosen randomly). Then all these
opera
Hi,
Here's a bit of a followup:
I've narrowed my problem down to one of our servers, the one running mySQL
3.22.27.
The server is listening to port 3306, but is taking a very long time to
respond to requests sent to that port. It seems to hang but it eventually
responds after a few minutes.
An
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query("$SELECT");
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I alrea
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query("$SELECT");
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I alrea
Hi!
I wanted to use row level locking. I modified the my.ini as follows :
#This File was made using the WinMySQLadmin 1.1 Tool
#7/10/2001 10:59:39 AM
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
innodb_data_home_dir = e:\innodb\data
set-vari
I have been trying to implement FULLTEXT indexing in a very long table with varchars
and text fields that require LIKE '%something%' a lot.
I managed to index and change all queries to use AGAINST and etc. but the users didn't
like it. They say they really need the functioning of '%text%'.
Sen
r> Seems that you are not taking advantage of Perl. This is what you can do:
No, he is taking advantage of placeholders. It is much better to use
placeholder for value substitution that substitute values directly
into query with Perl because there is no need to escape values (do you
know that $d
Hi,
I want to compress my tables but I gets an error:
C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI
Compressing wi_abbreviation.MYD: (7221 records)
- Calculating statistics
- Compressing file
myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
Aborting: wi_abbreviation.MYD i
At 12:51 10/07/2001 +0300, Leo Vanhatalo wrote:
Hi,
Did you had created manually the directories:
e:\innodb\data and e:\innodb\logs ?
because InnoDB doesn't create the directories, only the data
and logs files.
Regards,
Miguel
>Hi!
>
>I wanted to use row level locking. I modified the my.ini a
Dear Support
I notice that mysqld-nt.exe is running after I start my computer.
Firstly, I can't seem to shut it down with ' bin\mysqladmin -u root shutdown'.
Secondly, what do I do in order not to have 'mysqld-nt.exe' starting up every time I
switch on?
Thanking you.
Regards.
Russell H. Be
Bernstein Russel (extern) would like to recall the message, "mysqld-nt.exe".
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request th
Dear Support
Further to my earlier e-mail, please ignore my first request.
Thanks.
RHB
I notice that mysqld-nt.exe is running after I start my computer.
Firstly, I can't seem to shut it down with ' bin\mysqladmin -u root shutdown'.
Secondly, what do I do in order not to have 'mysqld-nt.ex
hello
I am trying to run a mysql data base on a sparc20 running solaris 2.6. The data
base loads and works fine, but
when I load Msql-Mysql-modules. I get a " Segmentation Fault - core dumped ". when I
run a cgi script from the command line the data is obtained from the data base, but
ag
Thanx Tonu.
I used the command
./configure --prefix=/usr/local/WWW/www.mydomain.com/mysql
--with-unix-socket-path=prefix=/usr/local/WWW/www.mydomain.com/mysql/.mysql.
sock
The service works perfectly when started as
bin/safe_mysqld --skip-locking --skip-networking &
I have entered the command
hi.
I had installed mysql on redhat-7.0
I have a java program that inserts, deletes from
mysql. It used to work fine.
I had to reinstall linux and hence mysql.
Now the same program doesnt work.
I get the error: "Server configuration denies access
to data source"
I can access the databases fro
Hi all,
I am entering this forum for the first time. I have Cobol and MySQL on my
Redhat Linux machine.
What drivers- if any- do I use to connect my Cobol program with MySQL? I have
heard of ACU4GL but I would like to confirm from someone here before I proceed.
Sample
Hello Denis,
Tuesday, July 10, 2001, 12:51:40 PM, you wrote:
If I'm not mistaken the problem is - conflicting transactions which
you have here. I'm really not shure INNODB dead lock detection is
quite fine graned. Also it's shurely may roll back more long running
transaction. But anyway you
Hi!
Just download and use our static binary for Linux.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www
Is it possible to join two tables from different databases that are located
on different hosts?
Thanks,
Rodney
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I'm running into an odd string size limitation. I've traced it down as far
as I can get, and I didn't run across anything in the docs or on any
searches I've run so I figured I'd try here. The field in the database is a
TEXT type column. I'm appending to the front of the text field each time
usin
Please excuse if this is a FAQ or well known effect. I'm running mySql
version 3.23.36 on a Winnt 4.0 Sp6a machine. It's connected to
a jsp page (running on resin2..0.0) through mmsql JDBC drivers.
Over a period fo days I'm seeing a build up of sleeping threads which will
eventually
meet the m
>Description:
< I have tried many times to make mysql-3.23.39 on freebsd4.3.But it
always stopped at the same point(see the below).And I even tried make it on different
machines(Crixy MII¡¢PIII),it stopped at the same point.I even can not install it by
use ports or packages-add.Wha
Well
to clear threads just type KILL "threadID".
You get the thread ID from "Show Processlist".
If the threads are sleeping it the client software that is making this
happen(JDBS)
So there are several thing to do
Change the length in MySQL that sleeping threads are closed (8h standard)...
> I just changed a column type (timestamp --> date) in PHPmyadmin, but
> when I checked the table structure in the mysql client immediately
> afterwards, it showed up with the old column type!!
> Has anyone else had something like this happen?
No. I just tested, everything ok.
> How can PHPmya
> I have a problem to insert string which is contain semicolon to mySQL Database.
Try escaping ";", i.e. use "\;" instead.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 ·
Hi,
have a look at show status,
and here for the variable
wait_uptime in seconds. How long it is.
Regards Gerlinde
At 13:54 10.07.01 +0100, Andy C wrote:
>Please excuse if this is a FAQ or well known effect. I'm running mySql
>version 3.23.36 on a Winnt 4.0 Sp6a machine. It's connected to
>a
Hi Zosen,
Looking at what you submitted, there does not seem to be an error,
it looks good to me! Do you have anything in /usr/local/bin/mysql ?
(hint: ls -l /usr/local/bin/mysql* )
Your problem description is a little vague. I have many servers
running this version installed from ports and c
I'm not sure if I understand your problem. You should get exactly
$end results if there are more in the result set. Only if you
reach the end of your loop, you will get less.
Example: You have 48 results and show them in batches of 10. Then
you should get 10, 10, 10, 10, 8 results if you show the
Hi!
I am facing a problem .It is somewhat like that.
I want to insert the 3mb data in the table column
using MYSQL as my database.
It shows the error which says that you have to
increase the 'max_allowed_packet'
packet size.
I work on windows platform.
i am unable to get the solution how i can c
> I managed to index and change all queries to use AGAINST and
> etc. but the users didn't like it. They say they really need
> the functioning of '%text%'.
Isn't it rather 'text%' ? This '%text%' you have without FULLTEXT
feature - in fact you have been using it before. Note that google
uses the
As it seems, it is not possible. You would have to have a
connection which talks to two databases at once, which may not be
possible at all, at least create numerous problems.
But I think it should be possible to create a temporary table in
db 2 and copy the table from db1 into it, then do a join
i like www.Missoulweb.com
check em out..
Ken
- Original Message -
From: "Ohannes Murat Berin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 5:12 PM
Subject: MySQL ISP
> I am searching for an ISP which has MySQL, any suggestions?
>
>
> ---
Hi!Ken Menzel
I try to initialize my datebase.but it output as the
below.What's the matter??
DateTest# ./mysql_install_db
Sorry, the host 'DateTest' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later s
What is in /etc/hosts file? My server named tuvok has this:
bash-2.04$ cat /etc/hosts
127.0.0.1 localhost.icarz.com localhost
207.99.22.16tuvok.icarz.com tuvok
207.99.22.16tuvok.icarz.com.
bash-2.04$
Your machine needs a name, there are examples in /etc/hosts
Hi everybody,
I use Replication on a windows NT4 Server.
There are 1 master and 2 slaves, all on the same machine.
One slave is started with the option skip-name-resolve, not the other.
For the 2 slaves : master-host=localhost
When adding a user (MYSQL.User), the replication is OK but,
when
> I'm running into an odd string size limitation. I've traced it down as far
> as I can get, and I didn't run across anything in the docs or on any
> searches I've run so I figured I'd try here. The field in the database is a
> TEXT type column. I'm appending to the front of the text field each ti
I am getting an error when I try to use mysqldump on a database.
/usr/local/mysql/bin/mysqldump: Can't get keys for table poll (Lost
connection to MySQL server during query)
When this happens, I get a message in the mysql error log saying the
database has been restarted.
mysqld restarted on Th
I'll give you an example: I start mysqld as such:
mysqld -O max_allowed_packet=2M
This set the option. You can do it also in my.cnf:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=16M
set-variable= max_allowed_packet=16M
set-varia
While installing mysql in a linux box (mandarake) i had this error.
Please, guys, help me out. I need to install this mysql in this box as
soon as possible :(
[root@cral mysql]# scripts/mysql_install_db
scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary
file
WARNING: The h
See my other post just a couple of minutes ago.
Sie schrieben am Dienstag, 10. Juli 2001, 15:37:29:
> Hi!
> I am facing a problem .It is somewhat like that.
> I want to insert the 3mb data in the table column
> using MYSQL as my database.
> It shows the error which says that you have to
> incre
On 2001.07.10 05:46:25 -0200 Gerlinde Fischer wrote:
> Hi,
> maybe you should use when connecting to mysql with the webserver instead
> of
> "pconnect" "connect".
> Pconnect is persistent and is staying as long as you have set
> the wait_timeout. It is set to 28800 sec by default.
>
> Regards Ger
At 14:54 09/07/2001 -0400, Khuon, Dave wrote:
Hi,
Please, read the Manual \mysql\docs\manual.html
section 8.7.2 InnoDB startup options.
Regards,
Miguel
>I recently downloaded the latest MYSQL version 2.23.39a (from page
>http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as
Please help me here, and let me know if MySQL can do it or not. All people
around me told it should work in SyBASE.
Yan Zhang
[EMAIL PROTECTED]
>>
I have two tables:
mysql> show tables;
+--+
| Tables_in_vendor
Hi!Ken Menzel
I edit the file "/etc/hosts",and make mysql-3.23.39.but it stopped at
the below point !!help me ?!!Thanks!!
-
SQLD_NET_RETRY_COUNT=100 -c convert.cc
c++ -DMYSQL_SERVER -
DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
I think the solution would be to do the "join" at the application level
rather than in the database. We frequently had to do this in msql
because it did joins so badly. Basically you do the select in the first
table including the linking field and then do selects against the second
table (th
I hit up against something like this a while ago,
but I didnt have time to debug so I used a quick hack to
get by.
Say you are storing a text article
--
| ArticleID | INT |
--
|ArticleName | TEXT |
--
I just cre
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
IBM Netfinity server [3500 records, growing by 100 a da
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
bernduser@LOCALHOST IDENTIFIED BY '1234'
But a questions:
when I have added th
Here's a clearer indication of the problem I mentioned earlier:
In the mysql client terminal output below, note how the column type of
startDate does not show up as changed from timestamp to date (even
though I had changed it earlier in phpmyadmin) until I run "Repair
Table" on the table in PH
Like you have a RPM install for Linux is there something similar that I can
use with Solaris to make the install simple with Mysql?
Thanks
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
No, MySQL does not support subquery so you need work around (not use)
it, by creating temp tbl and/or join etc. Think it a diff. SQL style.
Yan Zhang wrote:
>
> Please help me here, and let me know if MySQL can do it or not. All people
> around me told it should work in SyBASE.
>
> Yan Zhang
>
Try this assuming you are compiling from source (not ports)
create a test file called makemysql.sh
put this in it
gmake -s clean
rm config.cache
CC=gcc CFLAGS=-O3 CXX=gcc \
CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" \
./configure
$DEBUG --enable-large-files --with-berkeley-
You can use update/bin_update logs.
Run these logs from the time of the last backup and it should take you DB up
to date till the time in went down
Simon
PS update logs have all the SQL statements in them so it should be very
simple to recover!
-Original Message-
From: Pete Kuczy
At 03:01 PM 7/9/2001 -0700, you wrote:
>On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > We do a few large daily and monthly downloads from an Oracle database
> > > server. Is there a way to exclude these specific queries from the
> > > update/binary log??
> >
> > If the queries o
I'd think that someone would have to had created a 'package' for Solaris
installations, BUT, you'd have to identify which version of Solaris you
were using, and whether you're running it on a SPARC or Intel based
system
I haven't seen them on the site (you could download the source fi
Okay I can understand that I need to provide more info.
Im using a Ultra sparc II server with Solaris 8 also can you please provide
the exact link to the sunsolve website.
Thanks
Mike
-Original Message-
From: Steve Brazill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 9:30 AM
To
I have two databases (db1 e db2) on different hosts (host1 e host2). I put them
on different hosts to split the charge (they are very big databases).
However, I have to make some selects on tables of db2 filtering with information
that are on db1.
If db1 and db2 were at the same machine, I wou
Very cool.
Thaks very much Simon!
Pete
Simon Green wrote:
>
> Hi Pete
> To emable loffing use the --log option eg --log-update when stating the
> server...
>
> Simon
>
> -Original Message-
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> Sent: 10 July 2001 17:51
> To: Simon Green
>
http://www.westhost.com offers a MySQL database for only $8.95 a month.
-Kinney Baughman
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Please,help1
[sherzod@cral mysql-3.23.39]$ ./configure
loading cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking target system type... i586-pc-linux-gnu
checking build system type... i586-pc-linux-gnu
checking for a BSD compatible install... /usr/bi
Ooops, www.sunsolve.sun.com is for 'patches' for Solaris...
I meant, docs.sun.com
Here's the link to the Solaris 2.5 method of "package creation" (you can
search further for the Solaris 8 method)
http://docs.sun.com/ab2/@LegacySearchResults?toc=SUNWab_42_3%3A%2Fsafedir%2F
space3%2Fcoll2%2FSUNW
hi.
www.sunfreeware.com has a sun package that can be added via the pkgadd
utility.
hth.
-ravi.
-Original Message-
From: Mike Jimenez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:44 PM
To: Steve Brazill; Mysql
Subject: RE: Solaris
Okay I can understand that I need to pro
On Mon, Jul 09, 2001 at 08:14:24PM -0600, David Keeney wrote:
> dies (during the execute statement) with the error :
>
> Out of Memory: Killed process 31666 (temp.pl).
> Killed
Look for 'SQL_BIG_TABLES' in the Docs...
`SQL_BIG_TABLES = 0 | 1'
If set to `1', all temporary tables are stored
On 2001 Jul 10, Yan Zhang <[EMAIL PROTECTED]> wrote:
> Please help me here, and let me know if MySQL can do it or not. All people
> around me told it should work in SyBASE.
Please don't spam! Use *one* e-mail address that is appropriate.
This is on our list of things to do, probably in version
Just checked the site, and only see version 3.22.26a (very old) on the
site...
- Original Message -
From: "Ravi Raman" <[EMAIL PROTECTED]>
To: "Mike Jimenez" <[EMAIL PROTECTED]>; "Steve Brazill" <[EMAIL PROTECTED]>;
"Mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 10:24 AM
Subjec
Just wondering how many accesses can MYSQL handle... let's say per hour.
I have about 500 accesses per hour, 8 clicks per second... does anyone
know about this issue? thanks
_
Get Your Private, Free E-mail from MSN Hotmail at
On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote:
> At 03:01 PM 7/9/2001 -0700, you wrote:
> >On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote:
> > > > We do a few large daily and monthly downloads from an Oracle database
> > > > server. Is there a way to exclude these spec
Jeremy,
I did test it and couldn't get it to work one way or the otherHowever,
as it turns out, the '--binlog-ignore-db' option will work for me.
Thanks for all your help!!
Phil
At 11:03 AM 7/10/2001 -0700, you wrote:
>On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote:
> > At
Yeah I seen that too. It would be nice if it was the latest version.
Mike
-Original Message-
From: Steve Brazill [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 10:47 AM
To: Ravi Raman; Mike Jimenez; Mysql
Subject: Re: Solaris
Just checked the site, and only see version 3.22.26
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
I just did
picard:/usr/local/mysql/bin# mysqladmin version -upferdezeitung -p
Enter password:
mysqladmin Ver 8.15 D
Hey all,
This seems like a silly, but rather fundamental question. Should I have
many databases running inside one instance of Mysql with fewer tables in
each, or should have only a few databases with many tables in each (one to
many or many to one, more or less) Does is matter if the
Make sure gcc is in your PATH, and make sure it's been installed properly.
You might also want to try some test compilations.
--
Alan W. Rateliff, II: YourVillage.com
Assistant Systems Administrator : 2700 Apalachee Pkwy
< [EMAIL PROTECTED] > : Tallahassee, FL 3
Hi all,
This may not directly related to the topic but I think people in this list may
able to give me some ideas.
I am not really kean of security issue and would like to ask the following
questions:
I have 2 win2k pcs one directly connected to internet (say PC A) and PC B is
>Description:
unix_timestamp doesn't understand year 2038.
>How-To-Repeat:
this works:
select unix_timestamp("2037-12-31 23:59:59");
this doesn't:
select unix_timestamp("2038-01-01 00:00:00");
>Fix:
unknown. everything through "Jan 19 03:14:07 2038
I am not real knowledgable in this area, new to MySQL, and only an
intermediate level SQL programmer, but I was just wondering where
MySQL stands in relation to the SQL-99 standard? I notice on the
MySQL site that one of their recommended choices in books is:
SQL-99 Complete, Really
Peter Gul
it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970)
is all the seconds that fit in 2^31 or a signed long number, which is how
the timestamp was defined a long time ago, it was always figured that some
would change the base year sooner or later. Or the programmer view ;-) t
Hi,
after reading the excellent docs, I was just a little confused as to the
actual length of the TEXT datatypes. Are they really as long as you like?
And does anyone have any tips for indexing (searching) them?
Thanks,
James Cox
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
On Tue, Jul 10, 2001 at 04:15:03PM -0400, Michael Meltzer wrote:
> it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970)
> is all the seconds that fit in 2^31 or a signed long number, which is how
> the timestamp was defined a long time ago, it was always figured that some
>
You connect to a database and then issue your queries. So you
should hold all tables within one database that will be addresses
within one query.
Besides this, it is a matter of taste. Think of it this way: will
it affect performance if you put 1000 files in a directory or
just two of them and al
Hi Mark,
Thanks for the suggestion. I do realize it is better using linux
instead; however, my questions are with my setup and OS which I am currently
using, how do I go to tide up the security a bit.
Best regards,
Michael
- Original Message -
From: "md" <[EMAIL PROTECTED]>
To: "Mi
Most likely your size limitation is comming from the data type used for
'notes'. Check out the documentation for the size of the text types,
mediumtext may be more apropriate for you.
ryan
>
> I'm running into an odd string size limitation. I've traced it down as far
> as I can get, and I didn't
I was not aware of placeholders, and the benifits of using them instead of
using $dbh->quote(). It doesnt make sence that the DBI version of quote isnt
as thorough as having the code behind placeholding do it. But anyhow, I have
a few questions as to how this works. Here is an example from the Per
> after reading the excellent docs, I was just a little confused as to the
> actual length of the TEXT datatypes. Are they really as long as you like?
See http://www.mysql.com/doc/n/o/node_180.html
> And does anyone have any tips for indexing (searching) them?
What do you mean? Searching is som
I was updating a database and my database got corrupted ( I'm not sure
what coused this) but ever since then I have been having lots of mysql
problems. The onl way I can stop mysql is by doing a kill, mysqld stop
fails. I was able to restore to a backed up database but now I can not
add new items.
I understand completely and Mysql is not a database, Its a database server
that I already have multiple servers running. I asked this question because
I was curious to know if a package for Solaris exist like one Does for
Linux.
If you are just going to be sarcastic to people who ask questions on
This topic really interested me.
Can an expert of the list explain a good approach handle distributed system
with distributed databases?
thanks
siomara
>From: <[EMAIL PROTECTED]>
>To: Werner Stuerenburg <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: Join syntax
>Date: Tue, 10 Jul 200
I have not been able to stay away from syntax errors while trying to change
the char(30) to char(100) I have been using the command
alter table hr-data set column Reason4leaving1 char(100)
this is my error
syntax error near unexpected token `char(1'
can anyone set me straight?
Thanks, Jay
-
To whom it may concern:
Every thing makes, but when I do a make test I get ...
$/usr/local/bin/make test
install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so'
for module DBD::mysql: dynamic linker: /usr/bin/perl: relocation error:
symbol not found: __deregister_frame_
Title: Blank
Any body got any good through nightly
maintenance and back-up scripts?
Wyly Wade
Forefront Inc
1413 S. Howard Ave
Suite 104
Tampa Fl, 33606
813-253-2267
I'd like to see some that check current tables for corruption before
exporting, and then naming the exports by date...
On Tuesday, July 10, 2001, at 06:18 PM, Wyly Wade wrote:
> Any body got any good through nightly maintenance and back-up scripts?
>
>
> Wyly Wade
> Forefront Inc
> 1413 S.
Hi right now I am just developeing a complex listing for 500+
applications over 20 tables per catigory, that is going to be hosted on
my site. besides having the normal info such as: size, file name, datep
ublished, staff comments, program rateing I wanted to include user
opinions of it too.
I have seen a lot of question and issues around index size and time on
this list lately.
Well you should increase your Key Buffer but
Roger your record size is about 12k per row
Pawan your record size is an enormous 91k per row
You have to remember that RDBMS(for transaction processing) work
> alter table hr-data set column Reason4leaving1 char(100)
I thought I knew - but I wanted to play safe. So I went to
http://mysql.com and entered alter table to the search box.
>From the results list I chose ALTER TABLE Syntax:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Here I found what I
What you described is the strategy to design good tables, called
normalizing. You will find good articles on that subject and even
whole books. There are several rules, but most only apply the
first. The others are for the real masters or the real tough data
models or performance questions.
Sie s
> Hi,
>
> I want to compress my tables but I gets an error:
>
> C:\mysql-data\dtim9t>myisampack wi_abbreviation.MYI
> Compressing wi_abbreviation.MYD: (7221 records)
> - Calculating statistics
> - Compressing file
> myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13)
> Aborting: wi_
He wants to know the maximum, like on a search for mysql at google it says
"Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
> Just wondering how many accesses can MYSQL handle... let's say per hour.
> I have about 500 accesses per hour, 8 clicks per second... does anyone
> know about this issue? thanks
It really depends on what kind of queries you're running, your hardware,
your configuration, your operating system, e
1 - 100 of 132 matches
Mail list logo
