Brucebannor
06-22-2007, 10:55 AM
Hey, I'm just trying to do a simple mysqldump on a database where I have the main account sent up to username root and password is blank.. also I'd like to use the --no-data option to strictly copy the structure and start over fresh.. however when i run my mysqldump it states permission denied [backupdb].
mysqldump --username root --password="" mydatabase --no-data > mydatabase1
i also tried just leaving a space after password or omitting the --password altogether.. any suggestions to get the permissions i need to preform the dump. P.S. the root user has all of the permissions turned on inside on the user's MYSQL table. Thanks!
mysqldump --username root --password="" mydatabase --no-data > mydatabase1
i also tried just leaving a space after password or omitting the --password altogether.. any suggestions to get the permissions i need to preform the dump. P.S. the root user has all of the permissions turned on inside on the user's MYSQL table. Thanks!