mysql 내려받기 질문입니다; 정보
mysql 내려받기 질문입니다;본문
디비이전 때문에 phpmyadmin 에서 내려받기 하면
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl2
-- http://www.phpmyadmin.net
--
-- 호스트: localhost
-- 처리한 시간: 09-08-04 10:50
-- 서버 버전: 3.23.55
-- PHP 버전: 4.4.7
--
-- 데이터베이스: `nixcenter`
--
<!-- PMA-SQL-ERROR -->
<table border="0" cellpadding="2" cellspacing="1"> <tr>
<th class="tblHeadError"><div class="errorhead">오류</div></th>
</tr>
<tr>
<td><div class="tblWarn"><p>
<b>SQL 질의:</b>
<a href="tbl_properties.php?lang=ko-euc-kr&server=1&db=nixcenter&sql_query=SHOW+CREATE+TABLE+%60nixcenter%60.&show_query=1"><img src=" ./themes/original/img/b_edit.png" width="16" height="16" border="0" hspace="2" align="middle" alt="수정" /></a></p>
<p>
<span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span> <span class="syntax_alpha syntax_alpha_reservedWord">CREATE</span> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_quote syntax_quote_backtick">`nixcenter`</span><span class="syntax_punct syntax_punct_qualifier">.</span></span>
</p></div>
<div class="tblWarn"><p>
<b>MySQL 메시지: </b><a href="http://dev.mysql.com/doc/mysql/en/Error-returns.html" target="mysql_doc"><img src="./themes/original/img/b_help.png" width="11" height="11" border="0" alt="도움말" title="도움말" hspace="2" align="middle" /></a>
</p>
<code>
#1064 - 'SQL 구문에 오류가 있습니다.' 에러 같읍니다. ('' 명령어 라인 1)
</code><br /><br />
</div> </td>
</tr>
</table>
<script type="text/javascript">
<!--
function reload_querywindow () {
if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
// no submit, query was invalid
}
}
function focus_querywindow(sql_query) {
if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
if (parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab != 'sql') {
parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab.value = "sql";
parent.frames.queryframe.querywindow.document.querywindow.query_history_latest.value = sql_query;
parent.frames.queryframe.querywindow.document.querywindow.submit();
parent.frames.queryframe.querywindow.focus();
} else {
parent.frames.queryframe.querywindow.focus();
}
return false;
} else if (parent.frames.queryframe) {
new_win_url = 'querywindow.php?sql_query=' + sql_query + '&lang=ko-euc-kr&server=1&db=nixcenter';
parent.frames.queryframe.querywindow=window.open(new_win_url, '','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=yes,resizable=yes,width=550,height=310');
if (!parent.frames.queryframe.querywindow.opener) {
parent.frames.queryframe.querywindow.opener = parent.frames.queryframe;
}
// reload_querywindow();
return false;
}
}
reload_querywindow();
//-->
</script>
</body>
</html>
db.sql 파일 내용입니다.
해결방안좀 알려주셔요;;
댓글 전체
