Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115398 views)
- Error no. 2003: Can't connect... (52114 views)
- Error no. 1251: "Client does not support authentication..." (48094 views)
- Error no. 1045: "Connection denied..." (41350 views)
- SQLyog Version History (39960 views)
- What is HTTP-tunneling? (29296 views)
- Error No. 2005: Unknown MySQL server host... (28370 views)
- What Is SSH and SSH-tunneling? (25497 views)
- Why are Stored Procedures not created when I import ... (23464 views)
- Do I need PHP to use SQLyog with MySQL? ... (21521 views)
Latest FAQs
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
Backup/Restore
Does the SQLyog backup tool backup MySQL ver. 5 Objects?
Yes it does!
Stored Procedures, Functions, Triggers and Views are all backed up by the SQLyog backup tool (and restored by the restore functionality). That applies to all connections types - also HTTP-tunneling.
You also have the option to deselect the backup any of the object types, if you like.
Also the partition structure of MySQL version 5.1 partitioned tables is backed up.
But please note that to backup Stored Procedures, Functions and Views the complete database must be backed up, not individual tables. Triggers however are defined as 'belonging to' a table and will be backed up with the table.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- Installation and upgrading
- Buying and Licensing SQLyog
Last update: 2005-12-05 14:56
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ