Hello Sinisa,
have you already found the origin of the problem ? How does the bugs get
fixed -> are they solved in patch releases or are they solved in a next
release of the MySQL server ?
Kind regards,
Ismaël
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent:
* Jenny Christy
> I wud like to know one query by which i can
> copy/create the same table from existing table.
CREATE TABLE newtable SELECT * FROM oldtable
http://www.mysql.com/doc/C/R/CREATE_TABLE.html >
--
Roger
-
Before
Hello all,
I wud like to know one query by which i can
copy/create the same table from existing table.
Rgds,
Jenny
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
-
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this SQL command, but it doesn't work right. I
get multiple permutations still.
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
That might get the correct answer for you, but it does however have an extra
field in the result (which may or may not be a problem).
cheers,
noel
filter word:mysql
Dear all,
I got problem, I want to build application with Kylix + MySql.
These problem is when this password to connection mysql Null that
application running OK,
but if i fill password then message error on Kylix "Error mapping failed',
if I click again
then message "Unable to execute query"
>Description:
The mysqlhotcopy script fails with recent versions of perl.
>How-To-Repeat:
Invoke mysqlhotcopy with perl 5.6.1. (I'm on a NetBSD box.)
The script fails, complaining it can't create the target directory.
>Fix:
In the section of the script that create
The current mysql interfaces don't support multiple servers in a
fantastic fashion -- either multiple servers on a single machine or
multiple servers on multiple machines. It may be there is no great way
to do this, but...
Sybase provides an "interfaces file" (that needs to be propagated to a
As a minor enhancement, the innodb database could look at improving its
handling of data files. Specifically:
1) Provide mechanisms to allow data and log files to be filled with
zeroes while normal operations occur,
thus minimizing downtime when the database is grown.
2) Don't store the lis
sql query
I'm using innodb tables with transactions flushed on commit, version
3.23.49. It looks to me that when binlogs are being generated (which
are required for the hotbackup feature or for replication), then group
commits are effectively disabled. Basically, there is a coarse
granulari
sql query
In version 3.23.49a when using an innodb table, "alter table" appears to
corrupt foreign key constraints. Try the following test case:
"
create table test_base (
base_id int not null,
primary key (base_id)
) type = innodb;
create table test_ref (
base_id int
In most cases, your current approach should work. However, the best way to
ensure that everything would work is to import/export since that way you
have text data which you import into any DB/version/OS. However, that would
take longer.
If you have absoultely the same environment on all the comput
Hi,
I've got a replication setup with 3.23.51 on two boxes running Mac OS X.
For some reason, ALTER TABLE statements, and DELETE FROM TABLE
statements (with no where or limit clause), don't seem to be replicated
to the slave.
Has anyone else experienced problems like this?
sql,query
--
Gabri
Hello,
I have _a lot_ of http log data to throw into a mysql db (currently over 1.5
billion rows). New data is coming in all the time, so I don't want to lock
myself into one set of big tables that are over 100 gigs each. I'd rather
arrange this data into smaller chunks, then merge the tables t
Rene:
I think a good deal depends on the size of the image files themselves. There
are a number of apps that store small files (i.e.: icons, small gif's,
etc.), which seems to make sense.
Larger files may be problematic. There was quite a discussion on this issue
here just last week ... do a sea
On Mon, 2002-07-08 at 04:42, Victoria Reznichenko wrote:
>
> What about mysqldump?
> http://www.mysql.com/doc/m/y/mysqldump.html
>
> You can make dump file of your table, copy from one server to
> another and restore table or
> mysqldump database_name table_name | mysql -hhost_name
I've been running MySQL 3.23.36 on RedHat 7.2 for several months. Recently,
I
tried moving to 3.23.49a (from MySQL rpms). I run the MySQL daemon as user
"mysql"
which exists in a NIS database. When I moved to .49a, and attempted to
start the
database, I got "Fatal error: Can't change to run as
I'm working on a simple content management system that uses PHP and
MySQL for updating a web site's text (stored in a MySQL database). (The
PHP scripts that do the updating (my stuf) live on one web server, the
actual DB data to be updated (my client's stuff) live on another.) So
far, I've onl
Hello,
With a decent database design, you won't need as many tables. Let me try:
Tables for each basic object:
(1) One table for stellar objects
(2) One table for user "comments"
(3) One table for ratings
(4) One table for "conjunctions"
(5) One table for users
Link tables:
One table to link th
Hi,
Try this :
mysql -u root -h 127.0.0.1 -p (if you have set password)
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message ---
>Description:
While attempting to build mysql with Innobase, the final link step
encounters hundreds (thousands?) of "undefined references" such as:
../innobase/srv/libsrv.a(srv0srv.o): In function `srv_get_n_threads':
/home/wbarber/flow/contrib/mysql-3.23.51/innob
I keep getting Access Denied Errors when I try to login to MySql after
running mysql_install_db script. I ran the mysql_install_db script, made
suer the mysql process is running(checked it using netstat -a), changed the
ownership on the binaries and then tried to gain access using the command:
my
Hi Frank,
Good idea, but I actually need the last value, ie
IDField Field1 Field2
1A1
2A4
3A2
4A3
5B7
6B10
7B3
8B8
9C1
10 C2
11 C
Hi!
On Jul 08, Sander Pilon wrote:
>
>
> > -Original Message-
> > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, July 08, 2002 12:53
> > To: Sander Pilon
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: MERGE & FULLTEXT, two years later.
> >
> > On Jul 08, Sander Pilon
mike0
MYI is the index's
MYD is the data
Can't think why it would suddenly grow in size.
Try the CHECK TABLE command to get more detail.
David
> -Original Message-
> From: //mikezero/ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 08, 2002 12:37 PM
> To: [EMAIL PROTECTED]
> Subject: a
Hi there
Thanks for your reply.
>check your system configuration ...
>
>just run from shell script : hostname
>and what does it show you ...
WHen i run 'hostname' i get my ip address shown to me.
>and then check your /etc/hosts and /etc/resolv.conf
my /etc/hosts has the following in it:
# D
>Description:
Several days of trying to get this package to build on Solaris 7 using gcc 3.1.
./configure --prefix=/export/home/mysql --with-unix-socket-path=/var/tmp/mysql.sock
--enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb
--with-client-ldflags=-R/usr/loc
can anyone think of a reason that the .MYD and .MYI files would
overnight grow to sizes over 5 gigs. and which file holds what data?
any help would be greatly appreciated. i included a copy of the text
returned from ls.
12 -rw-rw1 mysqlmysql8662 Sep 21 2001 track_log.fr
i use mysql on a number of different systems, all of which are sun
hardware running solaris. i compile mysql from source myself, and
create software packages using sun's utilities. i now have need on
some systems to put mysql in /usr/local and in /opt on others. i only
want to compile mysql once,
They are not SQL statements.
They are both command line tools.
You don't run them from inside the mysql client.
hlam wrote:
>I'm trying to do a backup of my DB using "mysqldump"
>and "mysqlhotcopy" but both functions are sending me an error on SQL
>syntax.
>Could someone tell me what's the cor
In the last episode (Jul 08), Philip Molter said:
> On Mon, Jul 08, 2002 at 09:38:56AM -0500, Paul DuBois wrote:
> : At 8:45 -0500 7/8/02, Philip Molter wrote:
> : >I have a MySQL server that has hit it's keyfile size limit (apparently
> : >64M). I can't believe that a value this low would be the
I've been having some problems with MySQL-4.0.1-2 on RedHat 7.2
rpms
MySQL-Max-4.0.1-2
MySQL-4.0.1-2
MySQL-shared-4.0.1-2
MySQL-devel-4.0.1-2
Occasionally the server enters into a strange state where it
will refuse to do much of anything.
Commands hang in the mysql client. Com
If I want to run a batch (shell> mysql < batch-file | more) and have the
script echoed out to the terminal as it runs so that I can more easily
locate my error(s), how can I do that? Normal operation just shows
errors and that's not enough to uniquely identify the problem in this
case, there must
hi,
you should be using the c: prompt to run command and not the mysql prompt.
Hasan
- Original Message -
From: "Horacio Lam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 7:30 PM
Subject: DB backup
> I'm trying to do a backup of my DB using mysqldump and mys
I've upgraded to MySQL 3.2.49 do I still need to pass the big-tables option
on the command line when starting MySQL.
Thanks,
Ian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Hi,
I am new to the database world, so I wanted to get some facts straight. I
have built an application which runs with MySQL. I want to distribute the
application along with the data. The target computers would also have MySQL.
I have observed that I can zip up the data directory under mySQL and
hi
Stop MySql on both servers to avoid changes to database during the move
Copy the whole directory to the new server
restart both Mysql servers
Grant permissions on new server
Done :)
HTH
Peter
---
Excellence in internet and open source software
I'm trying to do a backup of my DB using "mysqldump"
and "mysqlhotcopy" but both functions are sending me an error on SQL
syntax.
Could someone tell me what's the correct syntax for this functions.
HL
-
Net-M@sters S.A.
Plaza Credicorp Bank
Calle 50, Oficina 703
tel. (5
Hi Miles,
Could you explain the same thing with a some sample
data? I does not need to be your data. I think that
what you want to do is this but I am not sure.
Field1 Field2
A 1
A 1
A 2
A 3
B 1
B 1
B 2
C 2
C 2
C 4
C 4
When you say last do
* Erick Papadakis
> i need to set up an auto_increment field inside mysql. for various
> reasons, the maximum size is 3.
Could you say something about these reasons...?
> but i don't want this to be ONLY integers
> because that limits me until 999 numbers only.
Well... using three _bytes_, the
Hello all,
I´m sure this is a pretty basic question, but I´m quite a beginner so please
bear with me. I built a simple client with VC++ 6.0, and I´m accessing a
mySQL DB using myODBC 3.51. When trying to select a row from a table,
I use a query like that:
"SELECT * FROM datav WHERE (date_time >=
We can supply MySQL box set with manuals and releases for all supported
platforms plus some goodies. The price is £35.00 plus VAT (if
applicable) you can find details on our website at www.bpenet.net. The
price above is a concessionary price.
Michael Johnson
Managing Director
Humphrey Consulting
On Mon, Jul 08, 2002 at 09:50:43AM -0500, Dan Nelson wrote:
: In the last episode (Jul 08), Philip Molter said:
: > I have a MySQL server that has hit it's keyfile size limit
: > (apparently 64M). I can't believe that a value this low would be the
: > absolute limit, but I can't find any document
In the last episode (Jul 08), Philip Molter said:
> I have a MySQL server that has hit it's keyfile size limit
> (apparently 64M). I can't believe that a value this low would be the
> absolute limit, but I can't find any documentation about increasing
> this size. How do I do it?
The keyfile si
On Mon, Jul 08, 2002 at 09:38:56AM -0500, Paul DuBois wrote:
: At 8:45 -0500 7/8/02, Philip Molter wrote:
: >I have a MySQL server that has hit it's keyfile size limit (apparently
: >64M). I can't believe that a value this low would be the absolute
: >limit, but I can't find any documentation abo
On Mon, 8 Jul 2002 [EMAIL PROTECTED] wrote:
> Todd Cary writes:
>
> > Is there a quick and simple way to move a MySQL DB from one server to another
> > MySQL server? Can I just copy the tables?
> >
>
> for as far i know, you can just copy the directory ( DB ) from one server to
> the other.
>
At 8:45 -0500 7/8/02, Philip Molter wrote:
>I have a MySQL server that has hit it's keyfile size limit (apparently
>64M). I can't believe that a value this low would be the absolute
>limit, but I can't find any documentation about increasing this
>size. How do I do it?
What do you mean by "keyf
I'm trying to do a backup of my DB using mysqldump and mysqlhotcopy
but both fuctions are sending me an error in SQL syntax.
Could anyone tell me the correct syntax for this functions?
thanks
HL
_
Supercharge your e-mail with a 25MB Inbox, P
sql,query
No worries, problem solved.
-
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]>
Greetings everyone,
Is there any way to manipulate flat files in the same directory by using
mySQL?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
- Original Message -
From: "Oliver Six" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 6:03 AM
Subject: Re:Re: Licensing--web site is schizophrenic
> Victoria Reznichenko <[EMAIL PROTECTED]> wrote on 08.07.2002
> 12:01:01:
>
> >
> >Pa
Can anyone shed any light as to why in the following query the "tv" field
shows up twice in the returned set ? The first occurance is correct, the
second spurious one at the end is empty and is unfortunately the one my code
picks up. The tv field occurs only in the shows table.
Thanks, John
mysq
* Todd Cary
> Is there a quick and simple way to move a MySQL DB from one
> server to another MySQL server?
There are many ways to do that. How simple it is depends on a lot of
things... many people prefer to use some kind of tool, like phpMyAdmin or
MysqlFront.
http://www.phpmyadmin.net/ >
http
mysql version 3.23.50
Field kwData_wydania is of type date. As you can see, dates are different that
expected. Is this a bug?
Select ksiazka_wyd.kwId,kwData_wydania
-> from ksiazka_wyd
Hi,
I'm having trouble trying to INSERT rows into a table which has an
AUTO_INCREMENT PRIMARY KEY column plus a UNIQUE constraint on two other
columns.
For each INSERT I specify NULL for the AUTO_INCREMENT column to let the
database assign a value automatically, but I frequently get the error
My Slave stopped replicating.
SHOW SLAVE STATUS
*** 1. row ***
Master_Host: 209.217.92.34
Master_User: repslave2
Master_Port: 3306
Connect_retry: 60
Log_File: QBSLXDB1-bin.049
Pos: 56605370
On 8 Jul 2002, at 16:07, Arul <[EMAIL PROTECTED]> wrote:
> FROM
> User_Type_Details UTD,
> User_Type_Details B , Users U ,TempGeneralSearch1 T1,Users
> A LEFT JOIN Company C on (U.CompanyID = C.CompanyID) LEFT
> JOIN Expert_Info EI on (U.UserID =
IMHO you can INCREMENT only numbers . :) .
Why only three numbers ?
Anyway i'd see a solution like this :
table :
idfield [1..n]
Select (@max_number:=max(id)) from table;
Insert into table(id,field1,fieldn) values (@max+0.1,'xxx','xxx');
that's kindof solution .
- Original Message
I have a MySQL server that has hit it's keyfile size limit (apparently
64M). I can't believe that a value this low would be the absolute
limit, but I can't find any documentation about increasing this
size. How do I do it?
* Philip Molter
* Texas.net Internet
* http://www.texas.net/
* [EMAIL PR
yap . you can coopy the database file although i'd say do dump of the
database (with mysqldump) .
eventuly to make things faster drop the indexes and recreate them on the
target machine
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 08
Todd Cary writes:
> Is there a quick and simple way to move a MySQL DB from one server to another
> MySQL server? Can I just copy the tables?
>
for as far i know, you can just copy the directory ( DB ) from one server to
the other.
i've done it a couple times. and it stil works :)
> Todd
Take a dump
- Original Message -
From: "Todd Cary" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 1:38 PM
Subject: Moving a DB from one Server to another
> Is there a quick and simple way to move a MySQL DB from one server to
another
> MySQL server? Can I just
If the OS is the same on each server (including patches just to make sure)
and the MySQL version is the same, then yes, you can simply copy the "data"
directories from one server to another
Make sure you FLUSH everything first and take MySQL off-line.
-Original Message-
From: Todd Cary [
Either that, or buy a commercial MySQL License
- Original Message -
From: "Oliver Six" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 12:03 PM
Subject: Re:Re: Licensing--web site is schizophrenic
> Hi,
>
> does this mean that wheneve
On Mon, Jul 08, 2002 at 09:46:08AM +0200, Ireneusz Piasecki wrote:
> I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box,
> kernel 2.2.19.
>
> When i do ps -ax on shell, i see below
>
> 5807 ?Z 0:00 [mysqld ]
>
> this happens somtimes, but table are'nt coruppted.
Hi,
My opinion:
You can't use auto_increment in this way.For sure you must do some functions
in php to check flexibility conditions of the digits which are using for new
ID of entire row.The ID field from your table must be CHAR().
E.g:
You need 3 variables;
set @a:="";--initialize v
hi,
I am trying to build the best version of mysql on solaris 8 for Sparc.
Can anyone please recommend
1.) The best version of Mysql to use (I am told there is a payfor version with
transactions)
2.) The suggested version of GCC to use (I am using sun freewares GCC 3.1)
3.) The needed / sugge
Is there a quick and simple way to move a MySQL DB from one server to another
MySQL server? Can I just copy the tables?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA 94952
707-773-4523
[EMAIL PROTECTED]
--
Hi,
This is a good question.But who give us an clearly answer ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From:
Hi,
>
> When i do ps -ax on shell, i see below
>
> 5807 ?Z 0:00 [mysqld ]
>
> this happens somtimes, but table are'nt coruppted. I have
> checked it.
I think this is normal.
When child process exits, parent process has to 'clean that up'.
It takes some time if parent is doing some
Defryn,
Monday, July 08, 2002, 5:09:51 AM, you wrote:
D> Can anyone have a look at my join.
D> It returns errors
D> Select O.name, O.amount , P.Productname, P.price
D> From Orders AS O
D> JOIN Products AS P ON O.product=P.Productid
D> Where O.cluster= 'ANP';
D> It works fine when I use
D> Sel
adi,
Monday, July 08, 2002, 10:05:56 AM, you wrote:
a> I have a problem in php page:
a> i want to insert into mysql database value $string with newlines:
a> $string="-line1\n -line2 \n-line3";
a> $result2 = db_query("update table1 set column1= '$string' where ID =
a> '$IDcurent'") or db_die(
Chip,
Monday, July 08, 2002, 8:11:20 AM, you wrote:
CW> Where is info on exporting a table? I checked the mysql docs and the
CW> only reference to export has nothing to do with exporting a table. I
CW> want to copy a table from one server to another, should be simple
CW> enough, right?
What abou
Mike,
Saturday, July 06, 2002, 10:20:49 PM, you wrote:
M> If I do a "SELECT * from TABLE" I get all the records in the DB (as it
M> should)
M> If I do a "SELECT id from TABLE" all the id's in the table are
M> retrieved except id's 113-119 for some reason
M> To use record 117 as an example:
hello,
i hope some database guru can help me with this!
i need to set up an auto_increment field inside mysql. for various
reasons, the maximum size is 3. but i don't want this to be ONLY integers
because that limits me until 999 numbers only. since i have all
flexibility for these three digi
Hello all,
I am trying to build a relatively complex query to get the average and
standard deviation of various testing variables which ultimately will be
filtered/grouped by age and other parameters.
Item #1 shows the original query and output:
select count(Test1000.OID) as N,
avg(Accuracy) as
On Monday, 8. July 2002 12:37, Arul wrote:
> Hi All
>
> The Query below took around 175 Secs to return 22 Rows..Any way this query
> can be optimized
>
For analyzing your problem, you should send your table definition and an
output of the EXPLAIN statement.
Regards Georg
mysql, query
---
Victoria Reznichenko <[EMAIL PROTECTED]> wrote on 08.07.2002
12:01:01:
>
>Paul,
>Sunday, July 07, 2002, 11:05:18 PM, you wrote:
>
>PS> At one place on the MySQL site I see:
>
>PS> http://www.mysql.com/support/arrangements.html
>
>PS> which says the client library is under the LGPL.
>
>PS> At
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 08, 2002 12:53
> To: Sander Pilon
> Cc: [EMAIL PROTECTED]
> Subject: Re: MERGE & FULLTEXT, two years later.
>
>
> Hi!
>
> On Jul 08, Sander Pilon wrote:
> > I searched the archives and in De
Hi
I Found Group By to be a bit faster...but still it takes 30 secs to execute
a query...
What could be done..I have Indexing on almost all the tables..
-Arul
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent:
Pada Mon, 8 Jul 2002 16:07:04 +0530
"Arul" <[EMAIL PROTECTED]> menulis :
> Hi All
>
> The Query below took around 175 Secs to return 22 Rows..Any way this query
> can be optimized
try to use group by instead of distinct i usually found group by is faster ;-)
anyway ... performance of quer
Hi!
On Jul 08, Sander Pilon wrote:
> I searched the archives and in December 2000 it did 'not yet' work.
> ( http://listarchive.nextrieve.com/mysql//200012/msg00539.html )
>
> Will MERGE tables and FULLTEXT indexes work together in 4.x?
> Two-and-a-half years later?
Most probably, yes. All the
Hi All
The Query below took around 175 Secs to return 22 Rows..Any way this query
can be optimized
SELECT
Distinct(C.Company_Name) ,U.UserID , IF(U.CompanyID IS
NULL , NULL ,C.Company_Name) as Company_Name,
U.COMPANYID, U.PASSWORD,
U.INDIVIDUAL_COM
"Ireneusz Piasecki" <[EMAIL PROTECTED]> wrote on 08.07.2002 11:59:08:
>
>Hi.
>No, the log serwer.err is clear. No errors.
>mysql serwer is running from may 2002 , before i have mysql 3.23.49.
>Sometimes he also was as zombie process.
>Now a have 3.23.51. The problem still exists, system working,
Paul,
Sunday, July 07, 2002, 11:05:18 PM, you wrote:
PS> At one place on the MySQL site I see:
PS> http://www.mysql.com/support/arrangements.html
PS> which says the client library is under the LGPL.
PS> At another place I see:
PS> http://www.mysql.com/doc/C/o/Copyright.html
PS> which say
sajiddalvi,
Sunday, July 07, 2002, 8:04:02 PM, you wrote:
s> Is there a way to check which my sql user (who has logged into the database)
s> has inserted a row in a table?
s> I could add a "logged_in_user" column but that seems redundant.
Take a look at functions: USER(), SYSTEM_USER(), SESSION_
Dear all,
I got problem, I want to build application with Kylix + MySql.
These problem is when this password to connection mysql Null that
application running OK,
but if i fill password then message error on Kylix "Error mapping failed',
if I click again
then message "Unable to execute query"
Hi.
No, the log serwer.err is clear. No errors.
mysql serwer is running from may 2002 , before i have mysql 3.23.49.
Sometimes he also was as zombie process.
Now a have 3.23.51. The problem still exists, system working, so i don't
know, it is dangerous sytuation ?
regards,
Irek.
- Original
>Description
Having followed the instructions in section 5.2.8 to create a table using
LOAD
DATA INFILE *without* its indexes, the indexes are *still* created at the
end
of the LOAD DATA INFILE statement
>How-To-Repeat:
The following shell script demonstrates the problem. There are two directory
"Ireneusz Piasecki" <[EMAIL PROTECTED]> wrote on 08.07.2002 11:22:23:
>
>Hi friends.
>
> I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box,
> kernel 2.2.19.
>
> When i do ps -ax on shell, i see below
>
> 5807 ?Z 0:00 [mysqld ]
>
> this happens somtimes, but ta
Hello all,
I am trying to build a relatively complex query to get the average and
standard deviation of various testing variables which ultimately will be
filtered/grouped by age and other parameters.
Item #1 shows the original query and output:
select count(Test1000.OID) as N,
avg(Accuracy) as
Hi friends.
I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box,
kernel 2.2.19.
When i do ps -ax on shell, i see below
5807 ?Z 0:00 [mysqld ]
this happens somtimes, but table are'nt coruppted. I have checked it.
It is dangerous for my system, that se
Ben,
The description of your project is as clear as mud or as clear as
astrology in general, but it seems to me that you could put all data into
one table?
However, a bigger number of tables is no problem for MySQL. Using MyIsam
tables each table will be equivalent to 3 files. With ReiserFS you
hi guyz
im trying to save user uploaded files each with a unique name
now
1. for some strange reason this piece of code aint working :S
if (is_uploaded_file($HTTP_POST_FILES['$userfile']['$name'])) {
copy($HTTP_POST_FILES['$userfile']['$name'],"c:/tmp uploadz/");
} else {
echo "P
Hello .
situation :
mysql server on RH 7.2 (don't know what version - realy doesn't matter)
mysql server on windows 98 (don't know what version - realy doesn't matter)
three partitions :
p1 -> fat32
p2 ->fat32
p3->linux .
I want to share the database(s) between mysql on windows and mysql on lin
Hi,
Basically we have created a Software in Visual Basic.
Now the software uses mySQL on the internet as
Backend. However, our server does not allow Remote
Host Connection, which means we cannot access our
mySQL Database on the Internet by our Software on a
local client. We need the mySQL Databas
I have a problem in php page:
i want to insert into mysql database value $string with newlines:
$string="-line1\n -line2 \n-line3";
$result2 = db_query("update table1 set column1= '$string' where ID =
'$IDcurent'") or db_die();
When i try to view in a textarea control the new value from colum
Hi friends.
I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box,
kernel 2.2.19.
When i do ps -ax on shell, i see below
5807 ?Z 0:00 [mysqld ]
this happens somtimes, but table are'nt coruppted. I have checked it.
It is dangerous for my system, that server MySQL i
I have a problem in php page:
i want to insert into mysql database value $string with newlines:
$string="-line1\n -line2 \n-line3";
$result2 = db_query("update table1 set column1= '$string' where ID =
'$IDcurent'") or db_die();
When i try to view in a textarea control the new value from colum
99 matches
Mail list logo
