Moving Servers

When moving servers, Do I have to redo everything or can I just change the config.php3 file to mysql settings and its the same as before ?

-Infamous

yes,
but you have to remember to move your database too!

to move the db, the best way imho is to get phpmyadmin (http://phpwizard.net/projects/phpMyAdmin/index.html) and go into the main database menu, and near the bottom there is a

View dump (schema) of database
[] Structure only | [] Add 'drop table'
[] Structure and data | [] send
[submit]

form. select Structure and data, and send, and submit. it will start a download screen that will let you save the database to a .sql file on your harddrive.

then you can upload it to your new box and (again w/ phpmyadmin @ main db menu) find this:

Run SQL query/queries on database tribalwar(my db*) : [________]

or Location of the textfile: [_______] [Browse]
[submit]

pick the text file, hit submit, and when its finished you're all done. :)

btw, excuse the very poor attempt at drawing form elements, no html is annoying :(

<a href="http://www.vbulletin.com/forum/showthread.php?threadid=2199" target="_blank">http://www.vbulletin.com/forum/showt...?threadid=2199</a>

thanks a lot reatoranski I didnt knew that option.

when im trying to do it it tells me a lot of warrnings that it Cannot set time limit in safe mode.
what do i need to do?

anyone?

Originally posted by Scaramanga_gold
thanks a lot reatoranski I didnt knew that option.

way to butcher my name :D

might consider using copy&paste, or just calling me 'rat' in the future (everyone seems to anyways)

edit*

b0rk

:D

[Edited by Blackjack on 01-05-2001 at 06:11 PM]

Originally posted by Scaramanga_gold
when im trying to do it it tells me a lot of warrnings that it Cannot set time limit in safe mode.
what do i need to do?

Little advice, use telnet, PHPMyAdmin doesn't handle dumps and imports well!

thats my problem I can't use telnet :(

Originally posted by Scaramanga_gold
thats my problem I can't use telnet :(

SSH? If not might be time to look for a full-feature host.

can i get step by step directions
on how to do this thru Telnet???

Originally posted by Scaramanga_gold
thats my problem I can't use telnet :(

The problem is that host servers alway put time/size limits while importing your db through phpMyAdmin. If you knew Telnet I could tell you the syntax line to use. In this case just paste and submit a piece (everything include between two ##### lines) of your SQL at once and go on this way until the end of your db backup file.
Enjoy. :)

Im pretty much screwed in trying to move my database.
I use Verio as a host and they dont allow telnet access. Also there are ridiculous restrictions on usage when using MyAdmin. I havent been able to get even 1/10th of my database using the dump feature.

They told me to download one table at a time, but my posts table still cancels before it is done. Major pain in the butt.

Anyone have any ideas? I REALLY have to move my vB. Ive been surpassing Verio's ridiculously low bandwidth allocations every month for the last 3 months.

P.S. Dont host vB with Verio!!!!!!