On Fri, Oct 31, 2003 at 01:45:09PM -0500, Mauro Marcellino wrote:
I currently have systems on multiple networks that are only connected via FTP.
On one network (network 1) I have replication running with one
master and one slave (Both running Windows 2000 Server)
On another network
How can I trouble shoot this, please (it happens selecting any table
from all of my DBs):
Error
SQL-query :
SHOW KEYS FROM `answers`
MySQL said:
#1017 - Can't find file: './survey/answers.frm' (errno: 13)
Ted
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Thank you Michael for your reply.
Ok, at least there is a good reason and now I too understand the reason
behind it.
I have to admit that even if I can remember having earlier read that part
you quoted I never really understood what there was written since the
logic behind this just didn't make
Hi,
This question comes up a lot. You should take a look at
http://www.mysql.com/doc/en/constraint_NOT_NULL.html. The first line
is, To be able to support easy handling of non-transactional tables,
all fields in MySQL have default values. Mysql automatically converts
missing or illegal
Description:
I'm using SuSE linux 8.2 and making a database application with Qt.
I have installed all the packages needed.
Making the application is OK.
[EMAIL PROTECTED]:~/Remind_db make
g++ -o remind .obj/remind.o .obj/main.o .obj/createCon.o .obj/moc_remind.o
-L/usr/lib/
What is the relationship between column name length, Number of columns and max
columns?
Upon creation of a table with +1700 columns (with approximately 25...30 characters per
name) I get the Too many columns ERROR.
If column names are limited to 2 characters the ERROR goes away.
The table was
What is the relationship between column name length, Number of columns
and max columns?
Upon creation of a table with +1700 columns (with approximately 25...30
characters per name) I get the Too many columns ERROR.
As a complete sidenote: WHY 1700 columns??!!
With regards,
Martijn Tonies
I run the Upsize tool and attempt to convert the database to MSSQL.
Afterwards I can see the new database in SQL, but I'm not sure what to
do next? There's a total of 7 databases that I think make up one
complete database.
-Original Message-
From: Dan Lampkin [mailto:[EMAIL PROTECTED]
Hi Mike,
From the last paragraph at
http://www.mysql.com/doc/en/Storage_requirements.html
The maximum size of a row in a MyISAM table is 65534 bytes. Each BLOB
and TEXT column accounts for only 5-9 bytes toward this size.
I assume from this that a VARCHAR(255) column (or even VARCHAR(10))
would
David Desmeules wrote:
Hi everyone,
I'm looking to execute a script directly on the server with an ODBC
application. Presently I'm using access XP (2002).
If anybody have an idea how I can do this, I'm waiting for it!
I gave this some though a while ago.
From what I understand, you *can*
Hi,
I'm setting up a machine that will have a rather heavy load on it, with
mysql that has 4 processors. It's running RedHat Linux 9.0, with a kernel
with SMP to support the multiple processors. Is there anything special I
need to do with mySQL to get it to take advantage of the multiple
You don't mention CPU type but do mention RedHat 9. Is this on 32-bit x86
hardware or something 64-bit? How do you set innodb_buffer_pool_size to anything
2GB on a 32-bit box if it is? I've got it set to 7GB on a dual Opteron box
with 8GB RAM with great results so far (in testing, go live next
Hi Richard,
Nope, since your OS can run the threads on different CPUs (unlike
FreeBSD w/o LinuxThreads for example). You just need 4+ threads
(clients) running queries at once. :-)
BTW, what kind of system? How fast are those 4 CPUs? ;-)
Matt
- Original Message -
From: Richard
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Matt, et al --
...and then Matt W said...
%
...
% is. But with VARCHAR, whenever the column is given a longer value than
% it had since being OPTIMIZEd, a link will be added to point to the part
% of the data file where the row continues. :-(
...
%
14 matches
Mail list logo