Re: After backup/restore view turns to table

2007-01-24 Thread Davor Dundovic
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

After backup/restore view turns to table

2007-01-23 Thread Davor Dundovic
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 r