MySQLDumper-Board Forum Index Follow me on Twitter

Portal  •   Forum  •  Downloads  •  Profile  •  Search   •  Register  •  Log in to check your private messages  •  Log in  •  


 User Manual Or Tutorials Please?

Post new topicReply to topic
Author Message
Matron
uses MSD regulary
uses MSD regulary





Joined: 23 Jan 2012
Posts: 12


usa.gif

PostPosted: 2012-01-23, 23:37    (No subject) Reply with quoteBack to top

Ok I understand what your saying about the save password thing now no big deal I will just ignore it thanks for clarifying for me.

That multi dump switch seems really silly to me, wasted about 40 minutes of my life with it so I guess it must be good for something, I would have never in a lifetime guessed that you had to select each database you want to backup AND flip another switch to confirm you really want to backup more than one database even though you have selected each databases you want to backup.

Is that "Multidump" switch like saying "Are you really really really sure you want to back up ALL the databases you have put check marks by?

Can you please explain to me why its setup this way perhaps once I understand the way you guys think I can figure out the rest of the program?

If I can get this thing figure out and working I will make you up a tutorial that is step by step in English you can use.

On a side note have you ever used Coppermine photo gallery? http://coppermine-gallery.net if not please download install then log in as administrator and look around the configuration everyplace you go their is a small question mark you can click on for each option and then a window pops up and explains EVERYTHING you could ever want to know about that option this is the best manual/help system I have ever seen or used since I started using computers back in 1991, pretty sure every time you change the language all the help changes with it, I only speak one language so cant tests this.

Thanks again the more I play with this the more I like it also thanks for the speedy replies.

OfflineView user's profileSend private messageSend e-mail    
Anzeigen











Posted:    Anzeigen Back to top


    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2012-01-23, 23:58    (No subject) Reply with quoteBack to top

« Matron » wrote:
That multi dump switch seems really silly to me

At first view it looks like that and I agree, that this is one thing that should be documented. In the German Video-Tuts it indeed is.

But if you think about it, it is the best solution. This way you can hold your preferred selection of databases if you want to backup another database.
You can simply turn off the switch, select the database to backup in the menu, run the backup and simply turn the switch back on. Done.

If we wouldn't have that switch, you would need to unselect all databases except the one you want to backup, do the backup and then re-select all databases again. Depending on the number of databases, this can be a click orgy. Wink
So I think our solution offers the best usability.

Quote:
Can you please explain to me why its setup this way perhaps once I understand the way you guys think I can figure out the rest of the program?

Ok, did it above. Wink
We are just lazy users like everybody else and we do use our program ourselves. So you now see the result of 9 years of developing and feedback of our users and ourselves. So we think the gui and the usability is in a very good state now.

Quote:
If I can get this thing figure out and working I will make you up a tutorial that is step by step in English you can use.

That would be great.


Quote:
everyplace you go their is a small question mark you can click on for each option and then a window pops up and explains EVERYTHING

We had this until - I think - version 1.22. But as this topic is very technical and also differs from host to host, we are not able to explain it in a way that it is valid for all servers, operating systems and hosts. We are not able to explain EVERYTHING here. MySQLDumper is used in many different environments, from a small web package up to big clusters.

Quote:
Thanks again the more I play with this the more I like it also thanks for the speedy replies.

Thanks and you are welcome. Wink

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Matron
uses MSD regulary
uses MSD regulary





Joined: 23 Jan 2012
Posts: 12


usa.gif

PostPosted: 2012-01-25, 12:43    (No subject) Reply with quoteBack to top

Now you explain it I now understand the use of that switch, good idea! It makes perfect sense.

I will be needing step by step instructions on getting the saved databases from the host server to my house automatically can you help?

I assume I will have to setup some sort of FTP server to receive them here at home, I am unsure what my email limits are, suggestions for what FTP to use?

Thanks again.

OfflineView user's profileSend private messageSend e-mail    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2012-01-25, 16:19    (No subject) Reply with quoteBack to top

« Matron » wrote:
I will be needing step by step instructions on getting the saved databases from the host server to my house automatically can you help?

You just need to open your eyes. You are like someone who is buying a car, asking the car seller how to drive it. That's not his job. Wink
Which option under configuration/FTP is unclear? Ask a specific question and we will answer. But please stop crying for step by step instructions. You have uploaded the files of MySQLDumper to your space. So you definitely already have set up a ftp account in your ftp programm. The params you need to provide in MSD are the same. First watch the options in MSD, then ask if you don't understand an option. You are doing it the other way round.

Quote:
suggestions for what FTP to use?

It's totally up to you which ftp server you install. FTP is a standard protocol, so from the view of MSD it doesn't matter.

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Matron
uses MSD regulary
uses MSD regulary





Joined: 23 Jan 2012
Posts: 12


usa.gif

PostPosted: 2012-01-25, 23:39    (No subject) Reply with quoteBack to top

Ok I went to Configuration: mysqldumper
Then clicked on FTP now what do I do

First question "FTP Transfer Mode: " no clue what to do with this switch
Second question "Secure SSL FTP " no clue here

Third question
Below the "use SSL Connection" their is a bunch of boxes asking for input where do I get this info,
for example "Server: " is this my host server or the server I setup at home?

Forth question once I have everything filled out how do I test the whole thing to ensure it will download the files, where do I in put where the files go when downloaded?

Where do I setup the days and times it sends the backed up files.

No doubt being the developer and having used this program for 9 years this is annoying for me to ask questions I havent a clue its like looking at a blank page to me I didnt have the pleasure of watching the video tutorials either I am pretty much looking a blank page in my mind for 90% of everything I see where you guys all take it for granted..

OfflineView user's profileSend private messageSend e-mail    
Matron
uses MSD regulary
uses MSD regulary





Joined: 23 Jan 2012
Posts: 12


usa.gif

PostPosted: 2012-01-26, 00:03    (No subject) Reply with quoteBack to top

What is a "Cronscript"

What is this feature for and how do I use it does it require imput from me it looks like its already configured for something?

OfflineView user's profileSend private messageSend e-mail    
DSB
Developer
Developer




Age: 41
Joined: 30 Apr 2004
Posts: 16073
Location: Reichenberg bei Würzburg


germany.gif

PostPosted: 2012-01-26, 00:14    (No subject) Reply with quoteBack to top

Here is a guide in English.
May this help you and answer some of your questions:
http://www.jaguarpc.com/forums/general-hosting-network-support/14590-setting-up-mysqldumper-jaguarpc-server.html

_________________
Gruß / Greetings, DSB

Teigwaren heißen Teigwaren, weil sie Teig waren.
Diejenigen, die lautstark darüber diskutieren, warum es nicht geht, mögen bitte jene nicht stören, die es gerade tun.

OfflineView user's profileSend private messageSend e-mailVisit poster's website    
Jens_K
Moderator
Moderator




Age: 37
Joined: 04 Sep 2007
Posts: 1710
Location: Nähe Bielefeld


germany.gif

PostPosted: 2012-01-26, 01:30    (No subject) Reply with quoteBack to top

« Matron » wrote:
First question "FTP Transfer Mode: " no clue what to do with this switch


From Wikipedia:
Quote:
FTP may run in active or passive modes, any of which determines how the data connection is established. In the active mode, the client sends the server the IP address and port number, then the client waits till the server initiates the TCP connection. In situations where the client is behind a firewall and unable to accept incoming TCP connections, the passive mode may be used. In this mode the client sends a PASV command to the server and receives an IP address and port number in return. The client uses these to open the data connection to the server. Both modes were updated in September 1998 to support IPv6. Further changes were introduced to the passive mode at that time, updating it to extended passive mode.


In short: First try active mode, if that doesn't work, try passive mode. If that also doesn't work, you're basically screwed.

With the FTP option of MySQLDumper, you can tell the script to transfer the created backup file (*.sql or *.sql.gz) to another server. That can be another online webspace or an FTP server set up on your local box at home. In that case, your local box must be up an running an FTP server program, connected to the internet and reachable. If you're on a dialup connection and do not have a static IP, you may need some kind of dynamic DNS Adress set up that points to your local IP.

« Matron » wrote:
Second question "Secure SSL FTP " no clue here

For insight into the matter, try - again - Wikipedia.
If the server your run your MySQLDumper installation from supports it, you can use a secure FTP connection (encrypted) to transfer the backup files to your destination FTP server.

« Matron » wrote:
Third question
Below the "use SSL Connection" their is a bunch of boxes asking for input where do I get this info,
for example "Server: " is this my host server or the server I setup at home?

Here you enter the connection data for the FTP server you want your backup files get transfered to. In your case this is the server you set up at home.

You'll need a server IP adress (or a DNS entry pointing to that IP), a port (which usually is 21), a FTP user and a matching password for that user, and optionally a path to a directory on your ftp if the user is not configured to already land in the correct directory after loging in.

« Matron » wrote:
Forth question once I have everything filled out how do I test the whole thing to ensure it will download the files, where do I in put where the files go when downloaded?

Right under the SSL FTP option there is a button, that reads "Test Connection" on it. If you click on that button after you filled out all params, it wil - well - test the connection.
Then you can simply run a backup (remember to check that the FTP connection you just set up is "activated") and after the backup is done, MySQLDumper will upload (not download!) the created backup file to your FTP server.

« Matron » wrote:
Where do I setup the days and times it sends the backed up files.

This is done by setting up a cronjob.
Check the backup page of MySQLDumper. At the top you can switch between the PHP method and the PERL method to back up your database.

After you checked that you can run perl scripts on your server (look at the 3 buttons) check the bottom of the page.

Here you will find three entries

"Entry in crondump.pl for absolute_path_of_configdir:"
You have to manually edit the file /msd_cron/crondump.pl, find the variable "absolute_path_of_configdir" and copy the displayed path beteween the "".

"URL for the browser or for external Cron job:"
With this URL you can then run the cronscript that is backing up your DB and - if configured - transfers it to your FTP server.

"Commandline in the Shell or for the Crontab:"
Here you find exactly what you'll need if your webhoster lets you create a cronjob by adding an entry to the crontab.

Setting up a cronjob can differ from webhoster to webhoster. Or even from hosting plan to hosting plan.
Check your webhoster for support on setting up a cronjob on your specific server.

_________________
It's like math-camp all over again ... not ... that i've ever been to math-camp!
mein Blog

OfflineView user's profileSend private messageVisit poster's website    
Display posts from previous:      
Post new topicReply to topic


 Jump to:   


Show permissions
Similar topics
Topic Author Forum Replies Posted
No new posts Installtionsproblem access denied for... kischkel Fehler / Probleme 9 2012-05-09, 17:33 View latest post
No new posts Access denied for user ''@'localhost'... Frank38K Allgemeine Fragen zu MySQLDumper 7 2012-05-08, 00:10 View latest post
No new posts Ältere Beiträge und User aus früherem... abelius-kiel Allgemeine Fragen zu MySQLDumper 3 2012-04-22, 10:16 View latest post
No new posts MySQL-ERROR: Access denied for user '... topi009 Allgemeine Fragen zu MySQLDumper 3 2012-03-22, 13:34 View latest post
No new posts anderer user bei php-Backup wedge1001 Gelöst/Erledigt 3 2011-11-08, 20:50 View latest post

 
CrackerTracker © 2004 - 2012 CBACK.de

Powered by Orion based on phpBB © 2001, 2002 phpBB Group
CBACK Orion Style based on FI Theme
All times are GMT + 2 Hours

phpBB SEO