Bug #33513 how to restore back up alog with views
Submitted: 26 Dec 2007 11:27 Modified: 26 Jan 2008 13:47
Reporter: ani ani Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version: OS:Windows
Assigned to: CPU Architecture:Any
Tags: Views

[26 Dec 2007 11:27] ani ani 
Description:
Hello All
I am trying to restore database backup file having few tables and views .
Problem is when i restore backup file VIEWS are not getting restored.
Can any one tell reason

How to repeat:
creat tables and views in one test database.
create backup file 
retore backup file in another database
[26 Dec 2007 11:33] Valeriy Kravchuk 
Thank you for a problem report. How do you create a backup? With mysqldump? Please, send the exact command. Upload also a backup file. 

Do you have the same users in the other database? What command do you use to restore?
[26 Dec 2007 11:41] ani ani 
Hello Sir
Sadly i cant attach the backup file due to security reasons .
But i am using MySqlAdministrator for taking backup and restoring it.
So i am not writting any command at all
Can you help
[26 Dec 2007 12:00] ani ani 
one more thing can any one provide command promt commands for taking backup and restoring   database having tables and views
[26 Dec 2007 13:47] Valeriy Kravchuk 
What exact version of MySQL Administrator do you use?

Please, read the manual about mysqldump to backup and mysql to restore.
[27 Jan 2008 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".