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
181
August 04, 2017 03:20PM


Sorry, you can't reply to this topic. It has been closed.

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.