Ok problem.
Upgrade from 3.23.37 to 3.23.40 on linux readhat 7.0 - using rpm
and after the uppdate I get : Cant find file ./mysql/host.frm (error: 13)
so I copied the db and run mysql_install_db, still get the same msg,
So I checked the error 13 = permission denined.
So I doublecheck tthe
What does --with-raid mean ?
It means that the mysqld has the ability to split the .MYD (datafile) intto
several datafiles (in several sub directories).
I am running MySQL on a RedHat Linux with raid disks. Should I then
use --with-raid when installing ?
No you dont. If you have a the raid
We have a database of size 10GB and its index is also
almost of the same size. Now we want this database in MYSQL.
Please let me know how we can slpit it across 3-4 hard
disks.We are using Linux 6.2
Hi there,
My self I have a machine runnig RH Linux 6.0 with a 70Gb database.
And it works
Hi,
I have a problem, my database has reached Linux Redhat 7.1
max file size. (2147483647 Bytes). Does eny one know what i
can do to make a lager database. (lager
filesystem)
Thanks
Erik Dhiin
I myself run a 300Gb database on a Linux redhat 6.0 Machine.
And it works
Hi there,
So a question
I have two tables. And i want to... (i just show you)
Table 1.
OwnerChar(30)Uniqe
FileChar(80)
OIDint(not in use yet)
Table 2.
IDintuniqe and so on
OwnerChar
NameChar
adress
Hi again,
Im looking for someone that has a win 2000 mysqld compiled with --with-raid
Any one?
Need it. And dont have any possibillity to compile it myself.
/roger
Hey there,
Im in need of of a win2000 binary with the option --with-raid,
dont have any possibillity to compile it my self... So anyone with win2000 and
the possibillity to download and recompile the source?
/roger
Hi there,
When I use C API ,mysql_query.
I got an error :
Commands out of sync; You can't run this command now
what this mean and what should I do?
You are probobly sending a query to the DB thats generates a raply, like
select for example.
What you need to do is to cath the reply with
Hi,
Anyone got a small script to store a file in a BLOB.
Nothing fancy, just so that I dont need to think that much today.
/roger
Hi again,
Ehh the script in my prev mesg,
language: C
Forgot that.
Files that will be stored is: gifs jpegs html pages etc.
/roger
Start with the speed
checkout: http://www.mysql.com/information/benchmarks.html
there you'l find som arguments...
/roger
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I would need some reasons for choosing MySQL instead of Microsoft SQL.
(beside the
Hi,
I dont know whats wrong with my mysql but when I add a column with auto_inc
(I just copied and paseted what you did) I got: Primary key cannot be NULL,
so, but I got it working So thanks anyway.
And as I always say... If something works, dont touch int.
So I wont reinstall.
/roger
Can anybody tell me if my VB5 programs can query an MySQL DataBase on a
Remote server?
If so, what should I distribute with my software?
I have done some things like that, and since VB unses standard ODBC
connections the
only thing you need to include in your dist is the MyODBC API
/roger
Sorry..
thats was realy stupid Right... it works fine now...
It wasn't the permissions, it was the filename hmm.
hahaha
:)
/roger
Because it is my.cnf, not my.cfg.
Also they need to be world readable.
roger westin wrote:
Have the same problem, nither the server
Whats the best way, any realy good space saving way to store a MD5 value?
/roger
Hi there,
Question:
Whats the Easiest way to insert an AUTO_INCREMENT column into an existing table,
the new field will take over the primary key and the index.
Try checking the section 20.16 in the manual, it helped me.
That section is titled: Problems with NULL Values
But you could use:
SELECT * FROM table WHERE title IS NULL LIMIT 1;
/roger
Hi,
I have a database which has a text field (let's name it title). The field
is NULL initially. Now I
Hi there,
Need to insert an AUTO_INC column into a table.
And yes it will be the PRIMARY KEY
Anyone done this?
/roger
Have the same problem, nither the server or any client seems to read the
my.cfg files,
they are just going on the precompiled default value.
Have tried to recomplie and alot off stuff but I always have to add
the --socket /tmp/mysql.sock
I got this problem after I installed the rpm clients and
the new one an index (got an error but after flushing the table it
had made it an index anyway)
4. add the auto_inc.
And if someone can figure that procedure out with the manual.
/roger
check the manual under ALTER TABLE
roger westin wrote:
Hi there,
Question:
Whats the Easiest way
Hi again,
Theres not much written in the manual about RAID_X but you'll find
it under CREATE TABLE
Thank you for your response (I said right?!? sorry for my little english!)
what you say is very interesting!!!
Where can I read more about RAID_TYPE ecc... (the 3° solution you said?)?
Now I'm
Hi Mario,
I think I had the same problem as you, and got som help...
You have three ways of doing this:
1. Switch to a FileSystem that supports bigger Files
2. Use MERGE, create a lot of small tables and use MERGE
in you select Querys, The manual is quit god at explaining
how to do this, but
Hi,
Got some tips and trix from some users about big tables,
-Using mysql 3.23.33
-ReadHat Linux 6.0 Kernel: 2.2.5
What I seem to must do is to get the "with-raid" to work
if a going to solve my problem, MERGE will be to complicated
to do when I have 11 diffrent Client prg working towards the DB
Hi,
Have a problem with big tables,
Cant get them over 2GB
Using mysql 3.23.33
and ReadHat Linux 6.0 Kernel: 2.2.5
Need to biuld a table atleast 70Gb so Anyone?
/roger
_
Get Your Private, Free E-mail from MSN Hotmail at
24 matches
Mail list logo