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 (39958 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 ... (23463 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)
Notification Services
Can I schedule CSV export and import?
The CSV export and import functionality of the SQLyog GUI are not directly implemented in the SJA. But both are posible with relative simple SQL statements from 'Notification Services'.
1) export:
You can schedule and execute a "SELECT INTO OUTFILE .." statement. That will store the outfile on the machine where MySQL is running (as SELECT INTO OUTFILE has no LOCAL option in MySQL).
From MySQL docs:
http://dev.mysql.com/doc/refman/5.0/en/select.html
"Here is an example that produces a file in the comma-separated values (CSV) format used by many programs:
SELECT a,b ... INTO OUTFILE '/tmp/result.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM test_table;"
Note that the outfile must be renamed or deleted before next run. This can be done by a batch job that also calls SJA. or you may use prepared statements with 'Notification Services' to generate the file name dynamically using a timestamp for instance.
One detail to observe is that with MySQL on a Windows machine "\" characters in the file path must be escaped (as normally within strings).
This is correct: SELECT a,b INTO OUTFILE 'c:\\tmp\\result.txt' ...
and this will fail: SELECT a,b INTO OUTFILE 'c:\tmp\result.txt' ...
2) import
In quite a similar way you may schedule a LOAD DATA (LOCAL) INFILE statement with 'Notification Services'. Refer to:
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog Version History
- What kind of ODBC databases are supported by SQLyog Import External Data Tool?
- What is and what is not imported by the SQLyog Import External Data Tool?
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
Last update: 2008-09-09 15:57
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ