Post by i2Paq » Sun Jun 27, 2010 2:36 pm

Currently I'm using Auto Backup for MySQL Professional Edition, this is a commercial solution.

I'm looking for a free tool that will let me backup just one MySQL database (at a time).

I've searched Google but found nothing that I felt was good/recent.

Anyone?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by JAY6390 » Sun Jun 27, 2010 7:43 pm

phpMyAdmin?
I use Navicat personally, but it's not free
Take a look at http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html if you have shell access (or can run shell commands through php)

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by Xsecrets » Sun Jun 27, 2010 10:07 pm

also you can go to the mysql site they have tools for free there. used to be mysqladmin, but they recently changed the name. think it might be workbench now not sure haven't used them in a while.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by SteveSherry » Mon Jun 28, 2010 4:59 am

I use MySQLadmin & also MySQLworkbench.

Both good tools, very quick and easy to use.

I'd guess that you'd also be able to do it through cpanel (if you have it)

My Website ¦ Summer Madness Special Offer ¦


Active Member

Posts

Joined
Thu Apr 08, 2010 7:47 am
Location - Wirral, UK

Post by i2Paq » Wed Jun 30, 2010 2:33 pm

Thanks for the reply's!

I need a tool I can run from my Pc at home to make a backup of my remote database to my local disk.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by JAY6390 » Wed Jun 30, 2010 5:46 pm

Personally I would just create one...it's really not that difficult. On your remote server you would need a script to do the backup execution and compression. Then on your local server have a script that calls the remote script to execute the backup, once it outputs a completed message, the local script then FTP's into the server, gets the file and downloads it. Once downloaded, it deletes the remote file (if you want to do that) and closes the ftp connection

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by i2Paq » Wed Jun 30, 2010 9:40 pm

JAY6390 wrote:Personally I would just create one...it's really not that difficult.
Tell that to a non-coder :D

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by JAY6390 » Wed Jun 30, 2010 11:18 pm

haha fair enough. Another good option would be to use a script already out there. Pretty sure there are scripts that will backup and email you the database. While I realise this doesn't save the file, it does give you a complete backup that you can send to any server in the world! :)

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom
Who is online

Users browsing this forum: No registered users and 2 guests