RE: Error in backing up cloud database

2013-10-02 Thread David Ortiz
Indra, Have you tried importing the backup into an empty database and seeing if that query works? Thanks, David Ortiz > Date: Tue, 1 Oct 2013 21:25:57 +0800 > Subject: Error in backing up cloud database > From: [email protected] > To: [email protected]; users@cloudstac

Re: Error in backing up cloud database

2013-10-01 Thread Indra Pramana
Dear all, We just realised that the 'template_view' is a new view introduced only on Cloudstack database version 4.2. CloudStack 4.1.1 doesn't have this. It seems that during my failed upgrade attempt last time, I did a restore of the 4.1.1 database over the existing 4.2 database (instead of over

Error in backing up cloud database

2013-10-01 Thread Indra Pramana
Dear all, I tried to perform another upgrade today with Abhinav's assistance, and right now I am not able to backup the cloud database. This is the error when doing mysqldump: root@pri-db-01:~/backup/20131001# mysqldump -u cloud -p cloud > cloudstack-backup3.sql Enter password: mysqldump: Couldn'