EQEmulator Forums - Error 1356 when backing up?

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Error 1356 when backing up? (https://www.eqemulator.org/forums/showthread.php?t=35387)

Sinclipse

06-07-2012 02:04 AM

Error 1356 when backing up?

Code:

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...

Code:

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.

All times are GMT -4. The time now is 05:29 PM.