al Message-
From: Brad Barnett [mailto:mysql-general-l...@l8r.net]
Sent: Friday, January 20, 2017 10:45 AM
To: mysql@lists.mysql.com
Subject: Re: io thread very slow copying binlogs
Hey Morgan,
Thanks for the tip. Might come in handy.
But, I'm positive it's not a disconnect / reco
lave and master.
> >
> > Network tests, such as:
> >
> > - using scp to copy binlogs directly
> > - using different NICs to copy binlogs
> > - using mysqlbinlog to snag logs (the most 'real' way I can think to
> > simulate the replication thread copying
x27;ve done all I can, to validate that this isn't network or disk
> > > > related.
> > > >
> > > > Disk tests (using iostat and other methods) show lots of bandwidth
> > > > left on the slave and master.
> > > >
> > > >
left on
> the slave and master.
>
> Network tests, such as:
>
> - using scp to copy binlogs directly
> - using different NICs to copy binlogs
> - using mysqlbinlog to snag logs (the most 'real' way I can think to
> simulate the replication thread copying bin
slave and master.
Network tests, such as:
- using scp to copy binlogs directly
- using different NICs to copy binlogs
- using mysqlbinlog to snag logs (the most 'real' way I can think to
simulate the replication thread copying binlogs from the master)
All seem to show that network spe
- Original Message -
> From: "bars0.bars0.bars0"
>
> Hi all!
>
> I need to copy data (result set from query) from one server to
> another.
> This will be done once a month (so cron will be involved:), for data
> from previous month.
> Any ideas how can I achieve this?
>
> Should I expor
Tom,
For MyISAM tables, as long as you aren't overlapping your update
cycles, I can see nothing wrong with this.
We used to rync to prepare slaves under inndb: do a broken rsync from
the live data files on the master to the archives.. when that is
complete, the result file is quite broken but si
i have a large myisam table (about 3gb) that is updated once a day in the
middle of the night.
when it is not being updated, is there any reason not to copy it out with
rsync without shutting down the server or flush tables with read lock or
whatever?
--
MySQL General Mailing List
For list arc
sage-
From: Carlos Eduardo Caldi [mailto:ce_ca...@hotmail.com]
Sent: Tuesday, April 28, 2009 8:19 PM
To: mysql@lists.mysql.com
Subject: Copying to tmp table
Hi friends
I have a proble with Copying to tmp table with large tables, table have
more than 3 million rows
EXPLAIN da Query :
T
Hi friends
I have a proble with Copying to tmp table with large tables, table have more
than 3 million rows
EXPLAIN da Query :
Table : log0904
Type : ref
Possible_keys :
data_login_tplig,emp_grp_login_dtlig,grp_tiporeg_tipolig_dtlig,grp_dtlig_tplig,dtlig_num
Assuming that both databases are on the same mysqld instance setting
triggers to keep the table up to date should do what you want...
On Thu, Oct 9, 2008 at 10:34 AM, Eric Anderson <[EMAIL PROTECTED]> wrote:
>
> I've got two databases Foo and Bar. Both databases have a table called
> 'zoop_t'. F
I've got two databases Foo and Bar. Both databases have a table called
'zoop_t'. Foo's is the "master" copy (i.e. the one that gets updated)
and Bar needs to be updated if/when changes are made.
Currently, I'm mysqldump'ing that table from Foo at midnight via cron
and feeding it back into
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
> > The same question just received an excellent answer from Rolando
> >Edwards about ten minutes ago. Check the archive here:
> >
> >
> >http://marc.inf
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
<[EMAIL PROTECTED]> wrote:
I'm trying to copy a database table form one database to another
on a different server. Is it possible through myphpadmin, or do I
need software? If software, do
On Mon, Mar 10, 2008 at 2:58 PM, skills2go
<[EMAIL PROTECTED]> wrote:
>
> Hi Folks
>
> I'm trying to copy a database table form one database to another on a
> different server. Is it possible through myphpadmin, or do I need software?
> If software, do you know of any good programs to do this?
Hi Folks
I'm trying to copy a database table form one database to another on a
different server. Is it possible through myphpadmin, or do I need software?
If software, do you know of any good programs to do this?
Bob
--
View this message in context:
http://www.nabble.com/Copying-t
Hi Martin,
You are correct. That's the same error that I got.
Looks like this article is the solution =>
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html
Thanks !
Feris
On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi,
>
> > > By default, InnoDB tables aren't stored in the d
Message
> > Date: Thursday, January 31, 2008 09:00:38 PM +0700
> > From: Feris Thia <[EMAIL PROTECTED]>
> > To: mysql@lists.mysql.com
> > Subject: Data folder copying problem
> >
> > Hi all,
> >
> > I have 2 database folder that being cop
Hi,
> > By default, InnoDB tables aren't stored in the database folder, but
rather
> > in it's own table space files.
> >
>
> In fact when I try to drop the database, the server "recognizes"
> innodb tables. For example, T1 and T2 are INNODB tables in database
> DB1. Then when I try to drop DB1, i
Hi Martin,
On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote:
> Hi,
>
> By default, InnoDB tables aren't stored in the database folder, but rather
> in it's own table space files.
>
In fact when I try to drop the database, the server "recognizes"
innodb tables. For example, T1 and T2 are INNOD
Hi,
> I have 2 database folder that being copied directly from a remote
> server and sent to me. That databases contains both MYISAM and INNODB
> tables.
>
> After I received the data, I try to restored it by copying that
> folders to my server. The problem is, only MYISA
Hi all,
I have 2 database folder that being copied directly from a remote
server and sent to me. That databases contains both MYISAM and INNODB
tables.
After I received the data, I try to restored it by copying that
folders to my server. The problem is, only MYISAM tables are being
recognized
Hi...
I have a situation where I want to periodically copy new rows from a source
database/tables on a remote server. Using a cron process, I'm looking to
periodically copy the new tbl/rows into the dest database on my local
server.
i don't want to get into implementing slave/master replication,
Whil Hentzen wrote:
Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without
problems.
Ack, I lied. No error in the /var/lib/mysql, but there
Baron Schwartz wrote:
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack, I lied. No error in the /var/lib/mysql, but there IS an error
file in /
Whil Hentzen wrote:
Michael Dykman wrote:
if you see no errors, check your config... are you sure InnoDB is
enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack, I lied. No error in the /var/lib/mysql, but there IS an error file
in /var/logs, and it contai
lders, and then rename the originals
back to their initial names, the server starts up nice and neat again.
I can copy a MyISAM database from the local box to the remote box and it
is accessible via the remote MySQL server just fine.
Obviously, there is something wrong in the way I'm copying th
nd neat again.
I can copy a MyISAM database from the local box to the remote box and it
is accessible via the remote MySQL server just fine.
Obviously, there is something wrong in the way I'm copying the InnoDB
files.
What am I missing?
Whil
--
MySQL General Mailing List
For lis
InnoDB HotBackup but it costs money.
http://www.innodb.com/hot-backup
-Original Message-
From: Ofer Inbar [mailto:[EMAIL PROTECTED]
Sent: 18 July 2007 00:12
To: mysql@lists.mysql.com
Subject: quickly copying a database
I've got a server with a database that's about 10G. I ne
I've got a server with a database that's about 10G. I need several
other copies of this database, with different names, on the same host
and same MySQL instance.
I could mysqldump the db and then restore it into the others...
mysql> create database one;
mysql> create database two;
...
mysqldum
13, 2006 12:41 PM
To: mysql@lists.mysql.com
Subject: Copying DB to new structure
We have a moderately sized database, more than 5GB in size, several
million rows and 70 tables.
We're running MySQL 5.22 and the database uses innodb throughout with
multiple foreign keys in use.
During dev
We have a moderately sized database, more than 5GB in size, several
million rows and 70 tables.
We're running MySQL 5.22 and the database uses innodb throughout with
multiple foreign keys in use.
During development the structure of several tables has been changed many
times, such that we now
pany. If you are not the intended recipient, an
agent of the intended recipient or a person responsible for delivering the
information to the named recipient, you are notified that any use,
distribution, transmission, printing, copying or dissemination of this
information in any way or in any ma
Perhaps the easiest way is with CREATE TABLE... SELECT. For example,
if I have a database called "NYCNH" (by coincidence, I do!) which
contains a table called "checks" and I want to copy that table to a
database called "TEST" I could do this:
mysql> create table test.checks select * from n
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[EMAIL PROTECTED] wrote:
> Hi to all!
>
> I have to transfer copy of the one table from one to other database.
> I was working with phpMyAdmin. I exported table in sql file but, when
> tried to Import it to other database I got
> Fatal error: Allowed memory size of 8388608 bytes exhausted (tried t
Hi to all!
I have to transfer copy of the one table from one to other database.
I was working with phpMyAdmin. I exported table in sql file but, when
tried to Import it to other database I got
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 806882 bytes)
Any idea how
Sorry the DROP TABLE Should be TEMP not table1
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:51 PM
To: Sachin Bhugra; mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: RE: copying data!!!
This is kind of ugly, but with the
;
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 3:00 PM
To: mysql@lists.mysql.com
Cc: [EMAIL PROTECTED]
Subject: Re: copying data!!!
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but
Check this out.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
On 12/9/05, Sachin Bhugra <[EMAIL PROTECTED]> wrote:
> Hello Friend,
>
> Can you please let me know how to copy data from a column in table A
> to a column in table B. e.g. I want to copy value of column "age" from
> table
Tnx for the reply Jimmy. I also sent another question( i know its a
very silly question for you all..but believe me i am tryin this for
past three days and not able to get it)
Pls hlp..(just give me hint in right direction, and i will try to do
the rest)
Tnx
Sachin
--
MySQL General Mailing L
@lists.mysql.com
Subject: copying data!!!
Hello Friend,
Can you please let me know how to copy data from a column in table A to a
column in table B. e.g. I want to copy value of column "age" from table 2 to
column "age" in table 1, provided the entries in column "name", wh
Hello Friend,
Can you please let me know how to copy data from a column in table A
to a column in table B. e.g. I want to copy value of column "age" from
table 2 to column "age" in table 1, provided the entries in column
"name", which is there in both the table, should match. In MySQL v 4
it cou
While the basic issue of correct syntax is still open, this issue has
boiled down to a specific error message, so I've moved to a new thread
called:
""Operand should contain 1 column" error"
However, for future reference, the issue of variables has been solved. I
discovered that to make the
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work
I made a new Query, copying the text as you wrote it, and it still
didn't work, but in a different way.
I type:
SET collation_connection = utf8_general_ci;
... and I get the following returned
Dave,
I've tried
SET collation_connection = utf8_general_ci;
on my server (4.1.14) and it seems to work so
I'm afraid I can't help you anymore there.
/Johan
Dave wrote:
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few var
My hunch here is that your ' ' in the CONCAT_WS defaults to
latin1_swedish_ci.
It seems you're right. There are a few variables that are still in
default mode which I discovered through the SHOW VARIABLES command. I've
tried to switch them, but I'm obviously using the syntax incorrectly. I
Dave,
I'm not that good when it comes to collations but latin1_swedish_ci is
normally the default collation for a MySQL installation. Have you
checked via "SHOW VARIABLES" that you don't have latin1_swedish_ci
lurking somewhere. My hunch here is that your ' ' in the CONCAT_WS
defaults to latin1_sw
Hello.
>After reading through the MySQL manuals, as suggested here, I attempted
>to construct the following statement to copy data from the table "members"
>to the table "forum_members":
Please, keep your answers on the list. Use INSERT ... SELECT. Don't put
the functions in the column lis
I think your problem is that you're trying to call one of your columns
MD5(passwd)
Thank you for pointing that out. I had the function in the wrong part of
the statement. Actually, I've realized I'm probably best off to leave
the passwords alone for now, and go ahead and copy the rest of th
Hi Dave,
I think your problem is that you're trying to call one of
your columns MD5(passwd) and my guess would be that you should do:
INSERT INTO forum_members( passwd, dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, keitai, number, admin,
cardpic, cardbio, hofpic, hofbio
After reading through the MySQL manuals, as suggested here, I attempted
to construct the following statement to copy data from the table
"members" to the table "forum_members":
INSERT INTO forum_members( MD5(passwd) , dateRegistered, realName,
ID_MEMBER, memberName, emailAddress, active, kei
gt; table uses seperate fields for first name and last name, and each is a
> VARCHAR with a length of 100. In the destination table, first and last
> names are stored in the same field, with a TINYTEXT format.
>However, despite the fact that I've looked up "combine fields&
e, I can't find instructions on how to do
that in reference to merging two fields into one, or copying from one
field to another. All the references I found are for querying the
database, combining data at the point of user input. How do I combine
two fields from one table, and put them into anot
Hello.
Think about SELECT... INTO OUTFILE and LOAD DATA INFILE (or mysqlimport
utility). If you accept the possibility to run MySQL version 5.0.x beta, you
could use FEDERATED storage engine. See:
http://dev.mysql.com/doc/mysql/en/federated-storage-engine.html
Les Schaffer <[EMAIL
On Wednesday 20 July 2005 10:06am, Les Schaffer wrote:
> I am working on a MySQL application where laptops will be collecting
> data into local MySQL tables, and then once a week they will be
> network-connected to a central server where they will "check in" their
> new data and "check out" new ass
Les Schaffer <[EMAIL PROTECTED]> wrote on 07/20/2005 12:06:46 PM:
> I am working on a MySQL application where laptops will be collecting
> data into local MySQL tables, and then once a week they will be
> network-connected to a central server where they will "check in" their
> new data and "che
I am working on a MySQL application where laptops will be collecting
data into local MySQL tables, and then once a week they will be
network-connected to a central server where they will "check in" their
new data and "check out" new assignments for data collection.
given a set of rows in a set
Yes I had thought I should use tools to copy, but I have had problems with
mysqldump. I successfully created a dump file, but when I execute this file on
an empty database I got:
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test1.txtERROR 1064 at line
54: You have an error in your SQL syntax. C
ECTED] [mailto:[EMAIL PROTECTED]
Sent: samedi 30 avril 2005 00:30
To: mysql@lists.mysql.com
Subject: Newbie Q - Re: Copying databases
I am having to operating MySQL 4.0.18, I had heared that I could copy a
db folder out of the mysql/data folder to the same folder on a different
machine running its own
before copying.
Is this a valid way to copy a db or only sometimes. Should I really always use
mysqldump. Although I am suspecting given the amount of data this may make for
a v large sql file?
Can some-one advise this newbie, thanks,
Andrew H
Hi all,
I need to move a database from a 4.0.20 MySQL server to a 4.0.17
server. I expect it will work fine when simply scp-ing the whole
/var/lib/mysql/MY-DATABASE to the other server's /var/lib/mysql
directory, with only a minor version difference.
Can anyone confirm this is going to work and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Until this version, I used to just copy the data/db directory from the
old database to the new one.
Now, I can't do that, and I think it is because of the data dictionary.
I have a database that only exists on this machine, and I want to get it
into
Mahmoud Badreddine <[EMAIL PROTECTED]> wrote on 03/17/2005 03:16:47
PM:
> Hello,
> I imported tow tables from an Access database to MySql.
> Call them table1 and table2.
>
> Both tables came with unique identifiers (ID1 for table1 and ID2 for
> table2)which were generated automatically as a reg
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular integer
index(0,1,2...N-1) for an N set of data. I would like to get rid this
ty
Well if you copy my.cnf settings along with ibdata files and log files
then it is possible to copy innodb exactly on the different machine and
i have done this before worked fine for me.
Love ..
[EMAIL PROTECTED] wrote:
InnoDB files can not be copied from one machine to another like the
MyISAM f
Ah, I see. So the tables that are represented by all
three files are presumably MyISAM files, right?
--- Victor Pendleton <[EMAIL PROTECTED]> wrote:
> InnoDB files can not be copied from one machine to
> another like the
> MyISAM files. If you did not dump the data or you do
> not have an
> a
InnoDB files can not be copied from one machine to another like the
MyISAM files. If you did not dump the data or you do not have an
archived backup you will more than likely have to recreate the table
structures.
David Blomstrom wrote:
Yikes...I've been replying to myself! I forgot that
when I
Yikes...I've been replying to myself! I forgot that
when I reply to messages from the MySQL newsgroup on
this e-mail account, it doesn't include
mysql@lists.mysql.com, for some odd reason.
At any rate, I wanted to say that I have just ONE file
type left - FRM. My MYD and MYI files have both
vanish
I've been using a preconfigured package (Apache, PHP,
MySQL) from Apache Friends/XAMPP for several months.
About a week ago, my computer crashed, and I'm now
getting back on my feet. I downloaded the latest
XAMPP, which features upgrades for PHP, phpMyAdmin and
I think MySQL, too.
Everything seems
terface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Andrew Mull [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:17 AM
To: mysql@lists.mysql.com
Subject: Copying table to another server.
Hello,
I'm having a problem with moving a database from one server
Hello,
I'm having a problem with moving a database from one server to another using
mysqldump. Since the servers are different platforms, some ascii characters
are getting corrupted.
So, my thought was to copy the table from one database to the other via the
mysql interface.
I found this onl
The rules for copying users or grant tables are the same as any other
MyISAM table and can be found in the manual. Only when the copy is
done you have to restart mysqld or issue a flush privileges; query.
On Wed, 29 Dec 2004 15:01:19 -0500, GH <[EMAIL PROTECTED]> wrote:
> I would like t
I would like to know if it is possible and how to copy my users
(passwords & priviledges etc...) from my Mandrake 10.0 / MySql 4.0
machine to my Win XP Pro/MySql 4.1 machine?
I would like to keep being able to develop the project that I am
working on while I will be away from my main computer?
-
Hello.
Like MyISAM data files, InnoDB data and log files are binary-compatible on
all platforms if the floating-point number format on the machines is the same.
You can move your database by copying all the relevant files. If the
floating-point formats on the machines are different but you
Is it possible to copy the database files (both MyISAM
and InnoDB) that contain tables, indices, and
full-text indices from one MySQL server to another
running/active MySQL server and start using them right
away?
I appreciate your help!
Homam
__
AND MATCH (r.Section_Value)
AGAINST ('+BAAN' IN BOOLEAN MODE)
AND c.Candidate_ID = r.Candidate_ID
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 1:29 PM
To: [EMAIL PROTECTED]; Mysql
Subject: RE: Copying rows based on query res
essage-
> From: Eve Atley [mailto:[EMAIL PROTECTED]
> Sent: 14 September 2004 18:18
> To: Mysql
> Subject: Copying rows based on query result to another table?
>
>
>
> I want to copy rows of data from a query result to another table. How do I
> accomplish this? Here&#x
I want to copy rows of data from a query result to another table. How do I
accomplish this? Here's my example for further explanation...
I have 2 tables, candidate and resume. I have 2 other (currently empty)
tables, exact duplicates, candidate_erp and resume_erp. In resume_erp will
be duplicates
"Mevershosting.nl" <[EMAIL PROTECTED]> wrote:
> Anyone here have any qlue ?
We had a couple of dissatisfactions trying to run MySQL on OpenBSD.
See http://bulk.fefe.de/scalability/
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensi
, (2,6 Ghz 1GB
internal mem)
The forum runs quick until somebody searches the forum, the process list
shows a item which has the: Copying to tmp table state
This takes ages, at least 200 seconds
I tested with all kinds of config in my.cnf but nothing seems to help at
all..
Now i moved the DB over
in message
news:[EMAIL PROTECTED]
> Can you run into problems when copying tables with
> foreign keys? I want to copy my Nations and States
> tables, making versions designed only to hold lengthy
> articles. I copied and coverted the States table
> successfully, but I'm running in
Can you run into problems when copying tables with
foreign keys? I want to copy my Nations and States
tables, making versions designed only to hold lengthy
articles. I copied and coverted the States table
successfully, but I'm running into problems with the
Nations table.
I get an error me
uot; <[EMAIL PROTECTED]>
Sent: Friday, May 21, 2004 10:07 PM
Subject: Re: copying longblob value to another table...
> Abubakr wrote:
> > I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of insert
s
Abubakr wrote:
> I am trying to copy a file stored in longblob column of a table to a
longblod column of another table, can any one tell me what kind of
insert statement should i use for that purpose.
You should be able to insert into your upload table with a select from
your testing table. Thi
hi,
I am trying to copy a file stored in longblob column of a table to a longblod
column of another table, can any one tell me what kind of insert statement should i
use for that purpose. 2ndly can any one tell me any built in function in mysql to
download a file from longblob column to your
I have a database that stores information in Japanese characters stored in
a blob formatted fields. I am having trouble copying these fields from one
database to another.
I tried doing a mysqldump on the table and then copyng the Insert statement
generated but that failed; the inserted filed
Egor Egorov wrote:
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise create new database, make a dump of tables
Ed Curtis <[EMAIL PROTECTED]> wrote:
>
> How would you go about copying a database? I need to make a copy with all
> the tables and names the same. I just need to name the database something
> different.
If you use only ISAM/MyISAM table, rename database directory.
Otherwise c
How would you go about copying a database? I need to make a copy with all
the tables and names the same. I just need to name the database something
different.
Thanks,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
ilto:[EMAIL PROTECTED]
> Sent: Tuesday, February 10, 2004 8:24 AM
> To: Scott Purcell
> Cc: [EMAIL PROTECTED]
> Subject: Re: copying blob data to remote box
>
>
> Are you just copying the files? I'd suggest using mysqldump if you are
> not already..
>
>
> On Tue,
PROTECTED]
Subject: Re: copying blob data to remote box
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
> Hello,
>
> I am running a DB on a machine in which I am developing on. Then I have been copying
>
Are you just copying the files? I'd suggest using mysqldump if you are
not already..
On Tue, 10 Feb 2004, Scott Purcell wrote:
> Hello,
>
> I am running a DB on a machine in which I am developing on. Then I have been copying
> the contents of ~mysql/data/databasename to anoth
Hello,
I am running a DB on a machine in which I am developing on. Then I have been copying
the contents of ~mysql/data/databasename to another box where I am running my code.
All the data I modify copies well, and I can run on my production box with no
problems. Except for binary blob data
s/columns if
you can't let them be seen. :-) Hint: use \G instead of ; at the end of
the EXPLAIN query to make the output more legible.
Matt
- Original Message -
From: "Kevin Fries"
Sent: Friday, September 05, 2003 11:09 AM
Subject: RE: Query hung up in "Copying to tm
in
> -Original Message-
> From: Matt W [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 04, 2003 1:37 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Query hung up in "Copying to tmp table"
>
>
> Hi Kevin,
>
> I imagine the query is examini
ables
(rows and MB).
Matt
- Original Message -
From: "Kevin Fries"
Sent: Wednesday, September 03, 2003 6:51 PM
Subject: Query hung up in "Copying to tmp table"
> I'm having a problem where a complex SELECT query begins eating up
lots
> of CPU and never
I'm having a problem where a complex SELECT query begins eating up lots
of CPU and never returns. In "show processlist", it
reports "Copying to tmp table". Other queries seem to get locked
waiting for this query, as well.
This is on version 3.23.36 of mySQL, and I&#
Glad that helped!
-M
- Original Message -
From: "Dan Jones" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 5:46 PM
Subject: Re: Copying distinct data to a new table
> On Thu, 2003-08-21 at 20:09, Dan
On Thu, 2003-08-21 at 20:09, Dan Jones wrote:
> I'm attempting to normalize a database that was originally created as a
> flat file. I want to extract distinct values from a table and insert
> them as new entries into a new table. Unless I'm missing something,
> INSERT doesn't allow you to SELECT
1 - 100 of 263 matches
Mail list logo
