Display by: RelevanceDownloads Name

MySQLDumper is a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and - if needed - restore it. But when you use a command like mysqldump, the option outputs the dump of the database tables to the desired file: # mysqldump -username=whatever -password=whatever -h localhost database dump.sql If you add in the -v (verbose) option to mysqldump, it outputs help information about what. Copy mysql/mysqldump from /Applications/MySQLWorkbench.app/Contents/MacOS to preferred place. Use mysqldump from command line; Should also work when you remove MysqlWorkbench. Install XAMPP and replace mysqldump path in workbench https://stackoverflow.com/a/403255.

Added: June 25, 2010 Visits: 1.315

mysqldump.php is a PHP script that dumps a MySQL database into a mysqldump compatible SQL script. mysqldump.php can also dump a table into CSV format..


Platforms: *nix
License: FreewareSize: 3.07 KBDownload (141): mysqldump.php Download

Added: April 04, 2013 Visits: 341

PHP MySQLDump Browser allows users/system admins to browse through MySQL Database Backups (Dump Files). Users can view and extract individual table structures and or data from MySQL database dumps. Use this PHP script to avoid restoring entire backups to recover individual tables. Database dumps...


Platforms: PHP
License: FreewareSize: 10 KBDownload (19): PHP MySQLDump Browser Download
Mysqldump for mac download
Added: June 20, 2013 Visits: 289

ajDbBackup can take a backup of a given MySQL database using the mysqldump command. Then it uses the tar command to pack the backup file.An e-mail message can be sent to a specified address with the backed up file as attachment.
Platforms: PHP

License: FreewareSize: 10 KBDownload (24): ajDbBackup Download

Added: August 10, 2013 Visits: 441

PHPMySQLbackup allows you to perform the backup of a mysql database in mysqldump format without using mysqldump or a system command, only PHP.The class makes a SQL script or GZip archive to download.
Platforms: PHP

License: FreewareSize: 10 KBDownload (21): PHPMySQLbackup Download

Released: October 12, 2002 Added: January 15, 2006 Visits: 2.783

MySQL Snap program is intended for creation backup copies of MySQL databases as well as for transport it from one server to another. The program advantages: - full compatibility of the result dump with the dump produced with the help of standard MySQL database management system utility -...
Platforms: Windows

License: FreewareSize: 812 KBDownload (273): MySQL Snap Download

Released: July 26, 2012 Added: July 26, 2012 Visits: 264

About MySQL BackUpA wrapper of the mysqldump command. You can backup your local database or on a remote server, with some parameters like structure only or add 'drop table', 'create table', 'create db' statements. You can choose a compression for the backup (tar&gzip or tar).
Platforms: Mac

License: FreewareSize: 153.6 KBDownload (28): MySQL BackUp 1.1 Download

Added: May 10, 2013 Visits: 230

deeMySQLParser is a mysqldump parser that returns table structure of a dump in a nice associative array.
Platforms: Windows, Mac, *nix, PHP, BSD Solaris

License: FreewareDownload (38): deeMySQLParser Download

Added: May 10, 2013 Visits: 328

The Backup Client provides PHP based tar and mysqldump functionality and is intended to be platform independentInstallationUnpack in your modules folder (usually /sites/all/modules/) and enable under Administer > Site Building > Modules. Key features 'Backup Client-Server': - scheduled backups...
Platforms: Windows, Mac, *nix, PHP, BSD Solaris

License: FreewareDownload (31): Backup Client-Server 5.x-1.x-dev Download

Added: May 10, 2013 Visits: 257

MySql DbBackup is a PHP script that will backup your local/remote MySql DB using mysqldump. Features : Backup rotation, bzip2/gzip compression, gpg encryption, FTP file sending, Email file sending, Email repporting, log... and a lot of options to configure it.
Platforms: Windows, Mac, *nix, PHP, BSD Solaris

License: FreewareDownload (33): MySql DbBackup Download

Added: September 16, 2013 Visits: 244

WebMySQL script creates a web interface to a MySQL database server.Features- Supports the following SQL queries:- SELECT- DESCRIBE- JOIN- SHOW- DROP- CREATE- USE- INSERT- EXPLAIN- Advanced query options such as LIMIT, DISTINCT and GROUP- Fully customisable look and feel using CSS and HTML...
Platforms: CGI and Perl

License: FreewareSize: 20.48 KBDownload (20): WebMySQL Download

Added: April 06, 2013 Visits: 327

MySql DbBackup is a PHP script that will backup your local/remote MySql DB using mysqldump.Features : Backup rotation, bzip2/gzip compression, gpg encryption, FTP file sending, Email file sending, Email repporting, log... and a lot of options to configure it.
Platforms: PHP

License: FreewareSize: 10 KBDownload (21): MySql DbBackup for Scripts Download

Added: August 02, 2013 Visits: 368

MySQL Data Dumper is a software designed exactly how a MySQL DBA & support engineer would imagine 'mysqldump'. Usage: mydumper [OPTION...] multi-threaded MySQL dumping Help Options: -?, --help Show help options Application Options: -h, --host The host to connect to -u, --user Username with...
Platforms: *nix

Mac

Mysqldump For Backup

License: FreewareSize: 10.24 KBDownload (20): MySQL Data Dumper Download

Released: September 09, 2004 Added: April 11, 2006 Visits: 6.216

The MySQL Dump Timer is intended to backup MySQL databases and tables periodically (MySQL Dump). It also allows the transfer of a MySQL database and MySQL tables between different MySQL servers (= MySQL Backup AND MySQL Restore). * Firewalls will not block the access to the MySQL database: A...
Platforms: Windows

License: SharewareCost: $34.00 USDSize: 2.02 MBDownload (613): MySQL Dump DumpTimer Download

Released: April 12, 2010 Added: April 22, 2010 Visits: 1.637

Auto Backup for MySQL Professional Edition is a powerful Windows program that makes it easy to schedule the backing up and restoring of your remote and local MySQL databases. It's easy to back up one or many MySQL databases, and restore them to the same server, or to any server. You can to...
Platforms: Windows

License: SharewareCost: $119.95 USDSize: 3.09 MBDownload (88): Auto Backup for MySQL Professional Download

Added: April 01, 2010 Visits: 1.021

Hosting Backup provides a set of scripts for backing up your hosted Web sites. Hosting Backup is a set if PHP command line scripts that provides an easy way to backup hosted Web sites to your local computer. It works with sites hosted on Linux servers with MySQL databases using FTP....
Platforms: *nix

License: FreewareDownload (82): Hosting Backup Download

Added: November 24, 2010 Visits: 1.232

MySQL Backup for lazy sysadmins (mysqlblasy) is a Perl script for automating MySQL database backups. It uses 'mysqldump' for dumping mysql databases to the files sytem. MySQL Backup for lazy sysadmins program was written with automated usage in mind. For example, it is silent during operation,...
Platforms: *nix

License: FreewareSize: 17.41 KBDownload (103): MySQL Backup for lazy sysadmins Download

Mysqldump Format


Added: October 07, 2010 Visits: 1.022

JdbcTool project is a collection of command line utilities for making your life easy when working with Java JDBC databases. Included are: jdbctool: An interactive command line tool for executing SQL statements. jdbcdump: Dump the contents of a database as SQL statements into a file, like...
Platforms: *nix

License: FreewareSize: 90.11 KBDownload (73): JdbcTool Download

Released: September 22, 2012 Added: September 22, 2012 Visits: 296

Sobolsoft offers a solution for MySQL editing. This no-frills software makes database editing as easy as basic spreadsheet operations. You can add rows and columns to tables and edit cell content. This software features options to save tables locally as TXT, XLS, CSV, PDF, and XML. The simplicity...
Platforms: Windows

License: SharewareCost: $19.99 USDSize: 2.65 MBDownload (28): MySQL Editor Software Download

Released: September 07, 2012 Added: September 07, 2012 Visits: 169

JMyBackup is a simple graphical userinterface for mysql database backups. JMyBackup is easy to use (userinterface for mysqldump). To run JMyBackup there is no installation necessary.
Platforms: Windows, Mac, BSD, Linux

Mysqldump For Mac Installer

License: FreewareSize: 9.92 MBDownload (27): JMyBackup Download

Mysqldump For Mac
Added: May 10, 2013 Visits: 284

PyLucid project is a lightweight, OpenSource ( GPL 2.x or newer ) content management system ( CMS ) written in pure Python CGI. Nearly all output can be customized. No shell account is needed. To run PyLucid you need a standard Webserver with Python (at least v2.2.1) CGI and MySQL ( mySQLdb )....
Platforms: Windows, Mac, *nix, Python, BSD Solaris


12>

In this tutorial we will show you how to use backup and restore a MySQL database or tables.

1. MySQL – Backup examples

1.1 Quick reference – mysqldump

1.2 Backup a database ‘wrdp1’ to a SQL file ‘db.20160726.sql’

1.3 Backup and gzip together.

1.4 Back a table ‘wp_postmeta’ to a SQL file ‘wp_postmeta.sql’

2. MySQL – Restore examples

2.1 Quick reference – mysql

Note
If you are restoring back a SQL file, please use command mysql NOT mysqldump

Mysqldump For Mac Download

2.2 Restore back a SQL file ‘db.20160726.sql’ to a database ‘wrdp1’.

2.3 Restore back a gzip SQL file ‘db.20160726.sql.gz’ to a database ‘wrdp1’.

3. Case Study

Here is my MySQL backup and restore steps, just for self reference.

Mysqldump For Mac Shortcut

  1. SSH into a server ‘myserver1’
  2. Backup and gzip a database ‘db1’
  3. Download the backup file from ‘myserver1’ via SCP command
  4. Restore the backup file to a local database ‘local_db1’

Done.

Note
Please use this ultimate command for more example – mysqldump --help

References

Related Articles

Shortcut

mkyong

Founder of Mkyong.com, love Java and open source stuff. Follow him on Twitter. If you like my tutorials, consider make a donation to these charities.