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 ... (115266 views)
- Error no. 2003: Can't connect... (52007 views)
- Error no. 1251: "Client does not support authentication..." (48048 views)
- Error no. 1045: "Connection denied..." (41285 views)
- SQLyog Version History (39879 views)
- What is HTTP-tunneling? (29231 views)
- Error No. 2005: Unknown MySQL server host... (28280 views)
- What Is SSH and SSH-tunneling? (25455 views)
- Why are Stored Procedures not created when I import ... (23412 views)
- Do I need PHP to use SQLyog with MySQL? ... (21488 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
Can I back up more databases at one time?
Yes!
Support for this was added in the Scheduled Backup 'powertool' in SQLyog version 6.5. You can backup everything from the databases where you have SELECT privelege.
Actually there is an option to select whether the ´mysql´ database should be included in the backup or not. To put it another way: you can backup 'all data' or 'all user data' depending on what is most appropriate for you. If you are not the server administrator you should be careful about backing up and restoring the ´mysql´database (if you have the privileges required for this).
Also note that the ´Information_Schema´ database will not be backed up using neither 'all data' nor 'all user data' options. This database is a read-only database created automatically by the server. It only contains temporary tables of server 'metadata' only (= 'data about the data'), no real data. However you may specify the ´Information_Schema´ database individually for backup if you should want for some special purpose.
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- Installation and upgrading
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
Last update: 2008-05-18 06:09
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ