Backup/dump from ASP

[dtext.tele.dk]

Hi!

I am using a web hotel which is offering access to a MySQL database.
The only way to make a backup is via a web interace.

What I am looking for is a way to create a classic ASP script to get all
the
data, and send them in an e-mail. The e-mail part is no problem for me.

Hope to get some ideeas from somebody :-)


Best regarts, Brian

[Jonathan]

Re: Backup/dump from ASP

dtext.tele.dk wrote:[color=blue]
> Hi!
>
> I am using a web hotel which is offering access to a MySQL database.
> The only way to make a backup is via a web interace.
>
> What I am looking for is a way to create a classic ASP script to get all
> the
> data, and send them in an e-mail. The e-mail part is no problem for me.
>
> Hope to get some ideeas from somebody :-)
>
>
> Best regarts, Brian
>
>
>[/color]
I don't know of asp, but exporting your data as comma separated values
or something like that seems to be the way to go I think...

Just a matter of exporting all your data from your tables as values
separated by some character. Maybe you can also use the 'SLOAD DATA
INFILE' or 'LOAD DATA LOCAL' statement. Have a look at the MySQL manual.

Good luck!

Jonathan

--
A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

[Bill Karwin]

Re: Backup/dump from ASP

dtext.tele.dk wrote:[color=blue]
> What I am looking for is a way to create a classic ASP script to get all
> the
> data, and send them in an e-mail. The e-mail part is no problem for me.[/color]

I'm totally ignorant of ASP. Can ASP run an external command? If so,
could you run "mysqldump. exe" with the appropriate arguments, and
capture the output? Then you could send that as an email attachment or
whatever you need to do.

Regards,
Bill K.