MySQL Forums
Forum List  »  Backup

MySqldump and views
Posted by: Obaro Ogbo
Date: November 22, 2005 03:28AM

I backed up a database use mysqldump, and on attempting to restore using
"mysql -u user -p database_name file_name", it exited with an error, and gave me the line number. Closer inspection revealed that mysqldump had incorrectly(?) placed a view as a table. Is there any way to do a dump with views, and to correctly restore the views?

Options: ReplyQuote


Subject
Views
Written By
Posted
MySqldump and views
3690
November 22, 2005 03:28AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.