Does it protect data, having sql copy database as backup

Asked By muller muller 0 points N/A Posted on - 01/31/2013

 

Hi everyone,

We have a large customer’s database in MS access.  In recently, it is getting stuck when we work in our network, so my boss needs to make a new database for our company, we are planning to use MySQL server for develop a new database. I want to know, will it be totally protected our data with having SQL copy database as backup?

• Status: Open
• Question Views: 669
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Rubi Sharlene 0 points N/A #167073

Does it protect data, having sql copy database as backup

Hello Muller,

 

 

Yes Of course you can obtain many benefits using SQL database over Access database even as back up. Here are some advantages you will gain with SQL databases.

• You can fast search and load of pages WHEN you have a lot of data.
• You can fairly easily make backups on SQL.
• You can easily import SQL files into another database.
•  SQL is usually more secure than Access but then again it will depend on how your set up is configured. 

 

Thank you.

Rubi Sharlene

About Rubi Sharlene

Questions
0

Answers
103

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 02/04/2013
• Question Category: MySQL Server