Restore Database Error

vot

1) Set the UTF-8 encoding
2) Check the "Add DROP TABLE..."
3) UNcheck the "Add IF NOT EXISTS"

fengshui-123

vot 发表于 2012-2-28 15:56
1) Set the UTF-8 encoding
2) Check the "Add DROP TABLE..."
3) UNcheck the "Add IF NOT EXISTS"

It works, Magic!

My database imported successfully even when I encountered "Gateway Time Out" while uploading/importing 1MB gz file. Can't imagine how come it still importing properly.

These few days I got headache trying out discuz restoring function, try in different places different networks still give me "Internal Server Error". Now I can use myphpadmin!

Vot, Thank you very much.  

fengshui-123

By the way, is there any way to increase my Firefox "Gateway Time Out" timing so that I will not get this error again?

vot

is there any way to increase my Firefox "Gateway Time Out" timing

No.

fengshui-123

A separate session, I export the database using phpmyadmin from another remote site and import it on my local server, half way through it give me the following error, may I know what's wrong?

Error

SQL query:

INSERT INTO `pre_common_syscache` (`cname`, `ctype`, `dateline`, `data`) VALUES ('forums', 1, 1330489636, 0x613a343732343a7b693a3331303b613a31313a7b733a333a22666964223b733a333a22333130223b733a343a2274797065223b733a353a2267726f7570223b733a343a226e616d65223b733a31303a22426f6172642054616c6b223b733a333a22667570223b733a313a2230223b733a383a22766965777065726d223b733a303a22223b733a383a22706f73747065726d223b733a303a22223b733a373a226f726465726279223b733a383a226c617374706f7374223b733a373a2261736364657363223b733a343a2244455343223b733a363a22737461747573223b733a313a2231223b733a353a226578747261223b613a313a7b733a393a226e616d65636f6c6f72223b733a303a22223b7d733a363a22706c7567696e223b4e3b7d693a3331313b613a31343a7b733a333a22666964223b733a333a22333131223b733a343a2274797065223b733a353a22666f72756d223b733a343a226e616d65223b733a31333a22416e6e6f756e63656d656e7473223b733a333a22667570223b733a333a22333130223b733a383a22766965777065726d223b733a34353a22093909313009313109313209313309313409313509313609313709313809313[...]

MySQL said: Documentation
#2006 - MySQL server has gone away