More SQL help needed

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.

MikeyB · 13-04-2004, 16:48

Hiya,

Is this a MySQL question (as you mention "mysqldump") or MS SQL?

I'm sure I've done a table to CSV in MySQL before.

SOSAGES · 13-04-2004, 16:52

u can pretty much export it into what u want ..

when i did it it was as a simple SQL manager - Export - Select what u want to export - what format do u want to export to - save.

did it to access, notepad, and excel

Bifta · 13-04-2004, 17:04

I can do it via Phpmyadmin, but I have a script that uses MySQLdump that ftp's the file to another machine, so I just need the parameters for MySQLDump to dump the CSV file, it's got a cron job on it and exports data for a property search to a remote machine which is then picked up by their property search in CSV format and interpreted, at least, it will be if I can figure out the parameters.