> How about using mysqldump?

> Just can't seem to figure it out...


>> Should work for moving a database to another server.  Give it a try :D

Sounds like you are missing a step.  Here is what I did.

/PATH_TO_MYSQL/bin/mysqldump -u root --password=ROOT_PASSWORD DATABASE_NAME
> /backup/hotbackup/backup-DATABASE_NAME.sql

This will copy your database into an sql script.  Take that script and run
"mysql -u root -p < backup-DATABASE_NAME.sql"

You will be asked for your password (your mysql password btw).  After
entering it wait a few moments.  Depending how big your database is it
should populate your database.  I believe I had to create the empty database
first then run the script.  Been awhile since I've done it :-)

We had recovered from a database crash thanks to these tools.  



-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]?subject=unsubscribe
https://listman.redhat.com/mailman/listinfo/redhat-list

Reply via email to