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?
Subject
Views
Written By
Posted
MySqldump and views
3754
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.