Create backup mySQL SQL 2005

Asked By fabion cole 20 points N/A Posted on - 05/21/2013

Good day for all Techyv users.

I am about to receive a lot of data out mysql SQL 2005 with my new contract in my online based job. I was advised to use backup but it cannot create valid csv. I cannot deal with any row that has a string with comma in it since strings do not express the essentials of csv and csv does not tell anything about data types.. My head bangs for this. Is there a tool that can connect both SQL and mysql server and then execute the copy? Will I find it hard to simulate a table from one database to another?

Let's say the mysql SQL 2005? I hope anybody knows such tool. It doesn’t matter what simplifications will occur as long as it will support integer and string. I need the set of data to be faster that would limit pruning and normalizing.

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

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Mcdonald Larimore 0 points N/A #165763

Create backup mySQL SQL 2005

Hi Fabion,

No need to worry, there are tools and other backup methods as well which will help you accomplish the task with ease.

“MySQL Backup Tool” is one such tool that allows you to make automated backups, manual backups and provide provisions for scheduled backup as well.

Other methods to backup include backing up with MySQLDump, using PHP to backup MySQL Database, backup via SSH etc.

More details about these methods can be found here.

About Mcdonald Larimore

Questions
0

Answers
100

Best Answers
29

• Vote Up 0 Vote Down

• Posted on - 05/22/2013
• Question Category: MySQL Server