"Dave" <dm*******@woh.rr.com> wrote in message
news:ew********************@tornado.ohiordc.rr.com ...
Mysql3 on an fc3 box. I do not have the root password for mysqld yet i
need to copy a database let's call it database1 to database2.
There's a documentation page on resetting the root password:
http://dev.mysql.com/doc/refman/4.1/...rmissions.html
This is for a site testing purpose, it's to be an exact copy of database1,
yet the two databases do not have to be kept in sync after the copy.
I would do this by backing up the existing database using mysqldump, and
restoring the data dump to a different database, using the mysql CLI. It
could also be handy if you are doing testing, because you can use the data
dump file to reset the testing database back to its original state
repeatedly.
This page and its sub-pages talk about backing up and restoring:
http://dev.mysql.com/doc/refman/4.1/...revention.html
Regards,
Bill K.