| Formally Mikor. Name: Michael Walker Location: East Yorkshire, England Join Date: Aug 2005
Posts: 2,438
NP$: 95.25 ( Donate)
| MySQL Dump Script
This script returns the table structures of every table in every database.
To use just edit the variables at the top of the script.
If you find any bugs tell me. And yes, I will make it dump table contents sometime, lol PHP Code: <?php
set_time_limit(0);
$db['host'] = '';
$db['user'] = '';
$db['pass'] = '';
function error($error_msg){
die('<script>
alert("An error occured!");
alert("'.$error_msg.'");
</script>');
}
mysql_connect($db['host'],$db['user'],$db['pass'])or error(mysql_error());
$databases = mysql_query('SHOW DATABASES;')or error(mysql_error());
$i=0;
while($i<mysql_num_rows($databases)){
mysql_select_db(mysql_result($databases,$i));
$tables=mysql_query('SHOW TABLES;')or error(mysql_error());
echo 'CREATE DATABASE `'.mysql_result($databases,$i).'`<br />';
$i2=0;
while($i2<mysql_num_rows($tables)){
$fields=mysql_query('DESCRIBE `'.mysql_result($tables,$i2).'`;')or error(mysql_error());
echo 'CREATE TABLE `'.mysql_result($tables,$i2).'`(<br />';
$i3=0;
while($i3<mysql_num_rows($fields)){
echo ' `'.mysql_result($fields,$i3,'field').'` '.mysql_result($fields,$i3,'type');
if(mysql_result($fields,$i3,'null') != 'NULL'){
echo ' NOT NULL';
if(mysql_result($fields,$i3,'default') != ''){
echo ' DEFAULT \''.mysql_result($fields,$i3,'default').'\'';
}
}else{
echo ' DEFAULT NULL';
}
echo '<br />';
$i3++;
}
echo ')<br /><br />';
$i2++;
}
$i++;
}
?>
|
