Listing ID : 393
Created on 2007-09-26 at 7:40 PM
Author : Filipe Manuel da Silva Martins [geral@i-senso.com]
Online URL : http://www.search-scripts.com/scripts/php/scripts-and-programs/database-tools/i-senso-transsql-mysql.html
This script lets you dump a whole local database and load it to a remote host (or vice-versa). The differences between this script and the others are:
transSQL dumps the whole database: tables, views, stored procs, triggers, constraints... the works.
The script knows that a view depends on tables or other views. It is also aware that two tables can be linked to one another via a foreign key.
When loading, unless instructed otherwise, the script will continue working even if errors occur. In that case, it prints the error message and the statement that caused it (so you can correct it later).
transSQL is a single file. Just copy it to your server's webroot and everything (should) work, as long as you have a proper PHP and MySQL installation.
| Resource Specifications | |
| Platform(s): | Linux,Windows,Mac OSX,Sun Solaris,FreeBS |
| Database(s) | MYSQL,SQ |
| Version: | 1.1 |
| File Size: | < 100KB |
| Date Added: | 2007-09-26 |
| Last Updated: | 2007-10-01 |
| License Information | |
| License Type: | Other Free / Open Source License |
| License Information: | Just give credit to the author in derived work |
| Price: | 0 USD |
| Visit: | http://www.i-senso.com/scripts/transSQL_MySQL.txt |
| Download: | http://www.i-senso.com/scripts/transSQL_MySQL.txt |