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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MySQL

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date