MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

How do I do a complete backup/restore of a schema with views and function?
Posted by: Kenneth Schiff
Date: January 19, 2015 06:29AM

I am trying to backup a single schema on a Windows server and restore it to an Ubuntu 12.04 Linux server running MySQL 5.5.4. The schema includes views and functions. When I used the MySQL Workbench "export" feature (including data and structure), most of the views were not imported to the new server.

Great if someone could share how to do this via Workbench, otherwise, I just need the syntax to do a complete dump from the CLI and it's restore equivalent.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How do I do a complete backup/restore of a schema with views and function?
1728
Kenneth Schiff
January 19, 2015 06:29AM
Re: How do I do a complete backup/restore of a schema with views and function?
558
Marcin Szalowicz
January 21, 2015 02:30AM
Re: How do I do a complete backup/restore of a schema with views and function?
504
Kenneth Schiff
January 21, 2015 10:20AM


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.