How about using mysqldump? I had a problem where one of my developers munched my database. Fortunately for me I setup a cron job keeping several days of mysql dumps handy (plus tape backups).
Rather than fight the dba battle (which I'm still a newbie btw) I simply dropped the tables and reimported them with the mysql client. Basically mysqldump creates a sql script that creates all your tables and inserts all the data into the tables. I did a dump of each database seperately making selective restores much easier. Should work for moving a database to another server. Give it a try :D ---------------- You could just copy over the directories (databases), and that should > work. However, to avoid possible conflicts between your old > MySQL and you new MySQL (there shouldn't be any, but....) I tried just copying them over, but that didn't seem to work. -- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe https://listman.redhat.com/mailman/listinfo/redhat-list
