Restore Database Error

fengshui-123

I newly install a site, then backup the database, then try the restore function, it give me the following error.
I did copy both utility/lang_restore.php and utility/restore.php files to "data" directory.

Warning: require_once(D:\xampp\htdocs\sghousingtalk\data/../utility/lang_restore.php) [function.require-once]: failed to open stream: No such file or directory in D:\xampp\htdocs\sghousingtalk\data\restore.php on line 547

vot

It's a bug...
WIll check...

Temporarily solution:

Copy the file /source/language/XX/lang_restore.php
to the folder /utility/

fengshui-123

where is this folder /utility/, at root directory? You mean I must copy the whole utility folder to root directory? I did not do that, I just copy lang_restore.php and restore.php to folder "data', could it be I did wrongly?

vot

restore.php looks for lang_restore.php in the "utility" folder that is placed one level upper from the restore.php.

fengshui-123

vot 发表于 2012-2-22 22:18
restore.php looks for lang_restore.php in the "utility" folder that is placed one level upper from t ...

see the screenshot, the ACP instruction is clear but does not mention lang_restore.php.

fengshui-123

OK, I have done it successfully.
first copy utility/restore.php to "data" folder.
second, copy the whole "utility" folder to root directory (or same level as "data" folder).

fengshui-123

The above was doing on my pc.

when I try it over internet site, it give the following error.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@sghousinglist.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

My server has nothing wrong because I can reinstall the site again without problem.

fengshui-123

The "Internal Server Error"  most likely caused by network. I changed to another network provider network the problem does not exist.

vot

It is strange that adminCP make a call to outide file restore.php, which is often absent...
I'm trying to solve the problem...

Temporary recommendation:
Do not use the X2 built-in backup/restore functions!
It is better to use the system backup from your hosting panel or your shell.

fengshui-123

vot 发表于 2012-2-24 14:53
It is strange that adminCP make a call to outide file restore.php, which is often absent...
I'm tryi ...

Hi Vot,

I am using phpmyadmin, now I want to export my database from my local server, and then transfer to internet hosting server to import, what options should I select to export and import(see screenshot)?