FUDforum: How To » Moving whole website to a different server

Home » FUDforum » How To » Moving whole website to a different server

Show: Today's Messages :: Polls :: Message Navigator

Re: Moving whole website to a different server [message #40471 is a reply to message #40455]

Fri, 07 March 2008 23:03

WilliamBurns

Messages: 123
Registered: March 2004
Location: San Jose, CA

Karma:

Senior Member

I seem to be having another problem in moving the forum from one site to another. Can you tell me what is going on and what to do about it? Can it have anything to do with having mysql as the database name on the old site, but rpimysql as the databasename on the new site?
On the old site, I went to the administrative control panel and dumped a backup of the active forum. I left the box checked so the output would be compressed.
I downloaded the dump file to my desktop, then uploaded it on the new site and put it in the same folder where I got it.
On the new site, I went to the control panel and selected "Import Data" and a small green gauge came on the bottom of the screen. It speedily got to about 50% but then hung there. I did it twice. One of the times I went home and left it overnite. In the morning, I had a browser error. In looking at the forum, The home page was updated with counts, etc., but on all of the forums there are no messages. Even though several of the forums show multiple "pages" of messages, they all say there are no messages in this forum. The apache log shows:
[Fri Mar 07 21:39:27 2008] [error] [client 66.249.67.54] PHP Fatal error: SQL Error has occurred, please contact the <a href="mailto:wjb(at)rpinet(dot)com?subject=SQL%20Error">administrator</a> of the forum and have them review the forum's SQL query log in /usr/local/apache2/htdocs/wforum/index.php on line 49
The last two errors in the forum sql error file were:
[Fri Mar 7 22:15:00 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM0MjxiciAvPgovdXNyL2 xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L2luZGV4LnBocDo5OTxic iAvPgovdXNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS9pbmRleC5waHA6MTE0NTxiciAv PgopIDEwNjQ6IFlvdSBoYXZlIGFuIGVycm9yIGluIHlvdXIgU1FMIHN5bnRheDsgY2hlY2sgdGh lIG1hbnVhbCB0aGF0IGNvcnJlc3BvbmRzIHRvIHlvdXIgTXlTUUwgc2VydmVyIHZlcnNpb24gZm 9yIHRoZSByaWdodCBzeW50YXggdG8gdXNlIG5lYXIgJycgYXQgbGluZSAxPGJyIC8+ClF1ZXJ5O iBVUERBVEUgZnVkMjYxX3NlcyBTRVQgc3lzX2lkPSc4MWNmOTZkZDhhMzZhNjBlNDNkMGYwZDVi ZWZmOGY3ZicsIGZvcnVtX2lkPTAsIHRpbWVfc2VjPTEyMDQ5MjgxMDAsIGFjdGlvbj0nQnJvd3N pbmcgdGhlICZsdDthIGhyZWY9XCZxdW90O2luZGV4LnBocD90PWluZGV4XCZxdW90OyZndDtmb3 J1bSBsaXN0Jmx0Oy9hJmd0OycsIHJldHVybnRvPScnIFdIRVJFIGlkPTxiciAvPgpTZXJ2ZXIgV mVyc2lvbjogNS4wLjQ1PGJyIC8+CltSZWZlcnJpbmcgUGFnZV0gaHR0cDovLzE5OC4xMDYuMjku NS88YnIgLz4K
[Fri Mar 7 22:23:41 GMT 2008] KC91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTY8YnIgLz4KL3V zci9sb2NhbC9hcGFjaGUyL2h0ZG9jcy93Zm9ydW0vaW5kZXgucGhwOjM2ODxiciAvPgovdXNyL2 xvY2FsL2ZvcnVtZGF0YS9pbmNsdWRlL3RoZW1lL2RlZmF1bHQvZXJyLmluYzo2MzxiciAvPgovd XNyL2xvY2FsL2FwYWNoZTIvaHRkb2NzL3dmb3J1bS90aGVtZS9kZWZhdWx0L3JlcG9ydC5waHA6 MTI4PGJyIC8+Ci91c3IvbG9jYWwvYXBhY2hlMi9odGRvY3Mvd2ZvcnVtL2luZGV4LnBocDoxMTQ 1PGJyIC8+CikgMTA2NDogWW91IGhhdmUgYW4gZXJyb3IgaW4geW91ciBTUUwgc3ludGF4OyBjaG VjayB0aGUgbWFudWFsIHRoYXQgY29ycmVzcG9uZHMgdG8geW91ciBNeVNRTCBzZXJ2ZXIgdmVyc 2lvbiBmb3IgdGhlIHJpZ2h0IHN5bnRheCB0byB1c2UgbmVhciAnJyBhdCBsaW5lIDE8YnIgLz4K UXVlcnk6IFVQREFURSBmdWQyNjFfc2VzIFNFVCBkYXRhPSdzOjEyNzpcJnF1b3Q7Jmx0O2ZpZWx kc2V0Jmd0OyZsdDtsZWdlbmQmZ3Q7RVJST1I6IFlvdSBhcmUgbm90IGxvZ2dlZC1pbiZsdDsvbG VnZW5kJmd0O1RvIGFjY2VzcyB0aGlzIHBhZ2UgeW91IG11c3QgYmUgYSBtZW1iZXIgb2YgdGhpc yBmb3J1bS4mbHQ7L2ZpZWxkc2V0Jmd0OyZsdDticiAvJmd0O1wmcXVvdDs7JywgcmV0dXJudG89 J3Q9cmVwb3J0JmFtcDttc2dfaWQ9MTc5NDUmYW1wO3JpZD0wJmFtcDtTPTYxMzRjZjBlNzQ0MzI yZGYxN2EyMWFmMTNiNmVhNmRhJyBXSEVSRSBpZD08YnIgLz4KU2VydmVyIFZlcnNpb246IDUuMC 40NTxiciAvPgpbUmVmZXJyaW5nIFBhZ2VdIHVua25vd248YnIgLz4K
The last line in the forum access log is:
[Fri Mar 7 22:32:23 GMT 2008] W0Vycm9yXSBJbnZhbGlkIElucHV0PGJyIC8+W01lc3NhZ2UgU2VudCB0byBVc2VyXSBZb3UgaGF 2ZSBmb2xsb3dlZCBhbiBpbnZhbGlkIGxpbmsuIFBsZWFzZSBub3RpZnkgdGhlIDxhIGhyZWY9Im 1haWx0bzp3amJAcnBpbmV0LmNvbSI+d2VibWFzdGVyPC9hPiBob3cgeW91IGdvdCBoZXJlLjxic iAvPltVc2VyIElQXSA2Ni4yNDkuNjcuNTQ8YnIgLz5bUmVxdWVzdGVkIFVSTF0gaHR0cDovL3Jw aXZwcy5zZWN1cmVzaXRlcy5uZXQvd2ZvcnVtL2luZGV4LnBocD90PXRyZWUmdGg9MzEwNiZyaWQ 9MCZTPWE5NDhkZTU5MDk0NjUyOWE2Y2NiZDkwMzRiZWY1YzBiPGJyIC8+

[Updated on: Fri, 07 March 2008 23:07]

Report message to a moderator

[Message index]

		Moving whole website to a different server By: WilliamBurns on Mon, 04 February 2008 20:56
		Re: Moving whole website to a different server By: Ilia on Mon, 04 February 2008 21:14
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 01:28
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 06 February 2008 18:27
		Re: Moving whole website to a different server By: Ilia on Thu, 07 February 2008 01:46
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 07 February 2008 22:03
		Re: Moving whole website to a different server By: Ilia on Sun, 10 February 2008 14:29
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 11 February 2008 18:20
		Re: Moving whole website to a different server By: Ilia on Mon, 11 February 2008 18:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 00:14
		Re: Moving whole website to a different server By: Ilia on Tue, 12 February 2008 17:49
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 17:57
		Re: Moving whole website to a different server By: sallen812 on Tue, 12 February 2008 18:00
		Re: Moving whole website to a different server By: Ilia on Wed, 13 February 2008 20:40
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 00:16
		Re: Moving whole website to a different server By: Ilia on Thu, 14 February 2008 17:56
		Re: Moving whole website to a different server By: sallen812 on Thu, 14 February 2008 19:16
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 14 February 2008 21:13
		Re: Moving whole website to a different server By: Ilia on Sun, 17 February 2008 17:22
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 19 February 2008 21:11
		Re: Moving whole website to a different server By: Ilia on Wed, 20 February 2008 03:05
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 20 February 2008 22:29
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 03:00
		Re: Moving whole website to a different server By: Ilia on Thu, 21 February 2008 13:41
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 18:31
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 21 February 2008 19:26
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 22 February 2008 21:17
		Re: Moving whole website to a different server By: Ilia on Sun, 24 February 2008 15:57
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 24 February 2008 21:50
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 25 February 2008 23:41
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 00:06
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 26 February 2008 01:06
		Re: Moving whole website to a different server By: Ilia on Tue, 26 February 2008 23:58
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 27 February 2008 23:34
		Re: Moving whole website to a different server By: Ilia on Thu, 28 February 2008 00:23
		Re: Moving whole website to a different server By: WilliamBurns on Thu, 28 February 2008 00:40
		Re: Moving whole website to a different server By: Ilia on Fri, 29 February 2008 01:21
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 12 February 2008 19:07
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 03 March 2008 20:09
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 07 March 2008 23:03
		Re: Moving whole website to a different server By: Ilia on Sun, 09 March 2008 17:34
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 10 March 2008 16:42
		Re: Moving whole website to a different server By: Ilia on Mon, 10 March 2008 23:25
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 11 March 2008 18:33
		Re: Moving whole website to a different server By: Ilia on Wed, 12 March 2008 17:37
		Re: Moving whole website to a different server By: WilliamBurns on Sat, 15 March 2008 00:04
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 03:39
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 18:14
		Re: Moving whole website to a different server By: Ilia on Mon, 17 March 2008 22:35
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 17 March 2008 23:48
		Re: Moving whole website to a different server By: Ilia on Tue, 18 March 2008 18:13
		Re: Moving whole website to a different server By: WilliamBurns on Tue, 18 March 2008 20:17
		Re: Moving whole website to a different server By: WilliamBurns on Wed, 19 March 2008 19:15
		Re: Moving whole website to a different server By: Ilia on Thu, 20 March 2008 00:11
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 17:36
		Re: Moving whole website to a different server By: Ilia on Mon, 24 March 2008 18:09
		Re: Moving whole website to a different server By: WilliamBurns on Mon, 24 March 2008 20:46
		Re: Moving whole website to a different server By: Ilia on Tue, 25 March 2008 20:19
		Re: Moving whole website to a different server By: WilliamBurns on Fri, 28 March 2008 19:22
		Re: Moving whole website to a different server By: Ilia on Sun, 30 March 2008 14:43
		Re: Moving whole website to a different server By: WilliamBurns on Sun, 30 March 2008 19:38
		Re: Moving whole website to a different server By: voisardf on Wed, 02 April 2008 19:50

Previous Topic:	disable poll
Next Topic:	query string for subject/body

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 14 22:27:47 GMT 2024

Total time taken to generate the page: 0.07559 seconds