MattKendrick.com

I’ve been working on a new PHP script to help people restore individual MySQL tables from a MySQL Dump file. You may recall my post on having a backup plan. This tool works great with another great tool called BigDump.

PHP MySQLDump Browser
Version 0.01 Beta
Author: Matt Kendrick (yeah! that’s me)

DESCRIPTION:
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 script to avoid restoring entire backups to recover individual tables.
Database dumps complied by mysqldump and phpMyAdmin are compatible with this tool.
Note: This is an unofficial tool released under the GNU General Public License.
PHP MySQLDump Browser creators have no affiliation with Sun Microsystems.

INSTRUCTIONS:
1. Place the script on your webserver or webhost in the same directory as your MySQL backup dumps.
2. Run the script.
3. Choose which backup file you want to search. The script will search through the
dump file for table structures and data. Depending on the size of the dump, this may take some time.

4. Once the script has finished indexing the dump file, you may choose which table you wish to extract or
view. By default the results of your query will display in the iframe at the bottom of the page. However
you may download the results to file by clicking the download link above the iframe.

IMPORTANT: Remove PHP MySQLDump Browser as soon as you are finished.

COPYRIGHT AND DISCLAIMER:
THIS SCRIPT IS PROVIDED AS IS, WITHOUT ANY WARRANTY OR GUARANTEE OF ANY KIND
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General
Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option)
any later version. If you change this script or add any features please tell me.

PHP MySQLDump Browser (1379)

Today’s post is kinda short. Thought I’d tell ya about a neat tool I used today.

Ever needed to do a large MySQL import, but your host doesn’t allow big uploads/imports through phpMyAdmin? Or have you performed an import and have it timeout half way through? Well not anymore thanks to a handy php script call BigDump. The tool that allows you to do large imports through your browser.

To run the script,  upload bigdump.php to your site. Then you’ll need to edit that file to configure a database connection. Once that is set, you can either upload through BigDump’s interface (25 meg limit) or point it to a  file on your site. BigDump will list the uploaded dump files, just click “start import” and the script will start importing your dump. It’s able to avoid the limitations of hosting companies through staggering. Basically it only performs a small part of the import at a time and then reloads the script to get the next little bit. Please remember to delete the script when you’re done. Or anyone can run queries on your database.

There ya have it, a cool tool with a funny name!

http://www.ozerov.de/bigdump.php