pureMango.co.uk
there's nothing about mangos or purity. It's just a name..
db2sql v1.04
A PHP file that connects to a specified host and mySQL database, and generates the SQL queries needed to reconstruct the database. Very useful for backing up a database that you can't connect to remotely.
Features/Options:
-backup either structure, data, both or just test connection
-backup only specified tables or all
-view all databases
-suports multi-column keys, all field types, autoinc fields, etc.
-escapes all field data
-saves as db_name.sql
-fully functionalised to allow for easy customisation
source - screenshot - see sample of generated SQL
User Comments:Who: Gio'
When: February 2nd, 2005
Says: Very nice. Simple N powerful
Who: sTEVE
When: February 3rd, 2005
Says: Real nice! Saved me lots of headaches!
Who: Jim
When: February 18th, 2005
Says: Cool! I like this.
But when I choose only structure there will not download the sql file instead display in browser.
Who: u24
When: February 18th, 2005
Says: I can't see why it should happen on structure and not data, but I've changed the headers a bit, so try it now.
Who:
When: March 11th, 2005
Says: When doing a backup of a specific table it outputs this query:
INSERT INTO registered2005 VALUES('31','63','1','');
What it does't have is the fields that the data should be inserted into. It should look like this:
INSERT INTO `registered2005` ( `Account_ID` , `Player_ID` , `Status` , `entered` ) VALUES ('33', '61', '1', '');
Any ideas on how to fix it?
Who: u24
When: March 11th, 2005
Says: this is fine; it will still run the query - specifying fields on each insert is just a waste of valuable bytes.
If you find that the query doesn't work, email me and I'll send you a version of the code that includes field names for each insert.
Who: costin / romania
When: April 23rd, 2005
Says: GREAT ONE !
thank you
Who: Scott
When: September 28th, 2005
Says: Nice!
Is there anyway to generate extended inserts?
Take care...
---
from u24:
hmm.. I've never heard of 'extended inserts'; email me an example, I'm sure it's possible.
Who:
When: March 5th, 2006
Says: It really helped me..........
the source code has been written in such a simple way that even without being master of PHP u can fully understand that.....
i suggest that .. u use this code for X'ferring ur databases to remote places...
IT'sREALLY AWSOME
----
from u24:
why thankyou :-)
Who: u24
When: March 9th, 2006
Says: actually you've hit on a really good idea.
expect a future version that allows you to make two connections and copies the db from one host to another.
but don't expect it soon.
Who: ksen99
When: December 4th, 2006
Says: hey well its been abt 9 months now :) is the code ready??
---
from u24:
nope! but I am doing some updates to the site over Xmas, so maybe by mid january - thanks for checking back though. sorry I'm so lazy :-)
Who:
When: January 21st, 2007
Says: i very need this
Who: Pyker
When: May 10th, 2008
Says: Nice script!
Save me a ton of work!
Thanks for it.
Add your comments:* denotes a required field.
Your email address will be converted to an image to prevent spambots picking it up.
