Studio Press

Just another Blogger Blog

Backup MySQL Database Safely as SQL File with SQL Yog

Database Programmer Usually Backup MySQL Database Safely as SQL File with SQL Yog. Because it was desktop software and user friendly. Backup MySQL Database Safely as SQL File with SQL Yog sometimes not safe causing by wide database.

The Backup of MySQL Database can be Safely if we don't use Bulk Insert Query, I mean a single Insert into Query to perform a inserting table.

How we do not use bulk insert in Database Backup?
Simply release check at the backup process.


This manner can reduce potential of Restore Database Error. A big size of database can cause a out of memory while using BULK Insert Statement.

A Brief Explanation of BULK SQL Insert Statement and Non BULK SQL Insert Statement
can be Found Here

0 comments:

There was an error in this gadget

Labels

Message For Me

Alexa Rank

SEO Stats

Followers

FEEDJIT Live Traffic Feed