Welcome, Guest. Please login or register.

ShoutBox!

 

Skhilled

2024-08-09, 18:19:29
Awww! Poor thing! LOL
 

Ken

2024-08-09, 09:20:52
 

Skhilled

2024-07-06, 10:33:18
 :D
 

Ken

2024-07-06, 06:40:47
Happy Saturday after the 4th of July!
 :fireworks:
 

Skhilled

2024-07-04, 20:27:02
Happy Day Off From Work!  :D
 

Ken

2024-06-25, 06:23:12
84... who knew?  laughing7
...2013 was my *magic* year
 

Skhilled

2024-06-14, 22:09:12
I hope so! LOL
 

Ken

2024-06-14, 21:41:30
My B-Day is forthcoming and maybe it will be far enough along so that I can be a regular Dancing Fool for that day!!! :banana: :2funny:
 

Ken

2024-06-14, 21:38:38
Happy Friday everyone! I'm  SOOO glad to see Friday and not just because it's the weekend, but because it marks one more day in the recovery of my foot!  laughing7

Scrubmeister

2024-04-19, 10:32:40
Good to see the site back faster than ever. :)

Recent Topics

TP Articles


Search in titles
Search in article texts

Author Topic: MySQL Dumper  (Read 2817 times)

0 Members and 1 Guest are viewing this topic.

Offline Skhilled (OP)

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
MySQL Dumper
« on: February 12, 2012, 06:39:59 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 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.

Offline Ken

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: MySQL Dumper
« Reply #1 on: February 12, 2012, 09:17:57 AM »
I need to look into this because trying to remember to do a backup is always problematic... even when installing a package it's easy to forget to do one.
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Ken

  • Vietnam Era Veteran
  • Administrator
  • *
  • Posts: 11937
  • Gender: Male
  • View Gallery
Re: MySQL Dumper
« Reply #2 on: February 12, 2012, 10:44:52 AM »
Great find Steve!  :2thumbs:

Just setup the basics and did a test BU and it's working like a charm.
Now I just need to go through all of the available options to set a routine for having automated backup's sent to my email.  :bigteeth:
"Not all who wander are lost."-Tolkien
Yesterday When I was Young.

Offline Skhilled (OP)

  • Administrator
  • *
  • Posts: 9424
  • Gender: Male
  • All of my passwords are protected by amnesia...
  • View Gallery
    • Buildz Hosting
Re: MySQL Dumper
« Reply #3 on: February 12, 2012, 11:46:56 AM »
Pretty easy and you can save multiple configurations for different tasks. :)

It also has built-in FTP. You can normally upload files up to 50MB. But for anything more than that you must FTP them to the work/backup folder first then do what you must. I tested importing one db into another (something I do a lot of) which worked flawlessly and pretty darn quick!

Offline Lesmond

Re: MySQL Dumper
« Reply #4 on: February 13, 2012, 11:47:27 AM »
Nice find Steve, gonna check it out