Moving to a new server

[DetonatorX]

My host is currently having problems with the server im hosted with. One suggestion is to transfer my site to a different one with less load. How do I backup my database? I'm pretty new with telnet so pls explain it to me gently. I find the instructions in the manual not so friendly.

Also, whats the best way to backup the complete customizations i've done with my vB? this includes templates, board categories, image paths, colors, etc. Please advice. Thanks.

[tubedogg]

Try this.
Those steps will lead you through backing up everything including colors, templates, settings, posts, etc.

[DetonatorX]

Originally posted by tubedogg
Try this.
Those steps will lead you through backing up everything including colors, templates, settings, posts, etc.

would this backup completely everthing? from database to vB customizations? entirely evrything?

[tubedogg]

Everything except your actual .php and image files are stored in the database, so yes it would.

[DetonatorX]

Originally posted by tubedogg
Everything except your actual .php and image files are stored in the database, so yes it would.

- how do i verify the dump.sql file i've backed up?
- how do i know where to save the dump file in the new server? how can i get the right path?
- how do i delete the dummy db i've created after installing vB in the new server?
- how do i check that the dump file already exists in the new server after putting it there with the PUT command?

[tubedogg]

- how do i verify the dump.sql file i've backed up?

The easiest way to verify is try to set it up on the new server before deleting it from the old server. If vB works, it was successful.

- how do i know where to save the dump file in the new server? how can i get the right path?

It is most likely
home/mysitename/dump.sql
but you can ask tech support what the directory directly above your web root is and they can tell you.

- how do i delete the dummy db i've created after installing vB in the new server?

Via telnet:
mysql -uUSERNAME -p
<enter your password>
drop DUMMYDATABASENAME;
exit;

- how do i check that the dump file already exists in the new server after putting it there with the PUT command?

Just login via FTP and it'll show up in the file listings if it's there.

[DetonatorX]

Originally posted by tubedogg

Just login via FTP and it'll show up in the file listings if it's there.

when i try to access my site via FTP now, i cant even see the mysql folder where my mysql db is stored? how can i see it? im hosted on a RAQ4 server and i dont have PHPadmin.

[tubedogg]

No no no I meant the dump.sql file, not the actual MySQL database files.

[DetonatorX]

Originally posted by tubedogg
No no no I meant the dump.sql file, not the actual MySQL database files.

oh ok. so does this mean that you cannot really see mysql files via FTP?

so this dump file is just temporary? how will it be converted to actual db file?

[tubedogg]

Originally posted by DetonatorX
oh ok. so does this mean that you cannot really see mysql files via FTP?

You can, but not where you're looking, and not if you're on a shared host.

so this dump file is just temporary? how will it be converted to actual db file?

When you do step 4 of the instructions.

[DetonatorX]

Originally posted by tubedogg

You can, but not where you're looking, and not if you're on a shared host.


When you do step 4 of the instructions.

ok ill try it once my new server id ready. in any case, ill just post additional questions here. your inputs are really helpful. thanks.