Mysql dump to .sql?

[Walter1 8]

Hey botters!

 

 

I am trying to let my bot do a mysql dump on given times from my server.

Noticed the scripts around the web but my problem here is that my bot is running on one server, and the mysql db on another.

 

Since the db is quite huge, or is going to be hopefully a php script is maybe not the best option because of the restrictions and limits a php script could have.

 

A shell command would be an option but then i have the two seperate server problem.

 

I am really curious how some of you are dealing with this problem.

 

 

TY

 

 

[Bot-Factory 602]

Is it necessary to do that via Ubot? Why can't you just have a scheduled backup configured on your server where the mysql db  is hosted?

Or what's the reason you want to trigger it via ubot?

 

If you have a nail, you need a hammer. Doing it with a screwdriver could work, but it's probably more complicated :-)

 

Dan

[Walter1 8]

Hi Dan,

 

 

Yeah that could do it to i guess hehe... Never thought of that before.

 

Since i am going to have a massive DB when things hit off here i want to have a regular DB dump, just in case.

I was figuring a way trough ubot but i wasn't aware you could do that directly on the server.

 

Never a day goes by i learn something

 

 

Thanks!

[Bot-Factory 602]

And to add some constructive information as well:

http://www.noupe.com/how-tos/10-ways-to-automatically-manually-backup-mysql-database.html

 

Dan

[Walter1 8]

Thanks dan for the link, really informative!

 

I went ahead and chose the option of a external software that downloads it on set times to a server. 

 

 

Learning everyday

[the_way 52]

There are some good wordpress plugins, i use one that does a website dump to dropbox. If thats any help as an option.