User Manual Or Tutorials Please?

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

Hi,
Great looking program, downloaded, installed logged in, now what?

I guess I missed it some place but is their a user manual or tutorial some place?

I read the readme and docs that came with the download, nothing, looked around on the website found nothing, did a google nothing, please help.

I clicked on "Configuration" but I really have no clue what to do and dont want to risk data loss or damage by just flipping switches and by guessing.

The install was easy and painless thanks for that.

Thanks.

Posted: 2012-01-23, 18:45 (No subject)

Hi!

Why did you download and install the script?

I guess you wanted to back up your MySQL database. So just click on "Backup" and the scrip will do a backup of your selected MySQL database. That's simply it.

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

I can use phpmyadmin or the tools my host provides to do what you describe.

I want to backup all my databases and have it FTP them to my house so I can store backups off site, off web.

I also want to be able to restore rather large databases for a phpbb message board that phpmyadmin cant restore or bigdump cant successfully do without countless errors.

I am simply looking for a manual or tutorial describing what every available option does and why before I start flipping switches and creating problems or find out in the future I did something wrong and all my backups are totally worthless.

Instructions on how to setup, run then test to verify the backups it made actually will restore if needed.

I made the mistake of relying on my host to do backups and safeguard my data (they assured me my data was protected WRONG), guess what his server was hacked and ALL his databases wiped out and all his backups wiped out anything connected to his server that was backing up data got hit, the only backups that worked to restore my data was the databases I had downloaded to my home and burned to a DVD (disconnected from the web) , lesson learned, never again, myself and many others learned a very expensive lesson, think any data connected to the web is safe WRONG, this guy was right for about 7 years but it only took less than 15 min to prove him wrong.

I figure I can set this up on my host server have it backup then FTP the databases to me at home, burn them to a DVD then using the DVD restore he databases on a test server I have setup here at home, I also can upload the databases from the DVD to my host server and restore to another DB name then try the restored DB to ensure it actually works without my website users being affected by my verifications.

On a side note over the years I have had many failed backups but only found out when I tried to restore them their was a problem that could not be fixed, always it was from a hard drive, so far restoring backups burned to a DVD has been 100%, I suggest people actually try to use a backup a few times before they actually have to I think you might be surprised how many wont work or how many days it might take you fighting errors to make one work.

Thanks again.

Posted: 2012-01-23, 19:48 (No subject)

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

So their is no documentation?

First question.

After installing at the top it says.

"Status Information
Urgently recommended: Create directory protection"

What does this do and why, please explain.

I will give the videos a watch thanks.

From my past post I think you get the idea what I need to do basically I need step by step instructions to make it all work, I rather get instructions than try to learn by trial and error, I want to be 100% sure I know what I am doing and that it will work as expected.

Thanks

Posted: 2012-01-23, 20:26 (No subject)

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

Tried the videos they are no use to me I do not understand a single word.

I tried to "Create directory protection" when I try to log in no matter how many times I enter the user name and password it will not accept it.

Suggestions?

Thanks

EDIT
Ok now I cant use any of this program it keeps asking for a user and password, I am 100% sure I am entering the correct user and password.

Posted: 2012-01-23, 20:38 (No subject)

Delete the file .htaccess in the MySQLDumper folder and re-create the protection (This will delete the protection).
Don't use any special chars for username and password and choose the correct operating system of teh server (not of your local box).

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

Posted: 2012-01-23, 21:00 (No subject)

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

I figured I would try to make a basic backup of all my databases just to see if that works then move onto trying to download them FTP, I tried to do a backup and am getting the below error

Error in OPTIMIZE TABLE `cond_instances` -> SELECT,INSERT command denied to user 'test'@'localhost' for table 'cond_instances'

No where in the "Configuration" have I found where its going to save my backup if I didnt get the above error I thought what the heck I would just click "backup" maybe it would tell me after it backed them up where they went?

I have a whole list of questions should I ask them all here one at a time or start a new post for each?

First I want to fix the above error so I know it will backup and restore then move on to more advanced options.

Thanks again.

Posted: 2012-01-23, 21:18 (No subject)

This is a misconfiguration of the MySQL-User you are using. He doesn't have the right to optimze a table.
Simply turn off the automatic optimization in the options of MySQLDumper.

Please start a new thread for each question. Noone wants to answer a big heavy bunch of questions at once.

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

Ok I turned off "automatic optimization" clicked save, I noticed every time I click "SAVE" in this program up pops a thing on firefoxes tile bar asking me if I want to change the saved password, whats up with this?

So I went back to the configuration and I have 5 databases, I selected the first database then clicked "SAVE" op pops the thing asking me if I want to save the password again, I ignore it then navigate to the thing where it says "START NEW BACKUP" click it the program runs and completes the backup, I then go back and select the first and second database then click "SAVE" then "START NEW BACKUP" again the program runs when its done I navigate to the "File Administration" I now have 2 copies of the FIRST file and no copy of the second file I selected.

I went back and then selected the FIRST SECOND and THIRD files then clicked "SAVE" then "START NEW BACKUP" the program runs again after its done I navigate back to the "File Administration" where I have 3 copies of the FIRST database only.

Did this for a total of 5 times I have 5 copies of the first selected database it never makes a backup of any other databases I select for a backup.

After each backup I go back to where you pick the databases you want to backup and they are still checked they are just not backed up.

Any ideas I guess I missing something some place since the boxes next to the databases I want to backup are selected the program is only backing up the first file I have slected.

I have no idea if the file that it does backup is any good I figure no use in testing the backup if its not going to backup all I have selected.

Any ideas why its only backing up the first file and why firefox thinks I am changing a password each time I click "SAVE" in the program?

**uses MSD regulary** Joined: 23 Jan 2012 Posts: 12

Ok I went back and unselected the FIRST database and selected the SECOND THIRD and FORTH databases then clicked "SAVE" then went back to the "START NEW BACKUP" clicked it the program ran when done went into "File Administration" I now have 6 copies of the FIRST file that is NOT SELECTED and no copies of the SECOND THIRD and FORTH databases.

Really strange behavior I am at a complete loss here.

Posted: 2012-01-23, 22:23 (No subject)