Moving servers, yes, but what about...

[Areku]

...the contents of the messages itself?

I'm following vb's.com guide to move DB from server1 to server2, but WHAT happens with all the URLs used throrough the site and inside the posts itself pointing to server1? Is there any search'n'replace thing for mysql or something like this?!?

Thanks!

[Rose]

What do you mean? URL's embedded inside the templates? You can do a search of the templates and replace the old url with a new one, if that's what you are referring to (for those 'hard-coded' in links).

Inside the posts - I believe they all stay the same unless you go in and manually edit them before transport. One suggestion (and this might be tedius and not worth it, but it's a shot) is to open your .sql file of the database into an editor ((such as EditPlus 2.0)) and use their search and replace feature to try that before you upload the actual database contents.

Good luck with it, though.

[Areku]

I thought there would be a mysql function to do the search'n'replace....

Since I'm referring to URLs containing an old path (domain1.com/mysite/forums/blablabla.php to domain2.com/forums/blablabla.php), I guess there must be an easy cure for this!

Pleez?

[filburt1]

Do so at your own risk:
[sql]
UPDATE post SET pagetext = REPLACE(pagetext, 'http://olddomain', 'http://newdomain');
[/sql]
Be sure to include the http://.

[Areku]

Is it SO risky? Seems more reliable than other methods

[Areku]

Meanwhile, on STEP 3 of VB's.com mOVING SERVERS MANUAL, I'm now trying to import the dump onto the new server but I get this:

ERROR 2006 at line 157: MySQL server has gone away

What am I doing wrong?!?!

[Neo]

Originally posted by filburt1
Do so at your own risk:
[sql]
UPDATE post SET pagetext = REPLACE(pagetext, 'http://olddomain', 'http://newdomain');
[/sql]
Be sure to include the http://.

BAHHH figures (:

[filburt1]

Re: I say so at your own risk because it's an UPDATE query and that modifies your data, unlike harmless SELECT.

[Areku]

HoweverI'm still stucked on IMPORTING the dump I made...

I get the error mentioned above.

I followed every instruction on Vb.com moving servers guide, BUT I could not use the --opt parameter, instead I used the ones opt mean sepparately EXCEPT FOR lock-tables.

Now each time i try to recreate the database,

ERROR 2006 at line 157: MySQL server has gone away

appears.

Advice pleasE!!

[filburt1]

I think it's your host's fault for misconfiguring something in my.cnf, try asking them.