ciao piero_mac scusa ma ieri non ci sono stata, puoi aiutarmi a fare questo trasferimento di db??
si tratta di trasferire il db da un computer ad un altro per ora, quindi in locale le versioni di php my sql e apache sono le ultime
Apache 2.2, PHP 5.2 e MySQL 5 su Windows xp
ho settato register global a on, ho dato il permesso di scrittura alla cartella temp e ho inserito nel php.ini questa riga
session.save_path = "C:\Documents and Settings\utente\Impostazioni locali\temp"
ora volevo provare a esportare dal command line client
come devo a fare:
io so così:
mysqldump ecom_db > ecomdbimport.sql
ma mi da
->
e non so come continuare!mi potete aiutare?? 
il file dove mi da l'errore è questo.
Codice PHP:
<?php
/* $Id: header_http.inc.php 7900 2005-11-24 08:15:00Z nijel $ */
// vim: expandtab sw=4 ts=4 sts=4:
if (isset($_REQUEST['GLOBALS']) || isset($_FILES['GLOBALS'])) {
die("GLOBALS overwrite attempt");
}
/**
* Sends http headers
*/
$GLOBALS['now'] = gmdate('D, d M Y H:i:s') . ' GMT';
header('Expires: ' . $GLOBALS['now']); // rfc2616 - Section 14.21
header('Last-Modified: ' . $GLOBALS['now']);
header('Cache-Control: no-store, no-cache, must-revalidate, pre-check=0, post-check=0, max-age=0'); // HTTP/1.1
header('Pragma: no-cache'); // HTTP/1.0
if (!defined('IS_TRANSFORMATION_WRAPPER')) {
// Define the charset to be used
header('Content-Type: text/html; charset=' . $GLOBALS['charset']);
}
?>
e il file di dump è questo:
-- phpMyAdmin SQL Dump
-- version 2.9.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 10 Gen, 2007 at 12:46 PM
-- Versione MySQL: 5.0.27
-- Versione PHP: 5.2.0
--
-- Database: `ecom_db`
--
Warning: Cannot modify header information - headers already sent by (output started at C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\export.php: 150) in C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\libraries\h eader_http.inc.php on line 13
Warning: Cannot modify header information - headers already sent by (output started at C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\export.php: 150) in C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\libraries\h eader_http.inc.php on line 14
Warning: Cannot modify header information - headers already sent by (output started at C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\export.php: 150) in C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\libraries\h eader_http.inc.php on line 15
Warning: Cannot modify header information - headers already sent by (output started at C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\export.php: 150) in C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\libraries\h eader_http.inc.php on line 16
Warning: Cannot modify header information - headers already sent by (output started at C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\export.php: 150) in C:\Programmi\Apache Software Foundation\Apache2.2\htdocs\phpmyadmin\libraries\h eader_http.inc.php on line 19
<!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="it" lang="it" dir="ltr">
<head>
<link rel="icon" href="./favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
<title>phpMyAdmin</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?token=e9b7296b5ffe23ee43e50bac4 3a328c5&js_frame=right" />
<link rel="stylesheet" type="text/css" href="./css/print.css?token=e9b7296b5ffe23ee43e50bac43a328c5" media="print" />
<script type="text/javascript" language="javascript">
// <![CDATA[
// 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 = 'localhost / localhost / ecom_db / clienti | phpMyAdmin 2.9.1.1';
}
// ]]>
</script>
<script src="./js/tooltip.js" type="text/javascript"
language="javascript"></script>
<meta name="OBGZip" content="false" />
<!--[if IE 6]>
<style type="text/css">
/* <![CDATA[ */
html {
overflow-y: scroll;
}
/* ]]> */
</style>
<![endif]-->
</head>
<body>
<div id="TooltipContainer" onmouseover="holdTooltip();" onmouseout="swapTooltip('default');"></div>
<div id="serverinfo">
<a href="main.php?token=e9b7296b5ffe23ee43e50bac43a32 8c5" class="item"> [img]./themes/original/img/s_host.png[/img]
Server: localhost</a>
<span class="separator">[img]./themes/original/img/item_ltr.png[/img]</span>
<a href="db_details_structure.php?db=ecom_db&toke n=e9b7296b5ffe23ee43e50bac43a328c5" class="item"> [img]./themes/original/img/s_db.png[/img]
Database: ecom_db</a>
<span class="separator">[img]./themes/original/img/item_ltr.png[/img]</span>
<a href="tbl_properties_structure.php?db=ecom_db& table=clienti&token=e9b7296b5ffe23ee43e50bac43 a328c5" class="item"> [img]./themes/original/img/s_tbl.png[/img]
Tabella: clienti</a>
<span class="table_comment" id="span_table_comment">"Table 'ecom_db.clienti' doesn't exist"</span>
</div>
<div class="error"><h1>Errore</h1>
query SQL:
[img] ./themes/original/img/b_edit.png[/img] </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">`ecom_db`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`clienti`</span> </span>
</p>
Messaggio di MySQL: [img]./themes/original/img/b_help.png[/img]
</p>
<code>
#1146 - Table 'ecom_db.clienti' doesn't exist
</code>
</div><fieldset class="tblFooters"> </fieldset>
<script type="text/javascript" language="javascript">
//<![CDATA[
// updates current settings
if (window.parent.setAll) {
window.parent.setAll('it-utf-8', 'utf8_general_ci', '1', 'ecom_db', 'clienti');
}
// set current db, table and sql query in the querywindow
if (window.parent.refreshNavigation) {
window.parent.reload_querywindow(
'ecom_db',
'clienti',
'');
}
if (window.parent.frame_content) {
// reset content frame name, as querywindow needs to set a unique name
// before submitting form data, and navigation frame needs the original name
if (window.parent.frame_content.name != 'frame_content') {
window.parent.frame_content.name = 'frame_content';
}
if (window.parent.frame_content.id != 'frame_content') {
window.parent.frame_content.id = 'frame_content';
}
//window.parent.frame_content.setAttribute('name', 'frame_content');
//window.parent.frame_content.setAttribute('id', 'frame_content');
}
//]]>
</script>
</body>
</html>
Rispondi quotando
