MySQL Forums
Forum List  »  MySQL Workbench

Backup only partly works of MySQL database
Posted by: GIDEON ISAAC
Date: August 04, 2017 03:20PM

I tried using workbench to backup my database to a file. It started off OK, as you can see by the log, but note where I put a line of exclamation marks - everything fails after that. Can anyone explain why?

09:52:57 Dumping mysql5_920666_finally (membershiptable)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmpml1lyw.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "membershiptable"
09:53:00 Dumping mysql5_920666_finally (work)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmp9na2j2.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "work"
09:53:02 Dumping mysql5_920666_finally (homepagetable)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmpgs79a6.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "homepagetable"
09:53:05 Dumping mysql5_920666_finally (slidertable)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmplgdskp.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "slidertable"
09:53:55 Dumping mysql5_920666_finally views and/or routines and/or events
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmphokfwx.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 --skip-triggers --no-data --no-create-db --no-create-info --routines --events "mysql5_920666_finally"
!!!!!
mysqldump: Couldn't execute 'show events': Access denied for user 'Flintstone'@'%' to database 'mysql5_920666_finally' (1044)

Operation failed with exitcode 2
09:53:59 Dumping mysql5_920666_finally (membershiptable)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmpj7950e.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "membershiptable"
mysqldump: Got error: 1045: Access denied for user 'Flintstone'@'47.17.179.82' (using password: NO) when trying to connect

Operation failed with exitcode 2
09:53:59 Dumping mysql5_920666_finally (work)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmpucdrzz.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "work"
09:54:00 Dumping mysql5_920666_finally (membershiptable)
Running: mysqldump.exe --defaults-file="c:\users\owner\appdata\local\temp\tmpnpiydp.cnf" --user=Flintstone --host=mysql501.discountasp.net --protocol=tcp --port=3306 --default-character-set=utf8 "mysql5_920666_finally" "membershiptable"
mysqldump: Got error: 1045: Access denied for user 'Flintstone'@'47.17.179.82' (using password: NO) when trying to connect

Operation failed with exitcode 2
Error executing task [Error 32] The process cannot access the file because it is being used by another process: u'C:\\Users\\Owner\\Documents\\dumps\\Dump20170804\\mysql5_920666_finally_membershiptable0.sql'
mysqldump: Got error: 1045: Access denied for user 'Flintstone'@'47.17.179.82' (using password: NO) when trying to connect

Operation failed with exitcode 2
Error executing task 'NoneType' object has no attribute 'name'
09:54:00 Dumping mysql5_920666_finally (membershiptable)

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup only partly works of MySQL database
49
August 04, 2017 03:20PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.