Cable Forum - View Single Post

Bifta · 13-04-2004, 16:23

As we have some undoubted SQL genius's on here, I wondered if one of you could step up and answer this for me?

I need to backup a database table, I have a script that backs up the entire database but it's just a single table I need to export, in Excel CSV format with only the data, not the structure.

Can I use "mysqldump"? If so, what parameters would I need?

Thanks in advance.

13-04-2004, 16:23	#1
Bifta Inactive Join Date: Jul 2003 Location: Eglinton, Co. Derry Posts: 7,640	More SQL help needed As we have some undoubted SQL genius's on here, I wondered if one of you could step up and answer this for me? I need to backup a database table, I have a script that backs up the entire database but it's just a single table I need to export, in Excel CSV format with only the data, not the structure. Can I use "mysqldump"? If so, what parameters would I need? Thanks in advance.