mysql issue - making backup and resoting backup from shell
i am tring to upgrade my bbs to another board. like always, i dont like doing anything on a live production site, so i was trying to make a opy of the database to use.
i am having difficulty making the dump from the database to an sql file on the server. i tried:
mysqldump --databases phpbb2dot3 > /path/where/i/want/it/saved/
but am having problems.
i ot furstrated, so i moved on to another area, but couldnt even get an actual sql file i did have to poplate a database without the below error:
ERROR 1062: Duplicate entry
one i changed to the right db, i used:
source /path/to/sql/file
any suggestions? everything is on one server, so a database needs to be made into an sql file, then the sql file needs to populate an empty database
i even tried to learn aboutmysqlhotcopy, but it seems to be about moving from one server to another.
thx in advance for any info
