<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
<head>
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<base href="http://sql.cic/" />
<style type="text/css">
<!--
body {
font-family: arial, helvetica, geneva, sans-serif;
font-size: small;
color: #000000;
background-image: url('./images/vertical_line.png');
background-repeat: repeat-y;
background-color: #F5F5F5
}
pre, tt {font-size: small}
th {font-family: arial, helvetica, geneva, sans-serif; font-size: small; font-weight: bold; color: #000000; background-color: #D3DCE3}
td {font-family: arial, helvetica, geneva, sans-serif; font-size: small}
form {font-family: arial, helvetica, geneva, sans-serif; font-size: small}
input {font-family: arial, helvetica, geneva, sans-serif; font-size: small}
input.textfield {font-family: arial, helvetica, geneva, sans-serif; font-size: small; color: #000000; background-color: #FFFFFF}
select {font-family: arial, helvetica, geneva, sans-serif; font-size: small; color: #000000; background-color: #FFFFFF}
textarea {font-family: arial, helvetica, geneva, sans-serif; font-size: small; color: #000000; background-color: #FFFFFF}
h1 {font-family: arial, helvetica, geneva, sans-serif; font-size: large; font-weight: bold}
h2 {font-family: arial, helvetica, geneva, sans-serif; font-size: medium; font-weight: bold}
h3 {font-family: arial, helvetica, geneva, sans-serif; font-size: small; font-weight: bold}
a:link {font-family: arial, helvetica, geneva, sans-serif; font-size: small; text-decoration: none; color: #0000FF}
a:visited {font-family: arial, helvetica, geneva, sans-serif; font-size: small; text-decoration: none; color: #0000FF}
a:hover {font-family: arial, helvetica, geneva, sans-serif; font-size: small; text-decoration: underline; color: #FF0000}
a.nav:link {font-family: arial, helvetica, geneva, sans-serif; color: #000000}
a.nav:visited {font-family: arial, helvetica, geneva, sans-serif; color: #000000}
a.nav:hover {font-family: arial, helvetica, geneva, sans-serif; color: #FF0000}
a.h1:link {font-family: arial, helvetica, geneva, sans-serif; font-size: large; font-weight: bold; color: #000000}
a.h1:active {font-family: arial, helvetica, geneva, sans-serif; font-size: large; font-weight: bold; color: #000000}
a.h1:visited {font-family: arial, helvetica, geneva, sans-serif; font-size: large; font-weight: bold; color: #000000}
a.h1:hover {font-family: arial, helvetica, geneva, sans-serif; font-size: large; font-weight: bold; color: #FF0000}
a.h2:link {font-family: arial, helvetica, geneva, sans-serif; font-size: medium; font-weight: bold; color: #000000}
a.h2:active {font-family: arial, helvetica, geneva, sans-serif; font-size: medium; font-weight: bold; color: #000000}
a.h2:visited {font-family: arial, helvetica, geneva, sans-serif; font-size: medium; font-weight: bold; color: #000000}
a.h2:hover {font-family: arial, helvetica, geneva, sans-serif; font-size: medium; font-weight: bold; color: #FF0000}
a.drop:link {font-family: arial, helvetica, geneva, sans-serif; color: #ff0000}
a.drop:visited {font-family: arial, helvetica, geneva, sans-serif; color: #ff0000}
a.drop:hover {font-family: arial, helvetica, geneva, sans-serif; color: #ffffff; background-color:#ff0000; text-decoration: none}
dfn {font-style: normal}
dfn:hover {font-style: normal; cursor: help}
.nav {font-family: arial, helvetica, geneva, sans-serif; color: #000000}
.warning {font-family: arial, helvetica, geneva, sans-serif; font-size: small; font-weight: bold; color: #FF0000}
td.topline {font-size: 1px}
.small {font-size: 5px;}
td.tab {
border-top: 1px solid #999;
border-right: 1px solid #666;
border-left: 1px solid #999;
border-bottom: none;
border-radius: 2px;
-moz-border-radius: 2px;
}
table.tabs {
border-top: none;
border-right: none;
border-left: none;
border-bottom: 1px solid #666;
}
.print{font-family:arial;font-size:8pt;}
.syntax {font-family: sans-serif; font-size: x-small;}
.syntax_comment {}
.syntax_digit {}
.syntax_digit_hex {}
.syntax_digit_integer {}
.syntax_digit_float {}
.syntax_punct {}
.syntax_alpha {text-transform: lowercase;}
.syntax_alpha_columnType {text-transform: uppercase;}
.syntax_alpha_columnAttrib {text-transform: uppercase;}
.syntax_alpha_reservedWord {text-transform: uppercase; font-weight: bold;}
.syntax_alpha_functionName {text-transform: uppercase;}
.syntax_alpha_identifier {}
.syntax_alpha_variable {}
.syntax_quote {}
.syntax_quote_backtick {}
.syntax_comment {color: #808000;}
.syntax_comment_mysql {}
.syntax_comment_ansi {}
.syntax_comment_c {}
.syntax_digit {}
.syntax_digit_hex {color: teal;}
.syntax_digit_integer {color: teal;}
.syntax_digit_float {color: aqua;}
.syntax_punct {color: fuchsia;}
.syntax_alpha {}
.syntax_alpha_columnType {color: #FF9900;}
.syntax_alpha_columnAttrib {color: #0000FF;}
.syntax_alpha_reservedWord {color: #990099;}
.syntax_alpha_functionName {color: #FF0000;}
.syntax_alpha_identifier {color: black;}
.syntax_alpha_variable {color: #800000;}
.syntax_quote {color: #008000;}
.syntax_quote_double {}
.syntax_quote_single {}
.syntax_quote_backtick {}
.syntax_indent0 {margin-left: 0em;}
.syntax_indent1 {margin-left: 1em;}
.syntax_indent2 {margin-left: 2em;}
.syntax_indent3 {margin-left: 3em;}
.syntax_indent4 {margin-left: 4em;}
.syntax_indent5 {margin-left: 5em;}
.syntax_indent6 {margin-left: 6em;}
.syntax_indent7 {margin-left: 7em;}
fieldset {
border: #686868 solid 1px;
padding: 0.5em;
}
fieldset fieldset {
margin: 0.8em;
}
//-->
</style>
<script type="text/javascript" language="javascript">
<!--
// Updates the title of the frameset if possible (ns4 does not allow this)
if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown'
&& typeof(parent.document.title) == 'string') {
parent.document.title = 'test.test running on localhost - phpMyAdmin 2.4.1-dev';
}
// js form validation stuff
var errorMsg0 = 'Missing value in the form !';
var errorMsg1 = 'This is not a number!';
var errorMsg2 = ' is not a valid row number!';
var noDropDbMsg = '"DROP DATABASE" statements are disabled.';
var confirmMsg = 'Do you really want to ';
//-->
</script>
<script src="libraries/functions.js" type="text/javascript" language="javascript"></script>
<script>
if (top.frames.queryframe) {
top.frames.queryframe.document.queryframeform.db.value = "test";
top.frames.queryframe.document.queryframeform.table.value = "test";
}
function reload_querywindow () {
if (top.frames.queryframe && top.frames.queryframe.querywindow && !top.frames.queryframe.querywindow.closed && top.frames.queryframe.querywindow.location) {
top.frames.queryframe.querywindow.document.querywindow.db.value = "test";
top.frames.queryframe.querywindow.document.querywindow.query_history_latest_db.value = "test";
top.frames.queryframe.querywindow.document.querywindow.table.value = "test";
top.frames.queryframe.querywindow.document.querywindow.query_history_latest_table.value = "test";
top.frames.queryframe.querywindow.document.querywindow.submit();
}
}
function focus_querywindow() {
if (top.frames.queryframe && top.frames.queryframe.querywindow && !top.frames.queryframe.querywindow.closed && top.frames.queryframe.querywindow.location) {
top.frames.queryframe.querywindow.focus();
} else if (top.frames.queryframe) {
top.frames.queryframe.querywindow=window.open('querywindow.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test', 'js_querywindow','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=yes,resizable=yes,width=550,height=310');
if (!top.frames.queryframe.querywindow.opener) {
top.frames.queryframe.querywindow.opener = top.frames.queryframe;
}
reload_querywindow();
}
}
reload_querywindow();
self.focus();
</script>
</head>
<body bgcolor="#F5F5F5">
<h1>
Database <i><a class="h1" href="db_details_structure.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test">test</a></i>
- Table <i><a class="h1" href="tbl_properties_structure.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test">test</a></i>
running on <i><a class="h1" href="main.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2">localhost</a></i>
</h1>
<!-- top menu -->
<table border="0" cellspacing="0" cellpadding="3" width="100%" class="tabs">
<tr>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_properties_structure.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Structure</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="sql.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3&sql_query=SELECT+%2A+FROM+%60test%60&pos=0"><nobr><b>Browse</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_properties.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>SQL</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_select.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Select</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_change.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Insert</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="silver" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_properties_export.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Export</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_properties_operations.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Operations</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="tbl_properties_options.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3"><nobr><b>Options</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="sql.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=tbl_properties_export.php3&sql_query=DELETE+FROM+%60test%60&zero_rows=Table+test+has+been+emptied" class="drop" onclick="return confirmLink(this, 'DELETE FROM `test`')"><nobr><b>Empty</b></a></nobr>
</td>
<td width="8"> </td>
<td bgcolor="#DFDFDF" align="center" width="64" nowrap="nowrap" class="tab">
<a href="sql.php3?lang=en-utf-8&server=1&convcharset=iso-8859-2&db=test&table=test&goto=tbl_properties_export.php3&back=db_details.php3&reload=1&purge=1&sql_query=DROP+TABLE+%60test%60&zero_rows=Table+test+has+been+dropped" class="drop" onclick="return confirmLink(this, 'DROP TABLE `test`')"><nobr><b>Drop</b></a></nobr>
</td>
<td width="8"> </td>
</tr></table><br />
<!-- Dump of a table -->
<h2>
View dump (schema) of table
</h2>
<form method="post" action="tbl_dump.php3" name="tbl_dump">
<input type="hidden" name="lang" value="en-utf-8" />
<input type="hidden" name="server" value="1" />
<input type="hidden" name="convcharset" value="iso-8859-2" />
<input type="hidden" name="db" value="test" />
<input type="hidden" name="table" value="test" />
<table cellpadding="5" border="0" cellspacing="0">
<tr>
<script type="text/javascript">
<!--
/* DHTML functions */
d=document;l=(d.layers)?1:0;op=navigator.userAgent.toLowerCase().indexOf('opera')!=-1;
/* Get Element */ function gE(e,f){if(l){f=(f)?f:self;V=f.document.layers;if(V[e])return V[e];for(W=0;i<W.length;W++)return(gE(e,V[W]));}if(d.all)return d.all[e];return d.getElementById(e);}
/* Show Element */ function sE(e){if(l)e.visibility='show';else e.style.visibility='visible';}
/* Hide Element */ function hE(e){if(l)e.visibility='hide';else e.style.visibility='hidden';}
/* Set Position X */ function sX(e,x){if(l)e.left=x;else if(op)e.style.pixelLeft=x;else e.style.left=x+'px';}
/* Get Position X */ function gX(e){if(l)return e.left;else if(op)return e.style.pixelLeft;else return parseInt(e.style.left);}
/* Set Position Y */ function sY(e,y){if(l)e.top=y;else if(op)e.style.pixelTop=y;else e.style.top=y+'px';}
/* Get Position Y */ function gY(e){if(l)return e.top;else if(op)return e.style.pixelTop;else return parseInt(e.style.top);}
/* Set Width */ function sW(e,w){if(l)e.clip.width=w;else if(op)e.style.pixelWidth=w;else e.style.width=w;}
/* Get Width */ function gW(e){if(l)return e.clip.width;else if(op)return e.style.pixelWidth;else return parseInt(e.style.width);}
/* Set Height */ function sH(e,h){if(l)e.clip.height=h;else if(op)e.style.pixelHeight=h;else e.style.height=h;}
/* Get Height */ function gH(e){if(l)return e.clip.height;else if(op)return e.style.pixelHeight;else return parseInt(e.style.height);}
/* Write h to e */ function wH(e,h){if(l){Y=e.document;Y.write(h);Y.close();}if(e.innerHTML)e.innerHTML=h;}
function hide_them_all() {
gE("csv_options").style.display = 'none';
gE("sql_options").style.display = 'none';
gE("none_options").style.display = 'none';
}
//-->
</script>
<!-- Formats to export to -->
<td nowrap="nowrap" valign="top">
<fieldset>
<legend>Export format</legend><br class=small />
<!-- SQL -->
<input type="radio" name="what" value="sql" id="radio_dump_sql" checked="checked" onclick="if(this.checked) { hide_them_all(); gE('sql_options').style.display = 'block'; }; return true" />
<label for="radio_dump_sql">SQL</label>
<br /><br />
<!-- LaTeX table -->
<input type="radio" name="what" value="latex" id="radio_dump_latex" onclick="if(this.checked) { hide_them_all(); gE('none_options').style.display = 'block'; }; return true" />
<label for="radio_dump_latex">LaTeX</label>
<!-- for now we have only one environment supported -->
<input type="hidden" name="environment" value="longtable" />
<br /><br />
<!-- Excel CSV -->
<input type="radio" name="what" value="excel" id="radio_dump_excel" onclick="if(this.checked) { hide_them_all(); gE('none_options').style.display = 'block'; }; return true" />
<label for="radio_dump_excel">CSV for MS Excel</label>
<br /><br />
<!-- General CSV -->
<input type="radio" name="what" value="csv" id="radio_dump_csv" onclick="if(this.checked) { hide_them_all(); gE('csv_options').style.display = 'block'; }; return true" />
<label for="radio_dump_csv">CSV</label>
<br /><br />
<!-- XML -->
<input type="radio" name="what" value="xml" id="radio_dump_xml" onclick="if(this.checked) { hide_them_all(); gE('none_options').style.display = 'block'; }; return true" />
<label for="radio_dump_xml">XML</label>
</fieldset>
<br /><br /><br />
</td>
<!-- Options -->
<td valign="top" id="options_td" width="400">
<fieldset id="sql_options">
<legend>SQL options (<a href="./Documentation.html#faqexport" target="documentation">Documentation</a>)</legend>
<!-- For structure -->
<fieldset>
<legend>
<input type="checkbox" name="sql_structure" value="structure" id="checkbox_sql_structure" checked="checked" onclick="if(!this.checked && !gE('checkbox_sql_data').checked) return false; else return true;" />
<label for="checkbox_sql_structure">Dump structure</label><br />
</legend>
<input type="checkbox" name="drop" value="1" id="checkbox_dump_drop" />
<label for="checkbox_dump_drop">Add 'drop table'</label><br />
<input type="checkbox" name="use_backquotes" value="1" id="checkbox_dump_use_backquotes" checked="checked" />
<label for="checkbox_dump_use_backquotes">Enclose table and field names with backquotes</label><br />
<input type="checkbox" name="use_comments" value="1" id="checkbox_dump_use_comments" />
<label for="checkbox_dump_use_comments">Include column comments as inline SQL-comments</label><br />
</fieldset>
<!-- For data -->
<fieldset>
<legend>
<input type="checkbox" name="sql_data" value="data" id="checkbox_sql_data" checked="checked" onclick="if(!this.checked && !gE('checkbox_sql_structure').checked) return false; else return true;" />
<label for="checkbox_sql_data">Dump data</label><br />
</legend>
<input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" />
<label for="checkbox_dump_showcolumns">Complete inserts</label><br />
<input type="checkbox" name="extended_ins" value="yes" id="checkbox_dump_extended_ins" />
<label for="checkbox_dump_extended_ins">Extended inserts</label><br />
</fieldset>
</fieldset>
<fieldset id="csv_options">
<legend>CSV options</legend>
<table border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
Fields terminated by
</td>
<td>
<input type="text" name="separator" size="2" value=";" class="textfield" />
</td>
</tr>
<tr>
<td>
Fields enclosed by
</td>
<td>
<input type="text" name="enclosed" size="2" value=""" class="textfield" />
</td>
</tr>
<tr>
<td>
Fields escaped by
</td>
<td>
<input type="text" name="escaped" size="2" value="\" class="textfield" />
</td>
</tr>
<tr>
<td>
Lines terminated by
</td>
<td>
<input type="text" name="add_character" size="2" value="\n" class="textfield" />
</td>
</tr>
</table>
<input type="checkbox" name="showcsvnames" value="yes" id="checkbox_dump_showcsvnames" />
<label for="checkbox_dump_showcsvnames">Put fields names at first row</label>
</fieldset>
<div id="none_options">
This format has no options.
</div>
<script type="text/javascript">
<!--
gE('csv_options').style.display = 'none';
gE('sql_options').style.display = 'none';
gE('none_options').style.display = 'none';
if (document.getElementById('radio_dump_sql').checked) {
gE('sql_options').style.display = 'block';
} else if (document.getElementById('radio_dump_csv').checked) {
gE('csv_options').style.display = 'block';
} else {
gE('none_options').style.display = 'block';
}
//-->
</script>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<fieldset>
Dump <input type="text" name="limit_to" size="5" value="8" class="textfield" style="vertical-align: middle" onfocus="this.select()" /> row(s) starting at record # <input type="text" name="limit_from" value="0" size="5" class="textfield" style="vertical-align: middle" onfocus="this.select()" />.
</fieldset>
</td>
</tr>
<tr>
<!-- Export to screen or to file -->
<td colspan="2">
<fieldset>
<legend>
<input type="checkbox" name="asfile" value="sendit" id="checkbox_dump_asfile" />
<label for="checkbox_dump_asfile">Save as file</label>
</legend>
<label for="select_charset_of_file">Character set of the file:</label>
<select id="select_charset_of_file" name="charset_of_file" size="1">
<option value="iso-8859-1">iso-8859-1</option>
<option value="iso-8859-2">iso-8859-2</option>
<option value="iso-8859-3">iso-8859-3</option>
<option value="iso-8859-4">iso-8859-4</option>
<option value="iso-8859-5">iso-8859-5</option>
<option value="iso-8859-6">iso-8859-6</option>
<option value="iso-8859-7">iso-8859-7</option>
<option value="iso-8859-8">iso-8859-8</option>
<option value="iso-8859-9">iso-8859-9</option>
<option value="iso-8859-10">iso-8859-10</option>
<option value="iso-8859-11">iso-8859-11</option>
<option value="iso-8859-12">iso-8859-12</option>
<option value="iso-8859-13">iso-8859-13</option>
<option value="iso-8859-14">iso-8859-14</option>
<option value="iso-8859-15">iso-8859-15</option>
<option value="windows-1250">windows-1250</option>
<option value="windows-1251">windows-1251</option>
<option value="windows-1252">windows-1252</option>
<option value="windows-1257">windows-1257</option>
<option value="koi8-r">koi8-r</option>
<option value="big5">big5</option>
<option value="gb2312">gb2312</option>
<option value="utf-8" selected="selected">utf-8</option>
<option value="utf-7">utf-7</option>
<option value="x-user-defined">x-user-defined</option>
<option value="euc-jp">euc-jp</option>
<option value="ks_c_5601-1987">ks_c_5601-1987</option>
<option value="tis-620">tis-620</option>
<option value="SHIFT_JIS">SHIFT_JIS</option>
</select>
<fieldset>
<legend>Compression</legend>
<input type="radio" name="compression" value="none" id="radio_compression_none" checked="checked" />
<label for="radio_compression_none">none</label>
<input type="radio" name="compression" value="zip" id="radio_compression_zip" />
<label for="radio_compression_zip">zip</label>
<input type="radio" name="compression" value="gzip" id="radio_compression_gzip" />
<label for="radio_compression_gzip">Gzip</label>
<input type="radio" name="compression" value="bzip" id="radio_compression_bzip" />
<label for="radio_compression_bzip">Bzip</label>
</fieldset>
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" value="Go" />
</td>
</tr>
</table>
</form>
</body>
</html>