The mysqldump uroot - p test_db & gt; D: \ backup access denied
Backup folder attributes have been adjusted for everyone full control
CodePudding user response:
The parameters of this is not to deny access, you didn't write complete,CodePudding user response:
Would you take a look at your mysql service in service startup account is what?
CodePudding user response:
This is I recently used commands, you can consult:
C: \ Users \ Administrator> CD C: \ Program Files \ MySQL \ MySQL Server 5.6 \ bin
C: \ Program Files \ MySQL \ MySQL Server 5.6 \ bin> The mysqldump - uroot - PWWW - P3306 world & gt; C: \ tb2. TXT
Warning: Using a password on the command line interface can be insecure.
C: \ Program Files \ MySQL \ MySQL Server 5.6 \ bin> CD c: \
C: \ & gt; More tb2. TXT
10.13 Distrib - MySQL dump 5.6.25, for Win64 (x86_64)
-
Host: localhost Database: world
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- Server version 5.6.25 - log
/*! 40101 SET @ OLD_CHARACTER_SET_CLIENT=@ @ CHARACTER_SET_CLIENT */.
/*! 40101 SET @ OLD_CHARACTER_SET_RESULTS=@ @ CHARACTER_SET_RESULTS */.
/*! 40101 SET @ OLD_COLLATION_CONNECTION=@ @ COLLATION_CONNECTION */.
/*! 40101 SET NAMES utf8 */.
/*! 40103 SET @ OLD_TIME_ZONE=@ @ TIME_ZONE */.
/*! 40103 SET TIME_ZONE='+ 00:00 */.
/*! 40014 SET @ OLD_UNIQUE_CHECKS=@ @ UNIQUE_CHECKS, UNIQUE_CHECKS=0 */.
/*! 40014 SET @ OLD_FOREIGN_KEY_CHECKS=@ @ FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/.
/*! 40101 SET @ OLD_SQL_MODE=@ @ SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */.
/*! 40111 SET @ OLD_SQL_NOTES=@ @ SQL_NOTES, SQL_NOTES=0 */.
-
- Table structure for Table ` author `
-
DROP TABLE IF the EXISTS ` author `;
/*! 40101 SET @ saved_cs_client=@ @ character_set_client */.
- More (0%),
- export tb2 world database table structure and data
C: \ & gt; The mysqldump - uroot - pwin @ channel - P3306 world tb2 & gt; C: \ tb2. TXT
Warning: Using a password on the command line interface can be insecure.
C: \ & gt;
CodePudding user response:
The original poster helloFirst try to
C: & gt; Mysql - uroot - p123456
If you can normal to enter
Welcome to the MySQL monitor. Commands end with; Or \ g.
Your MySQL connection id is 7
Server version: 5.1.58 - community MySQL community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO giant. This is free software,
And you are welcome to modify and redistribute it under the GPL v2 license
Type 'help. 'or' h \ 'for help. Type' \ c 'to clear the current input statement.
Mysql>
Can be normal to enter!
Try a database connection
The mysqldump uroot - p123456 test
If this can be most of the questions may be your output folder to do not have permission to write to you
CodePudding user response:
The original poster and stickers to genuflect is beggedCodePudding user response:
My practice is in a directory,CodePudding user response:
You should also specify the file name,CodePudding user response:
Export to specify the file name you specified is a directory