PHP Script Codes > i-senso transSQL
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:
* supports tables, views, Stored Procedures, triggers and constraints;
* is inter-dependency aware;
* is error tolerant;
* very easy to install -- it's a single file.
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.