Remote connection to MySQL server...?

[Alexander Dalloz]

Am Fr, den 22.10.2004 schrieb Christopher J. Bottaro um 1:37:
>  
> > Yes, the reply by the MySQL server indicates that a connection did
> > happen and that the attempt was rejected by the MySQL server. Did you
> > really create the user using "GRANT" or "INSERT"? To be sure the new
> > permissions are read in run "FLUSH PRIVILEGES;" as root on the mysql
> > command line.
> 
> Hey that worked!  Thanks very much.

Fine :)

> This is going off topic now, but how can I copy database X from host A to
> host B.  To be more clear, I installed MySQL on machine A and I've created
> a database with a bunch of tables, etc.  Now I want to copy that database
> to machine B (which also has MySQL installed on it).

You could simply copy the database which is located under
/var/lib/mysql/. But be sure the database is not used, stop the server
before processing.

The better and recommended way is to use the tools MySQL comes with:
mysqldump

mysqldump -u root --password=secret $database >
/path_to_backup_place/$database.sql

On the other MySQL server you can then create the database and fill it
by executing mysql and importing the created $database.sql file.

Alexander


-- 
Alexander Dalloz | Enger, Germany | GPG key 1024D/ED695653 1999-07-13
Fedora GNU/Linux Core 2 (Tettnang) kernel 2.6.8-1.521smp 
Serendipity 01:39:34 up 1 day, 22:19, load average: 0.26, 0.32, 0.30 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20041022/30dc66ba/attachment-0001.sig>