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
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil
