竹貓星球

computer315 寫:升級phpmyadmin應該不至於出錯吧..
像我從2.5.7升級到2.8.2時...就直接上傳覆蓋...然後再設定config檔就好了

j0958322080 寫:我是要從2.11回復到2.10.02(因該沒錯吧)
但是兩個是不同資料庫
從2.11還原到2.10.2會出現問題

j0958322080 寫:

心靈捕手 寫:
建議您:
補充說明
1. 是否使用同一台主機?
2. 怎麼轉?

1.否
2.直接RESTORE

j0958322080 寫:用過捕手大大的方法
結果還是失敗了.......

j0958322080 寫:

心靈捕手 寫:

j0958322080 寫:用過捕手大大的方法
結果還是失敗了.......

真是遺憾!
不過, 您提供的訊息太少, 無從給您具體意見.

建議您:
補充說明:
1. 兩主機的 MySQL 版本為何?
2. 您要從哪一台移轉到哪一台?
3. 詳述您的移轉方法?
4. 您遭遇的錯誤訊息?

1. 2.11.0轉到2.10.0.2
2.我是用免費空間
3.載入PHPMyadmin & 從後台還原
4.錯誤
用PHPMyadmin直接載入
SQL 語法:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 建立日期: Nov 11, 2007, 05:28 AM
-- 伺服器版本: 5.0.27
-- PHP 版本: 5.2.3
--
-- 資料庫: `wakka_MySQL`
--
-- --------------------------------------------------------
--
-- 資料表格式： `phpbb2_acronyms`
--
CREATE TABLE `phpbb2_acronyms` (

`acronym_id` mediumint( 9 ) NOT NULL AUTO_INCREMENT ,
`acronym` varchar( 80 ) NOT NULL ,
`description` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `acronym_id` )
) TYPE = MYISAM AUTO_INCREMENT =2;



MySQL 傳回：

#1046 - No database selected

j0958322080 寫:1.為何不用後台呢
2.我有資料庫阿= =
為何會顯示沒有呢

j0958322080 寫:

Error importing backup file

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' Welcome to phpBB2 Plus 1.53 Your new Forum is waiting for you now,' at line 1

 Welcome to phpBB2 Plus 1.53 Your new Forum is waiting for you now, Have a good time! ^_^ '); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('number_of_news', '5'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('news_length', '200'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('news_forum', '1'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('poll_forum', '1'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('number_recent_topics', '5'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('number_recent_files', '5'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('last_seen', '5'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('exceptional_forums', ''); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('cat_id', '0'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('pics_number', '1'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('pics_all', '0'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('pics_sort', '0'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('pics_thumbsize', '100'); INSERT INTO phpbb2_portal (portal_name, portal_value) VALUES('number_top_posters', '5'); # # TABLE: phpbb2_posts # DROP TABLE IF EXISTS phpbb2_posts; CREATE TABLE phpbb2_posts( post_id mediumint(8) unsigned NOT NULL auto_increment, topic_id mediumint(8) unsigned NOT NULL, forum_id smallint(5) unsigned NOT NULL, poster_id mediumint(8) NOT NULL, post_time int(11) NOT NULL, poster_ip char(8) NOT NULL, post_username varchar(25), enable_bbcode tinyint(1) DEFAULT '1' NOT NULL, enable_html tinyint(1) NOT NULL, enable_smilies tinyint(1) DEFAULT '1' NOT NULL, enable_sig tinyint(1) DEFAULT '1' NOT NULL, post_edit_time int(11), post_edit_count smallint(5) unsigned NOT NULL, post_attachment tinyint(1) NOT NULL, post_icon tinyint(2), post_bluecard tinyint(1), PRIMARY KEY (post_id), KEY forum_id (forum_id), KEY topic_id (topic_id), KEY poster_id (poster_id), KEY post_time (post_time), KEY post_icon (post_icon) ); # # Table Data for phpbb2_posts # INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('44', '6', '1', '17', '1191955771', '7a7e105b', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('13', '9', '2', '2', '1191720451', 'dc8b8e30', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('3', '3', '1', '2', '1191642845', 'dc8ad9f6', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('10', '3', '1', '5', '1191713479', 'daacd9ba', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('91', '22', '1', '24', '1192926516', 'daa5aea6', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('6', '5', '2', '2', '1191643651', 'dc8ad9f6', '', '1', '0', '1', '0', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('7', '3', '1', '-1', '1191644998', 'daa44fed', 'RaCing撠?', '1', '0', '1', '1', NULL, '0', '0', '0', NULL); INSERT INTO phpbb2_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard) VALUES('8', '3', '1', '-1', '1191646461', 'daa9322e', 'RaCing??, '1', '0', '1', '0', NULL, '0', '0', '0', NULL)

Line : 985
File : admin_db_utilities.php

我從後台還原會這樣耶

j0958322080 寫:

心靈捕手 寫:請貼出兩個, 不同空間所建立的論壇, 網址.

這個空間還原到這個空間
論壇版本:phpBB2 plus 1.53(一樣)

j0958322080 寫:

心靈捕手 寫:建議您:
壓縮後, 貼出由後台備份的資料.
phpbb_db_backup.sql

http://j0958322080.myweb.hinet.net/wakka_MySQL.sql
請用另存目標
因為下載不下來
我是用複製貼上的方法
來備份資料庫的
不過沒有少複製到
不知是不是就錯在這

j0958322080 寫:

心靈捕手 寫:建議您:
貼圖, 補充說明, 您後台備份的方法.

圖片
圖片
我是用複製貼上的方法