469,332 Members | 6,612 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,332 developers. It's quick & easy.

BackUp Tables from MySql in ASP

Happy new year.
I am looking for code that will go through all tables in MYSQL db and
transfer records into text or excel files.
Thanks
Jan 1 '07 #1
3 1779
The MySQL Server should have it's own ability to do that, just like MS SQL
Server does. It should be able to do it on a schedule. Then you just copy
the "backup file" somewhere safe or burn it to disk or whatever. The right
solution is not ASP or text files or excell.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com

The views expressed are my own (as annoying as they are), and not those of
my employer or anyone else associated with me.
-----------------------------------------------------

"Michael" <mi**************@intergraph.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
Happy new year.
I am looking for code that will go through all tables in MYSQL db and
transfer records into text or excel files.
Thanks

Jan 2 '07 #2
Hi Philip. thank you for respond. I am trying to provide to my customer
solution that will store the backup somewhere on shared hosting place or
local machine, so I don't think he will have access for maintenance of DB,
also I am very like to provide transparent solution, I mean - pressing
button in admin area the process will be running and store files on server
or on local machine. So my point to make script that will be initialized by
user. I know the php with cron can do it, but ASP does not. After that the
admin will be responsible for restore process from these files. My
experience tells me do not trust only on server abilities. Thanks again
Michael
"Phillip Windell" <@.wrote in message
news:Og**************@TK2MSFTNGP04.phx.gbl...
The MySQL Server should have it's own ability to do that, just like MS SQL
Server does. It should be able to do it on a schedule. Then you just copy
the "backup file" somewhere safe or burn it to disk or whatever. The
right solution is not ASP or text files or excell.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com

The views expressed are my own (as annoying as they are), and not those of
my employer or anyone else associated with me.
-----------------------------------------------------

"Michael" <mi**************@intergraph.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>Happy new year.
I am looking for code that will go through all tables in MYSQL db and
transfer records into text or excel files.
Thanks


Jan 2 '07 #3
"Michael" <mi**************@intergraph.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...
admin will be responsible for restore process from these files. My
experience tells me do not trust only on server abilities.
My experience is to not trust the ASP. The server doing it's own thing
independent of the ASP is the most dependable. The Backup file can be
stored in a location reachable from the site,...the file can be downloaded
by the customer with a simple link if they are wanting to store their own
copy of the backup file. I know of no way to backup the database using ASP
nor do I know of any way to restore from the backup copy without the
customer sending you the file and having you restore it yourself. These are
functions unique to the type of Database Server you are using and are part
of what it does, not what the web server does. There may be a way,...but it
is way beyond me.

--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com

The views expressed are my own (as annoying as they are), and not those of
my employer or anyone else associated with me.
-----------------------------------------------------

Jan 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by James | last post: by
6 posts views Thread by Mosher | last post: by
reply views Thread by Jean Hagen | last post: by
2 posts views Thread by Thomas Bartkus | last post: by
3 posts views Thread by Reuben Pearse | last post: by
1 post views Thread by Rajesh Kapur | last post: by
reply views Thread by newman | last post: by
2 posts views Thread by Ben | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.