Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 18, 2002

Introducing SQLyog, a MySQL Front End - Page 5

By DatabaseJournal.com Staff

Backing Up/Restoring Data

Backing up and restoring data on your server makes it possible to safeguard the information in your application in case problems occur. When you create a backup, you get a copy of the current state of the database and Web files at the time of backup. Then, you can use that copy to restore the application to that state if any part of the application is lost or corrupted. SQLyog's various backup features allow you to easily backup/restore your critical data.

In the following section we will learn how to backup data in many common formats.

Data As SQL Batch Scripts - SQLyog allows you to take a backup of a database in SQL batch scripts. Click on the database in the Object Browser and select DB -> Export Database As Batch Scripts... or by pressing (Ctrl+Alt+E).


Fill in all the required details and press Export to backup your database. You can restore the backup later by using SQLyog's "Execute batch file..." option discussed later.

Data As CSV - One of the most preferred ways of exporting data of a table chosen by developers is in the CSV format. To export data from table into CSV format select the table in the Object Browser and select Table -> Export Table Data As CSV... or press (Ctrl+Alt+C).


Select the columns which you want to export data from, specify the escaping characters (pressing the Change button will popup the escaping character dialog box), give a file name and press Export. The data exported is compatible with the LOAD LOCAL INFILE option provided by MySQL.

Using MySQL's Backup Option -- Using MySQL's Backup command through SQLyog you can make a SQL level backup of a table. Select a database and select DB -> Backup Database. Select the table(s) and give the directory where you want to export data.

Similarly there are various ways to restore/import data.

Importing From a SQL Batch File -- If you have your data backed up as SQL batch scripts then you can restore it using SQLyog's Select Tools -> Execute Batch File. Give the batch file name and press Execute. SQLyog can execute a batch file of any size (limited only by your OS).


Importing From CSV - You can Import a CSV data into a table by using Table -> Import Data From CSV. Select the table, column(s) and give the escaping characters. SQLyog uses the MySQL LOAD DATA LOCAL INFILE command to import data from CSV. Therefore this option will work only with MySQL 3.23 or greater.

Using MySQL's Restore Option -- The Restore command restores the table(s) from the backup that was made with BACKUP TABLE. To restore a database select the database and select DB -> Restore Database. Next select the table(s) and specify the folder where your table(s) is backed up.

Page 6: Security Management

MySQL Archives

Latest Forum Threads
MySQL Forum
Topic By Replies Updated
MySQL in high availability and transction secure banking application klamor 1 August 28th, 10:24 AM
MySQL rollback UAL225 1 August 28th, 10:15 AM
Browsing a DB file that uses MySql finleytech 1 July 26th, 10:51 AM
php cookie won't pass variable to next page ITdevGirl 0 June 22nd, 12:13 PM