- 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
Hi Caldi,
Can I knew what kind of table type you are using and also try to send me
the explain plan of the query execution.
I would like to know what kind of keys are being used.
Thanks & Regards,
Dilipkumar
Mobile: +91-9884430998
E-mail: dilipkumar.par...@eds.com
-Original Message-
From
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
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?
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
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 contains:
"./ibdata1: err
Well,
Maybe 70 pairs of "select into outfile" - "load data infile". At least,
this way you can select only columns you want to be in your new
database.
Best,
Mikhail Berman
-Original Message-
From: Russell Horn [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 13, 2006 12:41 PM
To: m
Hi,
It is
Rename table name to database.tablename.
db-1
db-2
rename db1.tablename to db2.tablename.
This might help you out.
murthy gandikota wrote:
How can I copy tables from one database to another on the same host?
Thanks for your help
Murthy
__
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
[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
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
Hello,
We expect to offer native support for LDAP and PAM authentication, late next
year.
Thanks,
Jimmy Guerrero, Senior Product Manager
MySQL Inc, www.mysql.com
-Original Message-
From: Sachin Bhugra [mailto:[EMAIL PROTECTED]
Sent: Friday, December 09, 2005 1:38 PM
To: mysql@lists.my
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 to me:
Your
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
Hello.
This is not a step by step instructions. But taking into an account
that you're a MySQL beginner, in my opinion, you should read some
parts of the manual:
http://dev.mysql.com/doc/mysql/en/string-functions.html
http://dev.mysql.com/doc/mysql/en/insert-select.html
ht
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
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
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 local host server and that server would have a copy of the
database. HOWEVER, o some occasions this seemed to work Ok, and on
-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
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
It should just exit unless you are using -p with mysql. In that case, if
mysqldump got an access denied, nothing would output to stdout and mysql
would be left waiting for a password.
I would try the following:
>mysqladmin -h 'other_hostname' create db_name
>mysqldump --opt db_name > dump.sql
>my
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 to know if
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
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
try
INSERT INTO other_table
( field1, field2, etc)
SELECT SQL_CALC_FOUND_ROWS *
FROM wow.resume r
INNER JOIN wow.candidate c
WHERE r.Section_ID = '1'
AND MATCH (r.Section_Value)
AGAINST ('+BAAN' IN BOOLEAN MODE)
AND c.Candidate_ID = r.Candidate_ID
Peter
> -Original Message-
> From: Eve A
are you using:
INSERT INTO
SELECT
FROM ;
I am still a relative beginner and this was the way I was taught. I have
personally never had a problem (but then I was using Oracle in school).
Respectfully,
Ligaya Turmelle
"David Blomstrom" <[EMAIL PROTECTED]> wrote in message
news:[EMAI
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
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, re
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 create new database,
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 another box where I am
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
Dan Jones unknowingly asked us:
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 data from another tab
Hey Enserink, your mail have virus!, please before sending mail please
check your machine!!!.
- Original Message -
From: "W. Enserink" <[EMAIL PROTECTED]>
Sent: Friday, August 01, 2003 8:43 AM
Subject: copying a
> Hi all,
>
>
> Im in need of some tps.
>
> I want to copy a row in a ta
Please ignore my first mail. I got the answer in next email.
Regards,
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 9:51 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: copying
use mysqldump to just dump the schema. Then edit the
PROTECTED]
Subject: Re: copying
use mysqldump to just dump the schema. Then edit the script to change the
database name and pump it back into mysql.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code
use mysqldump to just dump the schema. Then edit the script to change the
database name and pump it back into mysql.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of li
Hi Darryl,
Why not use mysqldump --no-data [database] [table1] [table2] ...
John Griffin
-Original Message-
From: Darryl Hoar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 10:49 AM
To: [EMAIL PROTECTED]
Subject: copying
Greetings,
in my last email nobody tackled the schema cop
You could try changing the priority of your inserts using INSERT LOW PRIORITY
See: http://www.mysql.com/doc/en/INSERT.html
This will give the selects priority over the inserts, as the table becomes
free, the insert will happen.
Also, look at this:
http://www.mysql.com/doc/en/Insert_speed.html
On Thu, Jan 30, 2003 at 04:13:17PM +0100, W. Enserink wrote:
> Hi all,
>
>
> Im in need of some tps.
>
> I want to copy a row in a table to a new row in the same table except for
> the unique ID. Is there some mysql statement for this?
Dear Wilbert,
INSERT ... SELECT almost allows you to d
Hi
- Original Message -
From: "W. Enserink" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 30, 2003 4:34 PM
Subject: copying a row
> Hi all,
>
>
> Im in need of some tps.
>
> I want to copy a row in a table to a new row in the same table except for
> the unique ID. Is
Hello Scott Pippin
A small mistake on myside. Everything worked fine.
Thanks for the suggestions.
regards
KayambooSuresh
- Original Message -
From: "Scott Pippin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January
from my WinNtBox.
Any suggestions?
regards
KayambooSuresh
- Original Message -
From: "Scott Pippin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, January 25, 2003 12:30 AM
Subject: Re: copying innodb data
> >I need to
>Hello folks
> I need to move my database from a WindowsNT environment to a Linux
>RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
>copying my existing tables in NT Box to Linux?
1. Download MysqlFront from
http://mysqlfront.sstienemann.de/
2. Install on Windows machine.
>I need to move my database from a WindowsNT environment to a Linux
>RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
>copying my existing tables in NT Box to Linux?
Download MySQLFront from:
http://mysqlfront.sstienemann.de/
Install it on your windows machine and log in to t
On Friday 24 January 2003 06:24, kayamboo wrote:
>I need to move my database from a WindowsNT environment to a Linux
> RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
> copying my existing tables in NT Box to Linux?
You can use mysqldump utility.
For more info check the
"Frank Peavy" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 8:09 PM
Subject: Re: Copying MySql database to others
> Stefan,
>
> >Let's say, you exported database &
Stefan,
Let's say, you exported database "my_database", and you saved the export
file as "c:\mysql\my_database_export.sql" on your QA machine. You can
import it with this command (assuming that database "my_database" exists
on your QA machine, but has no tables in it):
c:\mysql\bin> mysql -uuse
3 18:37:33 -0800
To: "Stefan Hinz, iConnect \(Berlin\)" <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]>
From: Frank Peavy <[EMAIL PROTECTED]>
Subject: Re: Copying MySql database to others
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left f
>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "Stefan Hinz, iConnect (Berlin)" <[EMAIL
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
CTED]>
Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08
I need to copy a MySql Production database to QA. What is the best method of
doing this? Do I need to write SQL queries or is there another quicker method?
From the command line?
From, within phpMyAdmin?
-
Before posting, pl
On Tue, Jan 07, 2003 at 10:41:07AM -0500, Adam Nelson wrote:
>
> If I'm getting copying to temp table often on some big queries, I
> usually increase tmp_table_size, but for innodb, is that variable
> used or is it innodb_buffer_pool_size?
I'm 63% sure it's still tmp_table_size.
--
Jeremy D. Zawo
On 20 Nov 2002, at 16:01, Steve Buehler wrote:
> Thank You. I am not sure which one is faster because I don't have any HUGE
> tables to test it on, but someone from the PHP mailing list gave me the
> following that works like a charm.
> create table table2 select * from table1
The problem with
Thank You. I am not sure which one is faster because I don't have any HUGE
tables to test it on, but someone from the PHP mailing list gave me the
following that works like a charm.
create table table2 select * from table1
Thanks
Steve
At 02:09 PM 11/20/2002 -0500, you wrote:
On 20 Nov 2002, a
On 20 Nov 2002, at 12:54, Steve Buehler wrote:
> What I am trying to do is to copy a mysql table to a new
> table name in a PHP script.
Use the query "SHOW CREATE TABLE $from_table" to get the SQL
statement for creating the table, then do
$create_table_sql = preg_replace(
Hi,
You can use :
INSERT INTO SELECT * FROM YOUR_TABLE
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: <[EMAIL P
Ed,
You could use the insert .. select syntax.
See: http://www.mysql.com/doc/en/INSERT_SELECT.html
Cheers,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:ed@;home.homes2see.com]
Sent: Thursday, 14 November 2002 18:50
To: [EMAIL PROTECTED]
Subject: Copying one table to anoth
At 15:16 -0400 10/14/02, Dennis wrote:
>At 02:51 PM 10/14/2002, you wrote:
>> > Is there a way to copy a table from one mySQL machine to another without
>>> implementing replication? The goal is be able to grab a copy of a table
>>> from some other machine (without regard to master/slave relati
At 02:51 PM 10/14/2002, you wrote:
> > Is there a way to copy a table from one mySQL machine to another without
> > implementing replication? The goal is be able to grab a copy of a table
> > from some other machine (without regard to master/slave relationships) in
> > some programmatic way withou
On Mon, 14 Oct 2002, Dennis wrote:
> Is there a way to copy a table from one mySQL machine to another without
> implementing replication? The goal is be able to grab a copy of a table
> from some other machine (without regard to master/slave relationships) in
> some programmatic way without havin
Sender: [EMAIL PROTECTED]
Date: Tue, 24 Sep 2002 08:21:20 +0200
From: Lars Heidieker <[EMAIL PROTECTED]>
on solaris it probably a good idea to change the tmp directory from /var/tmp ->
/tmp
I recalled this feature and decided to look into linux for it's
paral
Greetings...
It is possible. Say for eg. If you want to copy the structure and data of
the db table in mysql table. you can use the following statement -
create table `db_copy` ( primary key ( Host, Db, User ) ) select * from `db`
If you cant to copy only the structure then you can use a query
To where? Another table? More information is required.
- Original Message -
From: "Shaun Bramley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 28, 2002 1:18 PM
Subject: Copying a Table
> Hello all,
>
> I have yet to find this bit of information within the docum
select * from table1 insert into table2
both tables need the same structure
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
tel. 0121-242-1473
--
Check out
http://www.mysql.com/doc/en/mysqldump.html that should help you.
John Coder
On Sat, 2002-09-28 at 13:18, Shaun Bramley wrote:
> Hello all,
>
> I have yet to find this bit of information within the documentation. Is it
> possible to copy the contents of a table? If so how?
>
> Shaun
Teh,
Tuesday, September 24, 2002, 8:31:54 AM, you wrote:
TCP> Does anyone has any idea to improve this situation?
TCP> When I show my processlist, there is inner join query that having "Copying
TCP> to tmp Table" state, and it takes quite long time to finish the query. Any
TCP> idea to avoid Copy
hi,
on solaris it probably a good idee to change the tmp directory from /var/tmp ->
/tmp
as /tmp is a ram disk that gives a good performance boost if tmp tables are
involved.
The sort_buffer variable the the one to look at try increasing it, as if the
result fits into
the sort buffer no tmptable
Hi There;
I have some template tables in my SQL database that I was hoping to copy to
make
the production tables, but I have noticed that the constraints do not copy
when I create the production table using a select statement. Dows anyone
know of a way to copy the table and have the constraints c
On Mon, 24 Jun 2002, Phil Schwarzmann wrote:
> I want to copy the structure of a table to a brand new table, but I
> don't want to use phpmyadmin or some other program. I'm looking for the
> command line code.
>
> Anyone have a link to where I can find it? Or, anyone wanna send me
> the code?
At 04:06 PM 6/24/2002, you wrote:
>I want to copy the structure of a table to a brand new table, but I
>don't want to use phpmyadmin or some other program. I'm looking for the
>command line code.
>
>Anyone have a link to where I can find it? Or, anyone wanna send me
>the code?
>
>Thanks!!
>
>mys
Other than all previous comments, you can also do ,
SHOW CREATE TABLE tablename;
and then copy+paste it with a different tablename.
Gurhan
- Original Message -
From: "Phil Schwarzmann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 24, 2002 5:06 PM
Subject: copying the st
>From pg 149 of the New Riders Press book
"MySQL" by Paul DuBois (ISBN 0-7357-0921-1):
CREATE TABLE new_tbl_name SELECT * FROM tbl_name WHERE 1=0
--
Mark P. Hennessy [EMAIL PROTECTED]
On Mon, 24 Jun 2002, Phil Schwarzmann wrote:
> Date: Mon, 24 Jun
1 - 100 of 142 matches
Mail list logo
