Studio Press

Just another Blogger Blog

Backup MySQL Database With SQL Yog

After Read a Post about Safely Backup MySQL Database With SQL Yog,

Bulk SQL Statement and Non Bulk Insert Statement

and

Backup MySQL Database Safely as SQL File with SQL Yog


Below is the step by step we doing a MySQL Database backup with SQL Yog :

1. Right Click A Database

Backup MySQL, SQL Yog, Bulk Insert
Figure 1.
2. Choose Back Up Database
3. Choose Backup Options
Backup MySQL, SQL Yog, Bulk Insert
Figure 2.
4. Export and done.


The Explanation of Figure 2
  • All Check on table, stored procedure and trigger mean The backup doing all backup include table, views, stored procedure, trigger, event and function
  • Structure and Data Check mean The Backup doing a Data and Structure Backup.
  • File Name is a Must.
  • Do not Check Use Bulk Insert Statement if you have a database that has great size.

3 comments:

rumah-blogger.com said...

pertamaaxxxx...

sabirinnet.com said...

mengamankan yg keduaaxx

nice info mas, sukses ya

randy said...

Hi, Nice post thanks for sharing. Would you please consider adding an intro to my website on your next post? I will return the favor. Please email me back. Thanks!

Randy
randydavis387 at gmail.com

Gadgets

There was an error in this gadget

Labels

Message For Me

Alexa Rank

SEO Stats

Followers

FEEDJIT Live Traffic Feed