t;Kopie:[EMAIL PROTECTED]
Thema:Re: transferring databases
abw wrote:
> Is it possible to zip up database directories on one server and move
> them to another server, then simply unzip them?
Yes.
> If so, once that is done, does something need to be done to mysql so
> it is aware of the databases? Is there some file that has a list of
> databases th
Hopefully this is the right list. We have multiple servers going, and one
user just set up a dedicated machine with mysql. He had about 5 databases
going on another server for months with no problem. The new server has a
different version of mysql on it. I copied the database directories over
You need to login to the mysql client program and then use the source command:
for example login with:
mysql -u root -p
once running type:
source dumpfilename.sql
If you can't do it this way, consider using an alternate GUI program like
mysql-front (mysqlfront.de). That's
Hi--
I'm trying to transfer information from a MySQL database on one server to a
MySQL database on another server.
I am using PHPMyAdmin.
For small tables in the database, no problem. I just do the dump (data and
structure) to a file. Then i either copy the contents of that file into the
'Run S
