Hi All !

I did "mysqldump mydb -uroot -ppass --databases --add-locks --allow-keywords --create-options --extended-insert --routines -r file.sql"

and after that in MySQL Command Line Client "source file.sql"

After that my view was converted to an empty table.

What should I do to backup and restore my view correctly ?



Regards, Dundo.



Nobody knows how to backup and then restore views ?

MySQL version is 5.0.27, db type is InnoDB.


Regards, Dundo.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to