MySQL backup

[Sarah Atkinson]

We are wanting to scheadule a backup of our MySQL database. currently it is on our hosts server and we want to back it up to our local server. Is their any software that will do this for us? I found a free scrip for a LINX platform. But we run windows XP.
Sarah

[henry0]

Sarah,
Verify with your ISP that you have PHPmyAdmin

then the rest is easy

let us know if you have access to PHPmyAdmin

you can also use some direct SQL com but it will be better to have someone knowing the "how to" doing it.

regards

Henry

[Sarah Atkinson]

yes i have phpmyadmin

[henry0]

OK
go to your PHPmyAdmin
from the top
click on Export
select "all"
save as "file"
select "none" or Zipped"

depending on your version you might have the choice
to select only "structure"
or "structure and data" which is what you need to select

do not be afraid to kill it
since "dangerous" moves are always doubled by a "do you really want to...."

[Sarah Atkinson]

What aboult schedualing them? We want to do it at night when bandwidth is low. Also I don't want to have to manualy do it each time. I will enevitably forget.

[henry0]

Now that is a dif question
since you mentioned MySQL I suppose that you run some PHP scripts

forget about PHPmyadmin

you need a script that will do the "DB Dump" and tied with a cron job
the whole thing is server side and need to be prg in PHP

from there you will need to digest the thread and post in the PHP forum

Henry

[trillianjedi]

Continued over here...

[webmasterworld.com...]