Mysql dump error Re: ERROR 1044 (42000): Access denied for user
When i tried to create the backup .sql file of database through shell with mysqldump command i got the following error:
Mysqldump error:
Re: ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'name'
This error mean that the problem with lock table into the database of that user so simply fetch the following command to resolve.
the issue..
After issue this command it will ask you the password, so provide there mysql Database password there after it will take minimum 30 min to create databse.sql file ( it's depend on database size..)# mysqldump --skip-lock-tables -u mysqluser -p password mysqldbname > mysqlfile.sql
Note: make sure that at which directory you fired this command .sql file location should be the same![]()
No comments:
Post a Comment