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
-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
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,
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
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
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
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
Jeff Gannaway wrote:
> mysqldump -uUSERNAME -pPASSWORD database > dbBackup.sql
> and it created the dump file. I transferred it to the new server then
> tried to load it into my new database using the following command:
>
> mysqldump -uUSERNAME -pMILLER31 database < dbBackup.sql
Don't take
Ahhh using mysql command instead of mysqldump command to import. It
worked splendidly!
Gracias,
Jeff Gannaway
At 07:21 PM 2/21/01 -0300, Fábio Ottolini wrote:
>I just importa data created by mysqldump using
>mysql -u username -p dbname < table
>MySQL asks for my password and it's done.
>
>B
I just importa data created by mysqldump using
mysql -u username -p dbname < table
MySQL asks for my password and it's done.
BR,
Fábio Ottolini
- Original Message -
From: "Jeff Gannaway" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 1:21 PM
Subject: Copy
15 matches
Mail list logo
