Thunder 0 Report post Posted July 18, 2004 Hi Can someone help me with transferring data from my forum to another forum. I would like to know how to transfer members and all that. Can someone help me with that do you just backup the mysql and just load it in the new one or wat? Share this post Link to post Share on other sites
Etherion 0 Report post Posted July 24, 2004 First of all, close the forum. If you use ipbOn the left hand side menu select "System Settings". That will open a sub-menu. In that menu select "Board on/off".... If you use phpbb, go to preferances and the same again...Ok Now..You must backup your database. Either from the forum or from phpmyadmin...Both fora got the backup mysql thing and it's easier, ok ? :Pin IPB (Add 'CREATE TABLE' statements? YesSkip non essential data? NoGZIP Content? Yes)Ιf you're good till now, it's easy...Now, you'll have to backup the whole site... You can do it using cpanel...SELECT BACKUP and you're ok...If you don't then you'll have to backup it throu ftp. Usually the public_html needs to be fully downloaded (and uploaded again)...For any questions ask me or pm me... Share this post Link to post Share on other sites
harad 0 Report post Posted July 24, 2004 PhpBB====https://www.phpbb.com/kb/article.php?article_id=9Description: How to move your boards to a different host, keeping the data intact. Author: Black Fluffy Lion Date: Tue Oct 29, 2002 4:07 pm Type: HowTo Keywords: backups, database, mysql, forum, move, transferring, different, other, host, server Category: Installing/upgrading/converting Since lots of people seem to be asking this, I've decided to make up a handy dandy idiot's guide on moving your fora to a different host. I backed up everything on the FTP but when I uploaded it to my new host all the information had gone! How comes? The files on your FTP, the ones you downloaded from sourceforge do not contain the data of your fora. The data is stored in (suprise, suprise) the database. That is where all your information (post text, members, smiley information etc.) is. If you don't want to lose that information you'll have to back up the database, backing up the files will do nothing. So how do I back up the database? If you have admin access to the site there's a nice little feature called backup database which (suprise, suprise) backs up the database! Click on it (remember, this is the idiot's guide, sorry if it sounds obvious) and back up the database with structure and data. Compress it if you wish, but only if your new server will be able to handle a gzipped file. That's all very well and good but I don't have admin access. How do I back it up now? You may have a nice little program called phpMyAdmin installed. This can also backup your database. To do so click on your username at the top of the left frame. Scroll down the right frame a bit until you reach 'View dump (schema) of database'. Again, you want to backup both structure and data. When you have selected the settings you want click 'Go' and you will download the dump file of your database. Easy huh?? I can't use the admin panel database backup option and I don't have phpMyAdmin. Can I still backup? Yes, but only if you have telnet access to your server. From the command-prompt, do the following: >mysqldump -u USERNAME -p DATABASE_NAME >backup.sql USERNAME is the mysql username for your database DATABASE_NAME is the mysql database name of the phpBB database Right, I've backed up my database. Now how do I restore all the information to my new host? Install phpBB2 at your new host and go to the admin panel and select 'Restore database'. Find the file on your computer and upload it! I don't have access to the admin panel! How can I restore it? If you don't have access to the admin panel then you can do it by phpMyAdmin as well. Click your username on the top left and scroll down the right frame until you reach 'Or Location of the textfile'. Click 'browse' and find the file. Click 'Go' and watch your database being uploaded! Note: phpMyAdmin cannot always handle uploading large databases. I can't restore it through the admin panel and don't have phpMyAdmin either. How do I restore the database? Copy the backup.sql file to the new server location and import it with: >mysql -u USERNAME -p DATABASE_NAME < backup.sql USERNAME is the mysql username for your database DATABASE_NAME is the mysql database name of the phpBB database Is that all? Almost...chances are your information has changed since your last host so make sure you update config.php to reflect these changes. Now, is that all? Yes. hope that was very easy to understand and that this question will not arise again... IPB====http://forums.xisto.com/no_longer_exists/https://www.invisionpower.com/support/guides?page=111====hope this helps. greetz Share this post Link to post Share on other sites
killer 0 Report post Posted July 28, 2004 man i would off never new that u helped me out 2 Share this post Link to post Share on other sites
novic_1223 0 Report post Posted February 26, 2009 omg you are so frikin smartpersonally i would have had to go copying and pasting everyhting one by onethanks so much , you are a real life saver\sorry if i did not post a way how to tranfer but thatsks for the help anyways:) Share this post Link to post Share on other sites
amrik09 0 Report post Posted April 16, 2009 hey guys if i backup only ftp folder , i need to backup database too? Share this post Link to post Share on other sites
