If my forum site is shutdown and i want to change my server/hosting and there is lots of threads in my forum, if i will change my server only i need to move my mysql databse? that can delete my forum threads or members or not?
With most forum scripts, the threads and members are stored in the database. The best alternative for you is to move to a new host that uses the same control panel as your old host, and make sure to overlap by a month to make sure the move is successful. For example, if you go from one Cpanel host to the other, you can either directly pull the site over from Cpanel (or have your host do it for you); or you can take the full site backup from one host, and use it to restore to the other host. Just access your new site and make sure its working before switching the IP address in your DNS. I would do a test run to make sure it works. Then after you've tested and are sure, then go back and shutdown the forum and do the real move so that you don't lose any posts that might happen during the time you are transferring the site. If the forum isn't to large, this should be a pretty quick process. As an alternative if you can't use the same control panel, then you will have to do it manually. In that case, you need to backup your vbulletin database, and the forum directory (the files). You can ftp the forum directory to your local PC, then copy it to the new site. You should be able to do this without shutting down the forum since the files don't generally change while the site is running. Then grab a full database backup from the old site, and you will need to create a database on the new server and restore the backup to it. It is possible that the naming and userid/password of the database on the new server is different from the old server. In that case, you'll need to update your forum configuration file to point to the new database. The closer you can keep things the better.
First of all, what is your forum using? Vbulletin? Discusware? PhpBB etc? All these have different ways of backup and restore.
im using vbulletin software, convergent thanks for help im trying to use manually and then i will tell you im succesull or not
If you are using vbulletin, then you need the forum directory (files) and the mysql database backup. Copy the files to the same place on the new host account... if you were running in /forums, then keep it in /forums. Then create a new MySQL database and userid/password and connect them. Then restore the database using the control panel. This should work, but if not it may be necessary to do the database backup manually from ssh and restore it that way, but in most cases I would think the database backup should work from one control panel to the other. Then go into /forums/includes/config.php and make the changes needed to reflect the new host account. Most likely you'll only need to update your MySQL database name and userid/password, but there may be other changes needed too. I'd start with that.