A file with extension .sql is an SQL set of statements. Perhaps it is the
CREATE TABLE query to create the table in MySQL.
You can open the .sql file with any trxt editor and examine the query it
contains.
HTH
Mike
- Original Message -
From: "Doug Coning" <[EMAIL PROTECTED]>
To: "MySQL
Please forgive this easy question from a newbie:
I was given a MySQL database file from a client with a .sql extension. I
already have several databases setup and running under MySQL on our server.
But how would I copy this new database over? Do I need to load it or can I
copy it as is into a d
Unless I am missing something (and that is very likely), MySQL is installed on
the "closed" Yahoo RaQ-4 Cobalt server. Now on my Linux server*, I had to go in
as root and enter a user and give what servers are allowed to access it. With
the yahoo server, the *only* access is via a Web page. Whe
- Original Message -
From: "Sherzod Ruzmetov" <[EMAIL PROTECTED]>
To: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Saturday, May 18, 2002 12:29 AM
Subject: Re: MyISAM -> Innodb
> I heard about Innodb here a lot, but where can i find more inf
Or goto http://www.innodb.com of course.
Ric.
- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Sherzod Ruzmetov" <[EMAIL PROTECTED]>
Cc: "Edilson Vasconcelos de Melo Junior" <[EMAIL PROTECTED]>; "MYSQL"
<[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 11:49 PM
Subject: Re:
Hello,
Is there a way I can do a "CHECK TABLES" which will return an exit code of
some sort, to use in a shell-script? Looking at the output of a myisamchk is
fun, but I rather have a utility too that will report an error-status that I
can use to decide whether to make a backup/restore, etc.
Tha
You have a different row for each answer because each answer has its own
INSERT. A solution would be to do a single INSERT (with quiz question
or some other data) and then for each answer do an:
UPDATE $table SET $value2='$value' WHERE id='$question_id'
You'd just have to keep track of the row
Quick little followup question:
if i have this:
for ($n = 1; $n <= $quiz[number_answers]; $n++) {
$table = $qcode."_answers";
$value = $answers["answer".$n];
$value2 = "answer".$n;
$query_alter_table = "ALTER TABLE $table ADD $value2 TEXT NOT NULL";
Hello,
Try using "NOT NULL". As weird as MySQL can be, don't think it is that
NUTty. =)
Harrison
- Original Message -
From: "Jule" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:00 PM
Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
Hey i'm getting t
Hello,
Try using "NOT NULL". As weird as MySQL can be, don't think it is that
NUTty. =)
Harrison
- Original Message -
From: "Jule" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:00 PM
Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
Hey i'm getting t
Hey i'm getting this error:
You have an error in your SQL syntax near 'NUT NULL' at line 1
when i run this query,
"ALTER TABLE $table ADD $value2 TEXT NUT NULL"
from the documentation i understood that this was the correct notation.
any ideas?
thanks
Jule
--
|\/\__/\/
In the last episode (May 17), Sherzod Ruzmetov said:
> I heard about Innodb here a lot, but where can i find more info about
> it. I search mysql manuals, but no results.
Try the mysql manual :)
Chapter "MySQL Table Types", Section "InnoDB Tables"
http://www.mysql.com/doc/I/n/InnoDB.html
--
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
Hi,
I have a lot of MyISAM table that i wanna convert ot Innodb. They don't
have any foreign keys nor BLOB or TEXT column as index. How should i do
this? Should i just "ALTER TABLE mytable TYPE=Innodb"? Is there any risk?
Thank u very much,
Edilson.
Edilson Vasconcelos de Melo Junior
[E
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
>
> Hello Alexander,
>
> your problem is near to Taylor Lewick's and I have a similar suggestion
> for you:
>
> 1) create
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
>
> Hi Ron,
>
> I suspect users.id and userid1 / userid2 have to be joined?
>
> Then:
>
> select your_desired_cols
> from
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
>
> Hello Taylor,
>
> as far as I see from the documentation and own trials you can just
> delete from table where conditio
don't forget to check the grant's!
-Original Message-
From: Dave Watkinson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 12:32 PM
To: Jack; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: How to Load a Database to other Server
not sure about the Linux guys, but if you're usi
At 10:28 AM 5/17/2002, you wrote:
>Hello,
>
>- Original Message -
>From: "Egor Egorov" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, May 17, 2002 1:42 PM
>Subject: Re: How to limit database size?
>[how to limit database size?]
> >
> > You can't do it with MySQL, use disk quot
Hi,
Consider the following schema:
Database.Users:
id
username
Database.Log:
id
userid1
userid2
entry
If I'm SELECT'ing on the Log table and I want to pull usernames out of
Users table for both users (which will most likely be unique) is there a
specific JOIN for this? Forgive me
Group,
On my unix box when I use mysql I can spawn vi and edit the sql statement or
save it out for reuse.
This feature does not appear to be present on the windows version - or did I
miss something?
Thanks.
-
Before posting,
Hi,
I'm looking for some suggestions of making a one time update to some of my
tables to make them useable with new forms and queries I'm creating. I have
a series of tables which hold related data and only the last part of the
data is stored in a final table, which means to search data based on
I don't know the answer to this in mysql, but in oracle, while you can
have big files, I've seen tables divided at, say, the 1 million record
mark. So there could be 5 files for a fast 5 million record "table".
This is seamless to the user if there are views. Alas, mysql doesn't
have views :-(.
How can I delete from a table the results of a join query..
I.e, join two tables together, get the resutls, now want to delete that data from one
of the tables...
Do I have to create a tempory table, hold the data, and delete from the one table data
matching in the temp table,
or can I just co
Told my client that dealing with Yahoo would have it's problems...they will not
do anything to the server once they wipe the disk clean and install RaQ-4 :-) !!
Thanks for the MySQL advice..
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PRO
Uhh, Hmm you probably are the owner, aren't you? (Wasn't reading that as a
server, was reading just a name)
Contact your supplier or sun directly (whomever installed the software) and
ask them for the root password for your mysql server
( default installation however does not require a password,
Hi,
Sorry, I finally found I also have to add set-variable = ft_min_word_len=3
in my.cnf.
Regards,
Jocelyn Fournier
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 16, 2002 1:58 PM
Do you want to access the whole MySQL server? Or do you just want to
administer a single database on a MySQL server?
You could contact the owners of the database server and ask them to create a
user for you to be able to connect to your MySQL database.
You do not need to be root to administer a
Just installed MySQL Manger...great!
But I cannot get into a Cobalt RaQ-4 - problem due to my inability to be root
since I can only admin the server by a Web page.
H
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Hi,
try contacting the author, phpmyadmin != mysql
Kelly Hamlin wrote:
>
> Im running MySQL 3.23.49/PHP 4.2.1/Apache 2.0.35
> I load of phpMyAdmin and i see one of my databases with a - after its name
> like its empty, but the wierd thing is, its not. I have quote a large amount
> of data in i
On Fri, 17 May 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and inc
>
> A post from the MySQL list
> MEMORY PROBLEM ... a pointers is "gone a way" ...
> The signal is SIGSEV and this mean in fact: Invalid memory
> reference.
>
> If this is a memory problem, how did it hit two servers ( several kilometers
Im running MySQL 3.23.49/PHP 4.2.1/Apache 2.0.35
I load of phpMyAdmin and i see one of my databases with a - after its name
like its empty, but the wierd thing is, its not. I have quote a large amount
of data in it and my sites all still function properly. Any idea on what
might be causing this?
t
On vendredi, mai 17, 2002, at 05:26 , Luc Foisy wrote:
> Can anyone tell me what this means??
>
> mysqld got signal 11;
[...]
(Could be) Bad RAM ?
R.
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
- Original Message -
From: "bin cai" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 10:59 AM
Subject: set connection as instance variable ( servlet and mysql)
> Hi,
> My application is about online exam with java servlet
> as tool, tomcat 3.2.3 as se
Hi. I am wanting to create an Innodb databse. I am using mysql 4.0 on unix.
Could someone send me a sample configuration file of thier /etc/.my.cnf?
I've looked at the documentation, but I always enjoy looking at something from a real
system...
Thanks,
Taylor
Taylor Lewick
Unix System Adm
Have you tried using phpMyAdmin?? It allows you to connect to several
different host quiteeasily. You can download it at:
http://www.phpwizard.net/projects/phpMyAdmin/index.html
And actually any of the
GUI front end apps for M$ should be able to connect to a remote server (I
think). You just have
Hello everyone,
I thought some folks may be interested to know that the Open Source
Development Lab (OSDL) has released a database test kit that is a
derivative of the TPC-W (http://www.tpc.org/tpcw). The kit is currently
adapted for SAP DB, but we hope that people are interested in
contributing
You might try MyCC ( available at mysql.com somewhere)
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 1:54 PM
To: [EMAIL PROTECTED]
Subject: Remote admin of MySQL from Win 2K
Is there an appl for administering MySQL on a remote Linux server from
Hi,
> -Original Message-
> From: Richard Morton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 17, 2002 4:14 AM
> To: MySQL List; Mysql Bugs; MyODBC
> Subject: FWD: RE: ECS Error with 4.0.07 opening DB (still)
> again -EMEA2490
>
>
> please see below
>
>
> -- Forwarded Mess
You need a windows client, look in www.mysql.com/downloads
graphical clients or contributed software
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: "Federico Coco" <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 3:10 PM
Subject: Re: MySql Client fails to connect
> Federic
> After installing MySql Client Version 1.75 on my Win98 Pc, I tried to
> connect to mysql database on a Linux Box.
> this is the error message
>
> Host not allowed to connect to this MySQL server.
>
> This is my configuration file
>
> user=root
> host=192.168.10.105
> port=3306
> num_of_queries=1
Hi to all,
I am using MySQL Version 4.0.1 and some of my problems are:
1) Full text search operators does not work correctly
2) The * operator does not work at all
2) Some Greek chars are returned erroneusly by the LIKE statement
3) There is not an "Exact Phrase" operator
4) Stressed chars are con
Is there an appl for administering MySQL on a remote Linux server from a Win 2K
client?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please chec
In the last episode (May 18), Patrick Hsieh said:
> Hello list,
>
> How does MySQL support iSCSI or IPSAN infrastructure?
MySQL does not care. Your OS handles access to devices. As long as
your OS can put a filesytem on it, MySQL will use it.
> Is it wise to put MySQL data in iSCSI or IPSAN
In the last episode (May 17), Brad Teale said:
> We are warehousing real-time data. The data is received at up to T1 speeds,
> and is broken up and stored into the database in approximately 25 different
> tables. Currently MySQL is doing terrific, we are using MyISAM tables and
> are storing 24
We have used the predecessor to the OTL for many of our apps and were
planning to use the OTL for the new system. I thought the OTL used ODBC to
make its connection with databases other than Oracle. I know the OTL
supports Oracle natively.
Sadly we cannot move to Linux. We managed to get our w
After installing MySql Client Version 1.75 on my Win98 Pc, I tried to
connect to mysql database on a Linux Box.
this is the error message
Host not allowed to connect to this MySQL server.
This is my configuration file
user=root
host=192.168.10.105
port=3306
num_of_queries=100
timeout=60
defbase
On Friday 17 May 2002 12:58 pm, Brad Teale wrote:
> I forgot to mention, we have Oracle in-house, and the machine the MySQL
> database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle
> databases reside on a 16 proc Sun box with 10G of RAM.
How are your apps written? We use OTL
try to restart master and see what happen
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:25 PM
Subject: RE: mysqld got signal 11;
>
> >Luc Foisy writes
You can have multiple slaves to a single master
1. You can't have multiple masters to a single slave (You can however have
multiple servers on the same computer, check the docs)
(at least in the 3.x tree)
2. The Master does not update from the slave ( I don't think looping is
permitted )
-O
I forgot to mention, we have Oracle in-house, and the machine the MySQL
database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle
databases reside on a 16 proc Sun box with 10G of RAM.
The decision to go or not go with MySQL is not based on money, it needs to
be based on performan
What version of MySQL you use ? I hope is not 3.23.4x.
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 7:25 PM
Subject: RE: mysqld got signal 11;
>
> >Lu
Brad Teale wrote:
> We are warehousing real-time data. The data is received at up to T1 speeds,
> and is broken up and stored into the database in approximately 25 different
> tables. Currently MySQL is doing terrific, we are using MyISAM tables and
> are storing 24 hours worth of data but we d
Hi,
My opinion:
If your DataBase is designed for OLTP then MySQL ver 3.23.4x with MyISAM
can be a good choice and safety.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 6:52 PM
Subject: Re: mysqld got signal 11;
> Luc,
> Friday, May 17, 2002, 6:26:19 PM, you wrote:
>
> LF> Can anyone tell me what this means??
>
> LF> mysqld got signal
>
> Da: <[EMAIL PROTECTED]>
> Data: Fri, 17 May 2002 16:30:58 CEST
> A: [EMAIL PROTECTED]
> Oggetto: Performances with BLOB fields in mySql
>
> My application (C++, mySql++, WINNT) is very time-critical and space-critical and
>use blob field.
> How can I improve performances?
> Which paramete
Can you replicate tables in MySQL version 3.23.44.
As part of a University project I wish to distribute certain tables across
the network and obviously keep the data synchronised with the original table.
Unfortunately I am limited with only one server, so to demonstrate this is it
posible t
Hello everyone,
I thought some folks may be interested to know that the Open Source
Development Lab (OSDL) has released a database test kit that is a
derivative of the TPC-W (http://www.tpc.org/tpcw). The kit is currently
adapted for SAP DB, but we hope that people are interested in
contributing
Hello list,
How does MySQL support iSCSI or IPSAN infrastructure?
Is it wise to put MySQL data in iSCSI or IPSAN storage appliance?
Any experiences appreciated.
--
Patrick Hsieh <[EMAIL PROTECTED]>
GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg
---
Compiliation Error : Official MySQL RPM
Broken Hardware : Two computers of different design at two completely
different locations, at the same time??
What did I try to do which caused SIG11 : Nothing, servers were replicating
See other message posted for other details about versions and server in
[snip]
I have a database of tickets and I want to get "the average numbers of
tickets created per agent per hour over a date range" in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS sum-per-hour
FROM remedy
WHERE (created>='2002-4-2
>Luc Foisy writes:
>> Can someone give me some clue as to what this means to me?
>>
>> mysqld got signal 11;
>> The manual section 'Debugging a MySQL server' tells you how to use a
>> stack trace and/or the core file to produce a readable backtrace that may
>> help in finding out why mysqld died
Having read the mysql release notes on replication, I am unsure whether
mysql will support the following scenario. Can anyone tell me.
1. Multiple master databases into a single slave. If this can be done, I
understand that the applications must control the update to avoid
conflicts.
2. Data bei
SELECT COUNT(DISTINCT(submitter)) AS submitters, HOUR(created) AS
hourcreated, COUNT(*) AS sum-per-hour FROM remedy WHERE
(created>='2002-4-25' AND created<='2002-04-30') GROUP BY HOUR(created);
Is this what you want?
Gurhan
-Original Message-
From: Graeme B. Davis [mailto:[EMAIL PROTEC
Hi,
My application is about online exam with java servlet
as tool, tomcat 3.2.3 as server solution , mysql 3.49
as the backend.
considering 180 students take the exam at same time
within 50 minutes, there are a lot of transactions
with database.
what i did right now is to define connection in loca
Todd,
Friday, May 17, 2002, 4:36:37 PM, you wrote:
TC> Egor -
TC> Question 1:
TC> I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp.
TC> However, it is a symbolic link.
TC> Shouldn't there be an actual file in addition to the symbolic link?
TC> Linux is very new to me
Luc,
Friday, May 17, 2002, 6:26:19 PM, you wrote:
LF> Can anyone tell me what this means??
LF> mysqld got signal 11;
LF> The manual section 'Debugging a MySQL server' tells you how to use a
LF> stack trace and/or the core file to produce a readable backtrace that may
LF> help in finding out why
Amy,
Friday, May 17, 2002, 3:41:58 PM, you wrote:
AZ> When trying to connect to mysql database i get this error message "Cant
AZ> connect to local MySQL server through socket "/tmp/mysql.sock"
Check if your MySQL is running. If yes, specify path to your socket
file with --socket option ...
AZ>
Hello Alexander,
Friday, May 17, 2002, 6:13:15 PM, you wrote:
Alexander, send your questions in mail-list!
>> You can't do it with MySQL, use disk quotas ...
AN> Thanks for your answer.
AN> What happens if a user tries to add more data to a table after the files
AN> containing his database rea
Jonas,
Friday, May 17, 2002, 4:54:18 PM, you wrote:
JO> Receive the message:
JO> "mysqlimport: Error: The used command is not
JO> allowed with this MySQL version, when using table: t_parameter."
Did you tried to use mysqlimport with --local option?
If so, you should specify local-infile for
I'm having a problem in a query that I'm trying to do.
I have a database of tickets and I want to get "the average numbers of
tickets created per agent per hour over a date range" in the format:
Hour | Avg per agent
This is what I have so far:
SELECT HOUR(created) AS hourcreated, COUNT(*) AS
A very simple question:
I have installed mysql on Windows 2000 as administrator.
I can use winmysqladmin as administrator, but I cannot
use its service as normal user - the red signal cannot
be forced to turn into green!
Holger
---
We are warehousing real-time data. The data is received at up to T1 speeds,
and is broken up and stored into the database in approximately 25 different
tables. Currently MySQL is doing terrific, we are using MyISAM tables and
are storing 24 hours worth of data but we don't have any users and we
Hi,
MEMORY PROBLEM ... a pointers is "gone a way" ...
The signal is SIGSEV and this mean in fact: Invalid memory reference.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
The database's table files will be in the data directory where all the
table files for the databases are kept. If the partition or the hard drive
where the data directory is residing on is out of space then the MySQL
server will throw an error for not having enough space ..
Gurhan
-Origin
Luc Foisy writes:
> the search query is broken
>
> Luc Foisy
>
We shall notify our web team.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\_
Hello,
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 1:42 PM
Subject: Re: How to limit database size?
[how to limit database size?]
>
> You can't do it with MySQL, use disk quotas ...
>
Thanks for your answer.
What happen
the search query is broken
Luc Foisy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
T
Can anyone tell me what this means??
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that may
help in finding out why mysqld died
Attemping backtrace. You can use the following information
Amy -
See my message and the fix for mysql.
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the
> When trying to connect to mysql database i get this error message "Cant
> connect to local MySQL server through socket "/tmp/mysql.sock"
>
> Yet I can connect through TCP/IP ~ what happened to my socket?
>
> Any suggestions?
> Thanks
> Amy
>
>
Hi all,
You surely take note that a mysql server under windows take the same
table when selecting from T_User or t_user, it is case insensitive.
Every update into these tables rename all case sensitive table into
insensitive one.
I have to be carfull to check my tables names before copying data
for mysql, if I have a text file that has the date as 5/17/2002, is there a way I can
translate that to mysql's version of the date, i.e. 2002-05-17?
With Load Data as well?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
My application (C++, mySql++, WINNT) is very time-critical and space-critical and use
blob field.
How can I improve performances?
Which parameters can I set?
There's literature about this question?
Thak's, I'm sorry for my English.
Bye, Marco
Hi!
Receive the message:
"mysqlimport: Error: The used command is not
allowed with this MySQL version, when using table: t_parameter."
What´s this??
Thanks,
/Jonas
-
Before posting, please check:
http://www.mysql.com/m
SELECT ... FROM tablename ORDER BY varcharcolumn+0;
Gurhan
-Original Message-
From: Maksim Rogov [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: Sorting a varchar field...
Hi, I am new to the list :)
Have a question, I have not been able
Hi, I am new to the list :)
Have a question, I have not been able to find any information on this on the
MySQL site.
Is it possible to sort a varchar field that contains numbers as an integer
field?
ie. right now it is sorting 1,2,4,10,11,12 as:
1
10
11
2
4
I would like to see it properly sor
Egor -
Question 1:
I located where mysql.sock is located - /var/lib/mysql/mysql.sock - NOT /tmp.
However, it is a symbolic link.
Shouldn't there be an actual file in addition to the symbolic link?
Linux is very new to me, so I am not up to speed on many of the intricacies.
Question 2:
There
Does anyone have an idea why it would take over 16 hours to drop an index on
an innodb table. The table has/had about 1.7 million records. I used the sql
query
"alter table table_name drop index index_name". I issued the command before I
left work yesterday and it was still running this morning
Hi there.
I'm looking for a BSD developer to start talks about developing on OSX.
Components:
- Darwin (Macintosh OS X Open Source)
- MySQL
- HylaFax
If anybody knows where I can find a developer to do this, I would appreciate
a quick note.
Please contact me via email.
Cheers.
@@@ Rich
When trying to connect to mysql database i get this error message "Cant
connect to local MySQL server through socket "/tmp/mysql.sock"
Yet I can connect through TCP/IP ~ what happened to my socket?
Any suggestions?
Thanks
Amy
Hi,
Let´s supose that we have a table with this features :
- about 7 records;
- only a primary index;
- about 30 fields;
- 50% of SELECTS and 50% of INSERTS/UPDATES. The SELECTS
typically uses about 3 or 4 fields in the WHERE clause.
Creating indexes, one for each field used on SELECTS, wil
My application (C++, mySql++, WINNT) is very time-critical and space-critical and use
blob field.
How can I improve performances?
Which parameters can I set?
There's literature about this question?
Thak's and excuse my English.
Bye, Marco
--
Hi!
On May 16, Jocelyn Fournier wrote:
> Hi,
>
> I don't understand, I modified ulong ft_min_word_len=3; in
> myisam/ft_static.c, and then recompiled MySQL using
> BUILD/compile-pentium --without-innodb script, but show variables still
> displays after restarting mysql :
>
> | ft_min_word_len
Hi!
On May 17, Carl J Meyer wrote:
> >Description:
> It appears that MySQL can have trouble with a searchterm
> in a boolean-mode fulltext index search which is both prefixed
> with + and suffixed with *, when that searchterm is paired
> with another required term. The empty set is returne
ally,
Friday, May 17, 2002, 1:32:42 PM, you wrote:
a> I'm very new to mysql and i really need all the help and advice from you
a> pros.
a> Well i'm trying to develop a site using chinese characters where my users
a> can login.
a> does mysql support chinese char ? if not wht shd i do... i can only
hugh,
Friday, May 17, 2002, 5:06:46 AM, you wrote:
h> Description: /usr/libexec/mysqld: error while loading shared libraries: cannot open
shared object file: cannot open shared object file: No such file or directory.
h> How-To-Repeat:
h> /usr/libexec/mysqld -u root
h> /usr/bin/s
1 - 100 of 119 matches
Mail list logo
