Ai giúp em lỗi này với về host 6te

kitarosanza · 16/2/08

Em dùng host 6te sau khi up hết lên xong vào file bigdump thì nó hiện thị thế này
Database connection failed due to Access denied for user 'b2online.6te.net'@'localhost' (using password: YES)
http://b2leloi.6te.net/bigdump.php
Tức là chưa liên kết database với use ai sài host này rồi thì giúp em với

korangar · 16/2/08

Config lại cái database trong file bigdump cho nó chính xác.

kitarosanza · 17/2/08

em chỉnh lại hết các thông số có thể rồi mà vẫn ko đc anh xem hộ em với

<?php

// BigDump ver. 0.21b from 2005-02-08
// Staggered import of an large MySQL Dump (like phpMyAdmin 2.x Dump)
// Even through the webservers with hard runtime limit and those in safe mode
// Works fine with Internet Explorer 6.0 SP1, Mozilla 1.x and even Netscape 4.8

// Author: Alexey Ozerov (alexey at ozerov dot de)
// Copyright: GPL (C) 2003-2005
// More Infos: http://www.ozerov.de/bigdump

// This program is free software; you can redistribute it and/or modify it under the
// terms of the GNU General Public License as published by the Free Software Foundation;
// either version 2 of the License, or (at your option) any later version.

// THIS SCRIPT IS PROVIDED AS IS, WITHOUT ANY WARRANTY OR GUARANTEE OF ANY KIND

// USAGE:

// 1. Adjust the database configuration in this file
// 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE"
// 3. Create the working directory (e.g. dump) on your web-server
// 4. If you want to upload the dump files directly from the web-browser give the scripts
// writing permissions on the working directory (chmod 777 on a Linux based system)
// 5. Upload bigdump.php and your dump files (.sql, .gz) via FTP to the working directory
// 6. Run the bigdump.php from your browser via URL like http://www.yourdomain.com/dump/bigdump.php
// 7. BigDump will start the next import session automatically if you enable the JavaScript
// 8. Wait for the script to finish, do not close the browser window
// 9. IMPORTANT: Remove bigdump.php and your dump files from the web-server

// If Timeout errors still occure you may need to adjust the $linepersession setting in this file

// VERSION HISTORY

// Version 0.21b 2005-02-08
// *** extended inserts giveup bugfix (don't count linebreaks within text fields)

// Version 0.20b 2005-01-05
// *** short_open_tag=off bugfix
// *** stop processing on extended insert
// *** disable upload of PHP files
// *** minor bugfixes

// Version 0.19b 2004-05-31
// *** # comment in the text field bugfix

// Version 0.18b 2004-03-18
// *** \\' in the text field bugfix

// Version 0.17b 2003-12-14
// *** MySQL deprecated '-- ' comment bugfix
// *** Drop user-defined proprietary comment lines
// *** Improved anti-cache headers

// Version 0.16b 2003-11-20
// *** Register globals bugfix

// Version 0.15b 2003-11-02
// *** Dump file browser upload feature added (for dump files up to upload_max_filesize)
// *** Dump file mini-browser for the working directory added

// Version 0.14b 2003-10-12
// *** GZip compressed files support added (available with PHP 4.3.0+)

// Version 0.13b 2003-10-09
// *** Query definition bugfix: don't stop query inside an text field ending by ';'
// *** Query definition bugfix: don't trim queries since spaces can be useful :-)
// *** $delaypersession setting added

// Version 0.12 2003-07-11
// *** File seek by fseek() instead of line skipping should avoid time loss when skipping lines
// Thanks to Anton Hummel for this idea

// Version 0.11 2003-03-11
// *** Table definition bugfix: don't stop session inside an SQL query
// *** Queries statistics added

// Database configuration

$db_server = "localhost";
$db_name = "135974";
$db_username = "b2online.6te.net";
$db_password = "123456";

// Other Settings

$filename = ""; // Specify the dump filename to suppress the file selection dialog
$linespersession = 3000; // Lines to be executed per one import session
$delaypersession = 0; // You can specify a sleep time in milliseconds after each session
// Works only if JavaScript is activated. Use to reduce server overrun

// Allowed comment delimiters: lines starting with these strings will be dropped by BigDump

$comment[0]="#"; // Standard comment lines are dropped by default
$comment[1]="-- ";
// $comment[2]="---"; // Uncomment this line if using proprietary dump created by outdated mysqldump
// $comment[3]=""; // Or add your own string to leave out other proprietary things

// *******************************************************************************************
// If not familiar with PHP please don't change anything below this line
// *******************************************************************************************

define ("VERSION","0.21b");
define ("MAX_LINE_LENGTH",65536);
define ("MAX_QUERY_LINES",300);

ini_set("auto_detect_line_endings", true);

header("Expires: Mon, 1 Dec 2003 01:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>BigDump ver. <?php echo (VERSION); ?></title>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; CHARSET=iso-8859-1">
<META HTTP-EQUIV="CONTENT-LANGUAGE" CONTENT="EN">

<META http-equiv="Cache-Control" content="no-cache">
<META http-equiv="Pragma" content="no-cache">
<META http-equiv="Expires" content="-1">

<style type="text/css">

</style>

</head>

<body>

<table width="780" cellspacing="0" cellpadding="0">
<tr><td class="transparent">

<h1>BigDump: Staggered MySQL Dump Importer ver. <?php echo (VERSION); ?></h1>

<?php

$error = false;
$file = false;

// Check PHP version

if (!$error && !function_exists("version_compare"))
{ echo ("PHP version 4.1.0 is required for BigDump to proceed. You have PHP ".phpversion()." installed. Sorry!\n");
$error=true;
}

// Calculate PHP max upload size (handle settings like 10M or 100K)

if (!$error)
{ $upload_max_filesize=ini_get("upload_max_filesize");
if (eregi("([0-9]+)K",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024;
if (eregi("([0-9]+)M",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024;
if (eregi("([0-9]+)G",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024*1024;
}

// Handle file upload

$upload_dir=dirname($_SERVER["SCRIPT_FILENAME"]);

if (!$error && isset($_REQUEST["uploadbutton"]))
{ if (is_uploaded_file($_FILES["dumpfile"]["tmp_name"]) && ($_FILES["dumpfile"]["error"])==0)
{
$uploaded_filename=str_replace(" ","_",$_FILES["dumpfile"]["name"]);
$uploaded_filepath=str_replace("\\","/",$upload_dir."/".$uploaded_filename);

if (file_exists($uploaded_filename))
{ echo ("File $uploaded_filename already exist! Delete and upload again!\n");
}
else if (eregi("(\.php|\.php3|\.php4|\.php5)$",$uploaded_filename))
{ echo ("You may not upload this type of files.\n");
}
else if (!@move_uploaded_file($_FILES["dumpfile"]["tmp_name"],$uploaded_filepath))
{ echo ("Error moving uploaded file ".$_FILES["dumpfile"]["tmp_name"]." to the $uploaded_filepath\n");
echo ("Check the directory permissions for $upload_dir (must be 777)!\n");
}
else
{ echo ("Uploaded file saved as $uploaded_filename\n");
}
}
else
{ echo ("Error uploading file ".$_FILES["dumpfile"]["name"]."\n");
}
}

// Handle file deletion (delete only in the current directory for security reasons)

if (!$error && isset($_REQUEST["delete"]) && $_REQUEST["delete"]!=basename($_SERVER["SCRIPT_FILENAME"]))
{ if (@unlink(basename($_REQUEST["delete"])))
echo ("".$_REQUEST["delete"]." was removed successfully\n");
else
echo ("Can't remove ".$_REQUEST["delete"]."\n");
}

// Open the database

if (!$error)
{ $dbconnection = @mysql_connect($db_server,$db_username,$db_password);
if ($dbconnection)
$db = mysql_select_db($db_name);
if (!$dbconnection || !$db)
{ echo ("Database connection failed due to ".mysql_error()."\n");
echo ("Edit the database settings in ".$_SERVER["SCRIPT_FILENAME"]." or contact your database provider\n");
$error=true;
}
}

// List uploaded files in multifile mode

if (!$error && !isset($_REQUEST["fn"]) && $filename=="")
{ if ($dirhandle = opendir($upload_dir))
{ $dirhead=false;
while (false !== ($dirfile = readdir($dirhandle)))
{ if ($dirfile != "." && $dirfile != ".." && $dirfile!=basename($_SERVER["SCRIPT_FILENAME"]))
{ if (!$dirhead)
{ echo ("<table cellspacing=\"2\" cellpadding=\"2\">\n");
echo ("<tr><th>Filename</td><th>Size</td><th>Date&Time</td><th>Type</td><th> </td><th> </td>\n");
$dirhead=true;
}
echo ("<tr><td>$dirfile</td><td class=\"right\">".filesize($dirfile)."</td><td>".date ("Y-m-d H:i:s", filemtime($dirfile))."</td>");
if (eregi("\.gz$",$dirfile))
echo ("<td>GZip</td>");
else
echo ("<td>SQL</td>");
if (!eregi("\.gz$",$dirfile) || function_exists("gzopen"))
echo ("<td><a href=\"".$_SERVER["PHP_SELF"]."?start=1&fn=$dirfile&foffset=0&totalqueries=0\">Start Import</a> into $db_name at $db_server</td>\n");
else
echo ("<td> </td>\n");
echo ("<td><a href=\"".$_SERVER["PHP_SELF"]."?delete=$dirfile\">Delete file</a></td></tr>\n");
}

}
if ($dirhead) echo ("</table>\n");
else echo ("No uploaded files found in the working directory\n");
closedir($dirhandle);
}
else
{ echo ("Error listing directory $upload_dir\n");
$error=true;
}
}

// Single file mode

if (!$error && !isset ($_REQUEST["fn"]) && $filename!="")
{ echo ("<a href=\"".$_SERVER["PHP_SELF"]."?start=1&fn=$filename&foffset=0&totalqueries=0\">Start Import</a> from $filename into $db_name at $db_server\n");
}

// File Upload Form

if (!$error && !isset($_REQUEST["fn"]) && $filename=="")
{

// Test permissions on working directory

do { $tempfilename=time().".tmp"; } while (file_exists($tempfilename));
if (!($tempfile=@fopen($tempfilename,"w")))
{ echo ("Upload form disabled. Permissions for the working directory $upload_dir must be set to 777 in order ");
echo ("to upload files from here. Alternatively you can upload your dump files via FTP.\n");
}
else
{ fclose($tempfile);
unlink ($tempfilename);

echo ("You can now upload your dump file up to $upload_max_filesize bytes (".round ($upload_max_filesize/1024/1024)." Mbytes) ");
echo ("directly from your browser to the server. Alternatively you can upload your dump files of any size via FTP.\n");
?>
<form method="POST" action="<?php echo ($_SERVER["PHP_SELF"]); ?>" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="$upload_max_filesize">
Dump file: <input type="file" name="dumpfile" accept="*/*" size=60">
<input type="submit" name="uploadbutton" value="Upload">
</form>
<?php
}
}

// Open the file

if (!$error && isset($_REQUEST["fn"]))
{

// Recognize GZip filename

if (eregi("\.gz$",$_REQUEST["fn"]))
$gzipmode=true;
else
$gzipmode=false;

if ((!$gzipmode && !$file=fopen($_REQUEST["fn"],"rt")) || ($gzipmode && !$file=gzopen($_REQUEST["fn"],"rt")))
{ echo ("Can't open ".$_REQUEST["fn"]." for import\n");
echo ("You have to upload the ".$_REQUEST["fn"]." to the server\n");
$error=true;
}

// Get the file size (can't do it fast on gzipped files, no idea how)

else if ((!$gzipmode && fseek($file, 0, SEEK_END)==0) || ($gzipmode && gzseek($file, 0, SEEK_SET)==0))
{ if (!$gzipmode) $filesize = ftell($file);
else $filesize = gztell($file); // Always zero, ignore
}
else
{ echo ("I can't get the filesize of ".$_REQUEST["fn"]."\n");
$error=true;
}
}

// ****************************************************
// START IMPORT SESSION HERE
// ****************************************************

if (!$error && isset($_REQUEST["start"]) && isset($_REQUEST["foffset"]))
{
echo ("Processing file: ".$_REQUEST["fn"]."\n");
echo ("Starting at the line: ".$_REQUEST["start"]."\n");

// Check $_REQUEST["foffset"] upon $filesize (can't do it on gzipped files)

if (!$gzipmode && $_REQUEST["foffset"]>$filesize)
{ echo ("UNEXPECTED: Can't set file pointer behind the end of file\n");
$error=true;
}

// Set file pointer to $_REQUEST["foffset"]

if (!$error && ((!$gzipmode && fseek($file, $_REQUEST["foffset"])!=0) || ($gzipmode && gzseek($file, $_REQUEST["foffset"])!=0)))
{ echo ("UNEXPECTED: Can't set file pointer to offset: ".$_REQUEST["foffset"]."\n");
$error=true;
}

// Start processing queries from $file

if (!$error)
{ $query="";
$queries=0;
$totalqueries=$_REQUEST["totalqueries"];
$linenumber=$_REQUEST["start"];
$querylines=0;
$inparents=false;

while (($linenumber<$_REQUEST["start"]+$linespersession || $query!="")
&& ((!$gzipmode && $dumpline=fgets($file, MAX_LINE_LENGTH)) || ($gzipmode && $dumpline=gzgets($file, MAX_LINE_LENGTH))))
{

// Handle DOS and Mac encoded linebreaks (I don't know if it will work on Win32 or Mac Servers)

$dumpline=ereg_replace("\r\n$", "\n", $dumpline);
$dumpline=ereg_replace("\r$", "\n", $dumpline);

// DIAGNOSTIC
// echo ("Line $linenumber: $dumpline\n");

// Skip comments and blank lines only if NOT in parents

if (!$inparents)
{ $skipline=false;
reset($comment);
foreach ($comment as $comment_value)
{ if (!$inparents && (trim($dumpline)=="" || strpos ($dumpline, $comment_value) === 0))
{ $skipline=true;
break;
}
}
if ($skipline)
{ $linenumber++;
continue;
}
}

// Remove double back-slashes from the dumpline prior to count the quotes ('\\' can only be within strings)

$dumpline_deslashed = str_replace ("\\\\","",$dumpline);

// Count ' and \' in the dumpline to avoid query break within a text field ending by ;
// Please don't use double quotes ('"')to surround strings, it wont work

$parents=substr_count ($dumpline_deslashed, "'")-substr_count ($dumpline_deslashed, "\\'");
if ($parents % 2 != 0)
$inparents=!$inparents;

// Add the line to query

$query .= $dumpline;

// Don't count the line if in parents (text fields may include unlimited linebreaks)

if (!$inparents)
$querylines++;

// Stop if query contains more lines as defined by MAX_QUERY_LINES

if ($querylines>MAX_QUERY_LINES)
{
echo ("Stopped at the line $linenumber. ");
echo ("At this place the current query includes more than ".MAX_QUERY_LINES." dump lines. That can happen if your dump file was ");
echo ("created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains ");
echo ("extended inserts. Please read the BigDump FAQs for more infos.\n");
$error=true;
break;
}

// Execute query if end of query detected (; as last character) AND NOT in parents

if (ereg(";$",trim($dumpline)) && !$inparents)
{ if (!mysql_query(trim($query), $dbconnection))
{ echo ("Error at the line $linenumber: ". trim($dumpline)."\n");
echo ("Query: ".trim($query)."\n");
echo ("MySQL: ".mysql_error()."\n");
$error=true;
break;
}
$totalqueries++;
$queries++;
$query="";
$querylines=0;
}
$linenumber++;
}
}

// Get the current file position

if (!$error)
{ if (!$gzipmode)
$foffset = ftell($file);
else
$foffset = gztell($file);
if (!$foffset)
{ echo ("UNEXPECTED: Can't read the file pointer offset\n");
$error=true;
}
}

// Finish message and restart the script

if (!$error)
{ echo ("Stopping at the line: ".($linenumber-1)."\n");
echo ("Queries performed (this session/total): $queries/$totalqueries\n");
echo ("Total bytes processed: $foffset (".round($foffset/1024)." KB)\n");
if ($linenumber<$_REQUEST["start"]+$linespersession)
{ echo ("Congratulations: End of file reached, assuming OK\n");
echo ("Thank you for using! Please rate <a href=\"http://www.hotscripts.com/Detailed/20922.html\" target=\"_blank\">Bigdump at Hotscripts.com</a>\n");
echo ("You can send me some bucks or euros as appreciation <a href=\"http://www.ozerov.de/bigdump\" target=\"_blank\">via PayPal</a>\n");
$error=true;
}
else
{ if ($delaypersession!=0)
echo ("Now I'm waiting $delaypersession milliseconds before starting next session...\n");
echo ("<script language=\"JavaScript\" type=\"text/javascript\">window.setTimeout('location.href=\"".$_SERVER["PHP_SELF"]."?start=$linenumber&fn=".$_REQUEST["fn"]."&foffset=$foffset&totalqueries=$totalqueries\";',500+$delaypersession);</script>\n");
echo ("<noscript>\n");
echo ("<a href=\"".$_SERVER["PHP_SELF"]."?start=$linenumber&fn=".$_REQUEST["fn"]."&foffset=$foffset&totalqueries=$totalqueries\">Continue from the line $linenumber</a> (Enable JavaScript to do it automatically)\n");
echo ("</noscript>\n");
echo ("Press <a href=\"".$_SERVER["PHP_SELF"]."\">STOP</a> to abort the import OR WAIT!\n");
}
}
else
echo ("Stopped on error\n");
}

if ($error)
echo ("<a href=\"".$_SERVER["PHP_SELF"]."\">Start from the beginning</a> (DROP the old tables before restarting)\n");

if ($dbconnection) mysql_close();
if ($file && !$gzipmode) fclose($file);
else if ($file && $gzipmode) gzclose($file);

?>

© 2003-2005 <a href="mailto:[email protected]">Alexey Ozerov</a> - <a href="http://www.ozerov.de/bigdump" target="_blank">BigDump Home</a>

</td></tr></table>

</body>
</html>

korangar · 17/2/08

// Database configuration

$db_server = "localhost";

Coi xem cái này có đúng là localhost không, bởi vì host free thì thường ko phải là localhost.

kitarosanza · 17/2/08

trong cái host 6te này nó ghi là localhost mà

kitarosanza · 17/2/08

korangar · 17/2/08

$filename = ""; // Specify the dump filename to suppress the file selection dialog

Điền tên file sql đã up lên host để restore.

nizsu · 17/2/08

Ko phải chỗ đó

Database connection failed due to Access denied for user 'b2online.6te.net'@'localhost' (using password: YES)

Dòng này báo pass đúng chỉ có sai dbname

$db_server = "localhost";
$db_name = "135974";
$db_username = "b2online.6te.net";
$db_password = "123456";

Ít khi nào dbusername là domain host hết dbusername thường trùng tên với db_name . Sửa lại thử xem ,tốt nhất mở email ra so lại cho chính xác

kitarosanza · 17/2/08

cái này là do database nó cung cấp sẵn xóa ko đc mà tao thêm cũng ko xong use name thì nó ghi là b2leloi.6te.net lúc login vào cpanel cũng login = use name đó ai rảnh thì vào host chỉnh hộ em với

nizsu · 17/2/08

dbusername khác với ftpusername . Bạn sửa lại 135974 thử đi . Tốt nhất copy nguyên cái email no gửi . Mình đăng kí thử nó cho info như vậy nè

Your Personal MySQL Information:
MySQL DataBase 48792
MySQL HostName localhost
MySQL UserName 48792
MySQL PassWord: 123456

kitarosanza · 17/2/08

mình còn chả thấy nó gửi về email cơ
bạn chỉnh như thế nào ở file bigdump.php post cho mình coi đc ko

korangar · 17/2/08

nizsu nói:
Ko phải chỗ đó

Dòng này báo pass đúng chỉ có sai dbname

Ít khi nào dbusername là domain host hết dbusername thường trùng tên với db_name . Sửa lại thử xem ,tốt nhất mở email ra so lại cho chính xác

Cái câu này lúc nào config bigdump sai nó chả báo như thế ?

nizsu · 17/2/08

Bạn check mail trong bulk sẽ thấy .Chú ý phần khoanh đỏ

Phần config bạn sửa lại là :

$db_server = "localhost";
$db_name = "135974";
$db_username = "135974";
$db_password = "123456";

Xem hoạt động được ko . Tốt nhất check trong email để điền cho đúng

@korangar : Biết là sẽ báo lỗi sai nhưng ít nhất bạn phải hiểu nó báo cái gì

kitarosanza · 18/2/08

mình cũng đã chỉnh lại như thế nhưng vẫn ko đc lúc đó thì nó ghi thế này
Error listing directory /home/vhosts/b2leloi.6te.net

nizsu · 18/2/08

// 4. If you want to upload the dump files directly from the web-browser give the scripts
// writing permissions on the working directory (chmod 777 on a Linux based system)

Đọc mục số 4 trong script có đề cập
Báo như vậy nghĩa là nó kết nối vô db thành công rồi nhưng nó ko lên list được các file trong folder vì folder đó đã chmod ko cho đọc . Chmod lại 777 cái folder

kitarosanza · 18/2/08

bạn hướng dẫn đc chớ cái này mình ko biết sài thank trước

korangar · 18/2/08

Để đơn giản, dùng http://net2ftp.com truy cập vào tài khoản ftp, chmod cái folder chứa file sql thành 777.

kitarosanza · 19/2/08

chmod thế nào mới đc chứ cái này để upload mà

mình dùng flash FXP để chmod nhưng mà sau khi chmod file forumbackup.sql xong xem lại nó vẫn là 644 ai vào chỉnh hộ mình với
sever : b2online.6te.net
use name : b2online.6te.net
pass : 123456
ah với cả ko hỉu tại sao file forumbackup.sql của mình nặng 7.89mb mà sau khi up lên host dung lượng là 0 xem file này thì chả thấy j` cả

Nguyen_Kain · 21/2/08

kitarosanza nói:
chmod thế nào mới đc chứ cái này để upload mà

mình dùng flash FXP để chmod nhưng mà sau khi chmod file forumbackup.sql xong xem lại nó vẫn là 644 ai vào chỉnh hộ mình với
sever : b2online.6te.net
use name : b2online.6te.net
pass : 123456
ah với cả ko hỉu tại sao file forumbackup.sql của mình nặng 7.89mb mà sau khi up lên host dung lượng là 0 xem file này thì chả thấy j` cả

Có lẽ do host free , nên nó giới hạn việc up file có dung lượng lớn hơn 2mb

(đa số các host free đều giới hạn như vậy , bạn nên kiểm tra xem sao :

)

korangar · 21/2/08

Thử dùng MySQL dumper mà cắt nhỏ cái file SQL ra rồi up từng file lên, restore từng file 1 theo thứ tự.

Ai giúp em lỗi này với về host 6te

Mr & Ms Pac-Man

Mega Man

Mr & Ms Pac-Man

Mega Man

Mr & Ms Pac-Man

Mr & Ms Pac-Man

Mega Man

Youtube Master Race

Mr & Ms Pac-Man

Youtube Master Race

Mr & Ms Pac-Man

Mega Man

Youtube Master Race

Mr & Ms Pac-Man

Youtube Master Race

Mr & Ms Pac-Man

Mega Man

Mr & Ms Pac-Man

Quậy hết mình

Mega Man

Attachments