Command to export MySQL database in Linux
mysqldump –uroot –proot985 –all-databases > abc.sql
ABC is the database name and the password is root985. An error is reported at this time mysqldump:got error :1045
terms of settlement:
Add double quotation marks to the password on the command line
mysqldump –uroot –p“root985” –all-databases > abc.sql
Read More:
- An error occurred when MySQL backup with mysqldump instruction in MacOS system
- mysqldump: Got error: 1016: Can’t open file: ‘./xxx.frm’ (errno: 24) when using LOCK TABLES
- 【Exception】mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table…
- Solution to error 1045 in mysqldump
- Export and import method of MySQL under Linux
- Solution to 1030 got error 28 from storage engine in MySQL
- How to solve MySQL error 1049 (42000): unknown database ‘database’
- MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
- An error is reported when kettle connects Oracle database and MySQL database
- Import / export. SQL file / gzip file for MySQL under Linux
- (error when importing database): MySQL 2006-mysql server has gone away
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- Pikachu vulnerability is installed in the shooting range, and an error is reported when connecting to the MySQL database
- PHP connection to MySQL database error: call to undefined function MySQL_ connect()
- Mysql Error:The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
- django.core.exceptions . improveconfigured: error loading MySQL DB module. Django configuring MySQL database
- Solve MySQL installation error: initializing database prompts an error when installing mysql
- Mysql database error (communications link failure)
- How to view the version of MySQL database
- Solutions to problems in SAS 9.3 x64 importing and exporting Excel