Hi Dan,
I cannot speak for EMS or SQLyog, but certainly with the MySQL
Administrator you create the backup files on your client PC (the PC
running the tool) and then when you restore it, you select the file from
your local PC and it sends the SQL commands required to restore the
database to the server.
If you have a dump file on the server as in your case, there are a
couple of options:
1. Copy the dump file to the 2nd server and on the 2nd server restore it
using "mysql --username=root --password < /path/to/dump_file.sql"
or
2. Connect to the 2nd server from your first box and restore the local
file: "mysql --host=<2nd server> --username=root --password <
/path/to/dump_file.sql"
Substitute the required options in the mysql command.
This is assuming a UNIX / Linux system. Windows it's the same idea,
although you could run your 3rd-party tool on your 1st server but
connect to the 2nd server - then you have access to the file directly
using your tool.
Regards,
Andy
Dan O'Keefe wrote:
Hello,
Couple of questions - experienced MSSQL developer but new to mySQL.
I have 2 servers on a local network. I did a dump from one to its
local drive, and I want to restore it to the 2nd server.
1. is it possible to do this with 3rd party tools such as SQLyog or
EMS Sql Manager? When I try to navigate to the .sql file, it is
looking at my local drives and not the drives of the server I have the
connection to.
2. If it is possible, does the .sql file have to be on the local disk
of the server I am trying to restore to, or should it work from a
mapped drive of a local network.
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
