How to backup my remote MySql database

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
askme

How to backup my remote MySql database

Post by askme »

I am running CMS made Simple content management system for my website. I want to move my existing website to another hosting server. I need to backup my old CMS MySql database remotely. I don’t have PhpMyAdmin installed on hosting server. I know the database name, database user name and its password.
Please let me know how I can backup remotely my old database from server to local machine. Thanks!
User avatar
Nullig
Power Poster
Power Poster
Posts: 2380
Joined: Fri Feb 02, 2007 4:31 pm

Re: How to backup my remote MySql database

Post by Nullig »

Do you have shell access? Can you run mysqldump?
There are some backup modules in the forge you could try.

Nullig
askme

Re: How to backup my remote MySql database

Post by askme »

I am using Windows XP on my local machine. My web hosting where MySql database exists alos using Windows platform and Plesk 8.0 as web management tool.
I really need to backup my MySql data from remote server to my local machine.
cyberman

Re: How to backup my remote MySql database

Post by cyberman »

I'm using MySQLDumper for backups - it's a great tool (for big databases too).

http://www.mysqldumper.de/en/
askme

Re: How to backup my remote MySql database

Post by askme »

Thank you very much CYBERMAN

Great Tool- small, simple and fast yet with lots of features!

But where is security? I mean once install on your website.. anyone can run it-no need password and login right? How to make it more secure?
Last edited by askme on Wed May 21, 2008 7:13 am, edited 1 time in total.
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: How to backup my remote MySql database

Post by calguy1000 »

This is not a CMS specific thread..
thread moved.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
Post Reply

Return to “The Lounge”