Welcome, Guest. Please login or register.

ShoutBox!

Scrubmeister

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

Skhilled

2024-04-18, 21:09:09
I've upgraded the server...more resources. ;)
 

Ken

2024-04-18, 20:57:10
Now that you mention it...  :D
 

Skhilled

2024-04-18, 20:47:19
...and, you should notice that the site is much faster.  :o
 

Ken

2024-04-18, 20:31:37
Hey Steve.
 

Skhilled

2024-04-18, 17:56:10
Re-read the message below...
 

Skhilled

2024-03-31, 15:22:06
Oh yeah, you need to upgrade the site first...
 

Ken

2024-03-30, 09:54:54
Whoops! I forgot that the SMF install here on OFF is out of date!  :'(
 

Ken

2024-03-30, 09:44:48
 Conga-Rats Steve!  :thumbup:
Me gonna install it here just for the fun of it!  :)
 

Skhilled

2024-03-29, 22:15:23
Released!  :D

Recent Topics

TP Articles


Search in titles
Search in article texts

Author Topic: MySQL Dumper  (Read 2156 times)

0 Members and 1 Guest are viewing this topic.

Offline Skhilled

  • Administrator
  • *
  • Posts: 9007
  • Gender: Male
  • All of my passwords are protected by amnesia...
    • 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: 11675
  • Gender: Male
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: 11675
  • Gender: Male
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

  • Administrator
  • *
  • Posts: 9007
  • Gender: Male
  • All of my passwords are protected by amnesia...
    • 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

  • Forum Staff
  • *
  • Posts: 1531
  • Gender: Male
    • Build Hosting
Re: MySQL Dumper
« Reply #4 on: February 13, 2012, 11:47:27 AM »
Nice find Steve, gonna check it out