Docskillz

Computer Love => Servers => Topic started by: Skhilled on February 12, 2012, 04:53:48 AM

Title: MySQL Dumper
Post by: Skhilled on February 12, 2012, 04:53:48 AM
Can't seem to keep track of how or when you backed up your database(s). If you have more than one like I do (I currently have 12 for 12 different test sites!) it can be a headache keeping them organized, backed up and restoring them.

Well, with MySQL Dumper (http://www.mysqldumper.net/) you can do all of that and a lot more! Basically, you upload the MySQL Dumper files to a new directory on your server and run it from there. With it, you can:

1.  View all of your databases on your server as well as how many tables are in each one at a glance.
2.  Backup all of your databases.
3.  Restore all of your databases.
4.  View server info like mysql and php version, operating system, PHP-extensions, server status, free space on the server, the number of backups you have, the last backup made, and more!
5.  Create or remove directory protection for MySQL Dumper via .htaccess.
6.  Edit, insert, delete, query, etc. database tables and even more than phpmyadmin can do!
7.  Create and save different configurations to automate backups and restores.
8.  Create cronjobs to automate things.
9.  Email notification when a task is complete.
10.  Upload database up to 50mb in size. For anything larger than that you can FTP it to a folder and work it from there.
11.  FTP configuration.
12.  Backup compression, if needed.
13.  Ability to delete old tables when restoring tables.
14.  Select certain tables for backup, not just the entire db, if needed.
15.  Choose language encoding of backups as well as the ability to enter comments!
16.  Multi-part backups for larger databases.
17.  Restore for multi-part backups.
18.  Can convert .sql files to .sql.gz as well as compress them.
19.  Log your activities as well as delete the logs.
20.  PERL support.
Title: Re: MySQL Dumper
Post by: hackrishna on March 11, 2012, 08:48:09 AM
Would try it soon  :evil_fire:
Title: Re: MySQL Dumper
Post by: Skhilled on March 11, 2012, 08:56:33 AM
You'll love it and will probably use it more than cPanel or phpmyadmin.
Title: Re: MySQL Dumper
Post by: hackrishna on March 11, 2012, 09:28:19 AM
Quote from: Skhilled on March 11, 2012, 08:56:33 AM
You'll love it and will probably use it more than cPanel or phpmyadmin.

mmmm .. you're saying it so confidently .... i will surely try it ;)
Title: Re: MySQL Dumper
Post by: Skhilled on March 11, 2012, 09:35:48 AM
It's a great tool.
Title: Re: MySQL Dumper
Post by: hackrishna on March 11, 2012, 01:06:17 PM
Quote from: Skhilled on March 11, 2012, 09:35:48 AM
It's a great tool.

:o :o :o it's a great tool .. how come i didn't heard abt it yet ....  ???

anyways thanks alot very lot ..  :bow:
Title: Re: MySQL Dumper
Post by: Skhilled on March 11, 2012, 01:12:45 PM
Searching and hanging out with the right people will show and teach you a lot. ;)
Title: Re: MySQL Dumper
Post by: hackrishna on March 11, 2012, 01:33:07 PM
Quote from: Skhilled on March 11, 2012, 01:12:45 PM
Searching and hanging out with the right people will show and teach you a lot. ;)

well said  ;) that's why i'm here  ;D
Title: Re: MySQL Dumper
Post by: Skhilled on March 11, 2012, 01:46:55 PM
I always try to hang out with people and on forums where they know more than I do. That's how you learn. Once you stop learning, you stop living...no matter what it is you wish to learn.
Title: Re: MySQL Dumper
Post by: hackrishna on March 11, 2012, 01:52:49 PM
Quote from: Skhilled on March 11, 2012, 01:46:55 PM
I always try to hang out with people and on forums where they know more than I do. That's how you learn. Once you stop learning, you stop living...no matter what it is you wish to learn.

We're gng off-topic :P
Title: Re: MySQL Dumper
Post by: Skhilled on March 11, 2012, 02:00:55 PM
I don't worry too much about that here. Staying on topic helps people who are just looking for what the topic is though...
Title: Re: MySQL Dumper
Post by: Ronald on May 31, 2012, 08:40:10 PM
What type of a program is this. Would I benefit from it? :whistle:
Title: Re: MySQL Dumper
Post by: Skhilled on June 01, 2012, 10:05:18 AM
It will backup or restore your database without using phpadmin. Yes, anyone can benefit from it.
Title: Re: MySQL Dumper
Post by: beast on June 02, 2012, 06:57:42 AM


  Would I know enough to use it? Or should I wait till I know more?

:dontknow:
Title: Re: MySQL Dumper
Post by: Skhilled on June 02, 2012, 07:21:10 AM
I suggest waiting until I create a tutorial for it...but I do believe there is one at the site where you download it but can't remember.
Title: Re: MySQL Dumper
Post by: beast on June 18, 2012, 07:39:39 AM


  I'll wait. I don't want to mess up ever thing I got

:rofl1:
Title: Re: MySQL Dumper
Post by: Skhilled on June 18, 2012, 07:52:27 AM
I've been busy helping a couple of other people lately.