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
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
-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
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
Hi everyone,
Is there any easy way to duplicate a row in a table with auto increment
column, that shouldn't of course be copied. I tried a query "NSERT INTO
table SELECT * FROM table" but it caused an error due to the auto
increment column. I succeeded with listing all required fields in the
query
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.
&
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 t
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?
regards Wilbert
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http
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?
regards Wilbert
-
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
ht
IL PROTECTED]>
Sent: Saturday, September 28, 2002 10:48 PM
Subject: Copying a Table
> Hello all,
>
> I have yet to find this bit of information within the documentation. Is
it
> possible to copy the contents of a table? I
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 thi
---
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: 28 September 2002 17:19
To: [EMAIL PROTECTED]
Subject: Copying a Table
Hello all,
I have yet to find this bit of information within the documentation. Is it
possible to copy the contents of a
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
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
mysql, query
-
Before posting, please check:
http://www.mysql.com/manual.php
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
gt; > - Original Message -
> > From: "Marko Milutinoviè" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 20, 2001 8:05 AM
> > Subject: Renaming and/or copying a database
> >
> >
> > > Hi!
one on 3.23.33.
Regards,
Fred.
> - Original Message -
> From: "Marko Milutinoviè" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, March 20, 2001 8:05 AM
> Subject: Renaming and/or copying a database
>
>
> > Hi!
> >
> >
t: Tuesday, March 20, 2001 8:05 AM
Subject: Renaming and/or copying a database
> Hi!
>
> I'm running MySQL on Win NT 4. I'm trying to rename a database from my
> program, but I haven't found any inforamtion about this on the MySQL site.
> Can anybody help me?
>
Hi!
I'm running MySQL on Win NT 4. I'm trying to rename a database from my
program, but I haven't found any inforamtion about this on the MySQL site.
Can anybody help me?
Can a database named 2001 be created? Can a database be copied to another
one via SQL statements?
regards,
m@rko
---
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
Here's my situation
I've been hosting my sites with one company for over a year and am now
moving to a dedicated server operated by the same company.
My existing database is large, containing around a dozen tables and over
5,000 entries. I want to copy the database structure and data to the
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
ruary 21, 2001 1:21 PM
Subject: Copying a ddatabase from one server to another
> Here's my situation
>
> I've been hosting my sites with one company for over a year and am now
> moving to a dedicated server operated by the same company.
>
> My existing database is large,
I too am having trouble with the simple task of
copying a table. I am using 3.22.23b. I wanted to use
the create with insert but was told this isn't
supported by 3.22. So i have created the new table and
figured I would use an insert. i can't get this to
work either.
insert int
29 matches
Mail list logo