|
Home > Archive > MySQL ODBC Connector > March 2005 > The best way to transfer data to another server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
The best way to transfer data to another server
|
|
| Denis Gerasimov 2005-03-30, 9:41 am |
|
Hello list,
I have two MySQL 4.1 servers, one local and one remote. I need to transfer
database from one server to another. What actually is the best way of
handling this task?
Are there any standard MySQL tools available for doing that (I mean MySQL
Administrator/Query Browser etc.)
Best regards, Denis Gerasimov
Outsourcing Services Manager,
VEKOS, Ltd.
www.vekos.ru
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
|
|
|
|
----- Original Message -----
From: "Denis Gerasimov" <denis.gerasimov@vekos.ru>
To: "MySQL General List" <mysql@lists.mysql.com>
Sent: Wednesday, March 30, 2005 1:12 AM
Subject: The best way to transfer data to another server
>
> Hello list,
>
> I have two MySQL 4.1 servers, one local and one remote. I need to transfer
> database from one server to another. What actually is the best way of
> handling this task?
>
> Are there any standard MySQL tools available for doing that (I mean MySQL
> Administrator/Query Browser etc.)
>
It's not clear from your question whether you want to transfer the data once
only or if you want to transfer it repeatedly, perhaps daily or weekly. If
you mean the latter, you may want to look into MySQL Replication, which
enables all the changes made to the data on one server to be automatically
made to the other server as well.
I haven't used MySQL Replication but I know it exists and is documented in
the MySQL manual.
Rhino
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Denis Gerasimov 2005-03-30, 9:41 am |
|
> transfer
> MySQL
> It's not clear from your question whether you want to transfer the data
> once
> only or if you want to transfer it repeatedly, perhaps daily or weekly. If
> you mean the latter, you may want to look into MySQL Replication, which
> enables all the changes made to the data on one server to be automatically
> made to the other server as well.
Well, I need this only time to time, just for transferring data when I need.
I assume that that is a bad idea to copy db files from one server to
another. mysqldump is not an exciting option too...
But there is a simple solution when using MySQL Administrator: make backup
of desired data to SQL file, then connect to another server and restore it!
>
> I haven't used MySQL Replication but I know it exists and is documented in
> the MySQL manual.
>
> Rhino
>
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=...asimov@vekos.ru
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Dan Bolser 2005-03-30, 9:41 am |
| On Wed, 30 Mar 2005, Denis Gerasimov wrote:
>
>
>Well, I need this only time to time, just for transferring data when I need.
>
>
>I assume that that is a bad idea to copy db files from one server to
>another. mysqldump is not an exciting option too...
>
>But there is a simple solution when using MySQL Administrator: make backup
>of desired data to SQL file, then connect to another server and restore it!
The perl package 'mysqlhotcopy' looks good. I didn't try it yet.
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| SGreen@unimin.com 2005-03-30, 7:04 pm |
| --=_alternative 0060904985256FD4_=
Content-Type: text/plain; charset="US-ASCII"
My response intermixed...
"Denis Gerasimov" <denis.gerasimov@vekos.ru> wrote on 03/30/2005 09:29:00
AM:
>
of[color=darkred]
Have you looked at mysqldump and mysqlhotcopy?
[color=darkred]
data[color=darkred]
weekly. If[color=darkred]
which[color=darkred]
automatically[color=
darkred]
>
> Well, I need this only time to time, just for transferring data when I
need.
>
>
> I assume that that is a bad idea to copy db files from one server to
> another. mysqldump is not an exciting option too...
>
> But there is a simple solution when using MySQL Administrator: make
backup
> of desired data to SQL file, then connect to another server and restore
it!
That is exactly what mysqldump does for you.
[color=darkred]
>
documented in[color=darkred]
Replication would be a possible solution if you needed to keep the two
databases in synch. Since this is only a periodic update, replication is
probably overkill for this issue.
I seriously think you should check out mysqldump. For one-off or
infrequent transfers, I think it works just fine. Especially since you
already said that you think that writing the schema and data to a SQL file
was a preferable idea....
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0060904985256FD4_=--
| |
| Denis Gerasimov 2005-03-31, 7:01 am |
|
>
> Have you looked at mysqldump and mysqlhotcopy?
I know about standard mysqldump utility but I actually needed something with
GUI interface.
> backup
> it!
>
> That is exactly what mysqldump does for you.
Yes, but again it has no GUI.
> documented in
>
> Replication would be a possible solution if you needed to keep the two
> databases in synch. Since this is only a periodic update, replication is
> probably overkill for this issue.
Agree.
> I seriously think you should check out mysqldump. For one-off or
> infrequent transfers, I think it works just fine. Especially since you
> already said that you think that writing the schema and data to a SQL file
> was a preferable idea....
Yes, it is also a good idea because there is phpMyAdmin installed on the
remote server, so I can just run this SQL file with it.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|