Log in

View Full Version : Error 1356 when backing up?


Sinclipse
06-07-2012, 02:04 AM
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\Users\Sinclipse>mysqldump -uroot -p**** peq > c:\backup\peq_backup.sql
mysqldump: Got error: 1356: View 'peq.vwbotgroups' references invalid table(s) o
r column(s) or function(s) or definer/invoker of view lack rights to use them wh
en using LOCK TABLES

C:\Users\Sinclipse>

Blanked Password out.

Sinclipse
06-07-2012, 02:23 AM
Ah. I figured it out. I thought I had run all the 'required' updates on the SVN checkout VIA Navicat. I guess I was wrong.

Sinclipse
06-07-2012, 02:43 AM
Well I had thought I figured it out, now it's having a problem with the guild part of it...


C:\Users\Sinclipse>mysqldump -uroot -p***** peq > c:\backup\peq_backup.sql
mysqldump: Got error: 1356: View 'peq.vwguildmembers' references invalid table(s
) or column(s) or function(s) or definer/invoker of view lack rights to use them
when using LOCK TABLES

C:\Users\Sinclipse>

wolfwalkereci
06-10-2012, 03:06 PM
Hmm just ran a test
mysqldump --add-drop-table -u root -p peq account>account.sql
prompted for password
and drumped it with no issue.
I see you specified where to drop the backup but myself I just opened shell and cd into the folder where I wanted my backup. Try it that way.