Welcome, Guest. Please Login or Register.
June 15, 2024, 05:30:59 AM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  How do you transfer database and all to a new server? « previous next »
Pages: [1] Reply Ignore Print
Author Topic: How do you transfer database and all to a new server?  (Read 838 times)
deadscion
Noobie
*
Posts: 8


yup
How do you transfer database and all to a new server?
« on: March 19, 2003, 10:14:49 PM »		 Reply with quote
I have secured webspace with a new host to ensure my visitors  a more reliable service.  What is the best way to move my forum without losing the MSQL database?
Logged
andrea
Global Moderator
YaBB God
*****
Posts: 4400


Peace on Earth

WWW
Re:How do you transfer database and all to a new server?
« Reply #1 on: March 19, 2003, 10:43:54 PM »		 Reply with quote
http://www.yabbse.org/community/index.php?board=135;action=display;threadid=15902
Logged
Andrea Hubacher

Download smileys here - please follow the TOS - bitte Nutzungsbedingungen beachten
deadscion
Noobie
*
Posts: 8


yup
Re:How do you transfer database and all to a new server?
« Reply #2 on: March 19, 2003, 10:56:48 PM »		 Reply with quote
This is great stuff but I'm a newbie here so I gotta ask the dumb question where is PhpMyAdmin?
Logged
andrea
Global Moderator
YaBB God
*****
Posts: 4400


Peace on Earth

WWW
Re:How do you transfer database and all to a new server?
« Reply #3 on: March 19, 2003, 11:01:15 PM »		 Reply with quote
Normally your hoster provides you a link to phpmyadmin, for example via cpanel or some similar program. Ask your hoster or read his FAQ pages...
Logged
Andrea Hubacher

Download smileys here - please follow the TOS - bitte Nutzungsbedingungen beachten
deadscion
Noobie
*
Posts: 8


yup
Re:How do you transfer database and all to a new server?
« Reply #4 on: March 20, 2003, 11:27:08 PM »		 Reply with quote
What I did for a complete transfer of the forum.
1)Using FTP and the old safe mode install instructions for a guide I transfered all the files and folders over to the new site by recommended ascii or binary format.
2) using phpmyadmin (www. domain name/phpmyadmin)
I saved a backup.sql of the MySql database.
3) With info from my new host I updated Settings.php with the new absolute root directory for PHP operations.
4) the restore operation for phpmyadmin would not work no matter what I tried.  So using the restore-script.txt and the tut instructions for proper ftp upload
the database came back instantly.

I thank you for the info and thought it only fair to sum up what I had accomplished.
Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  How do you transfer database and all to a new server? « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
 Valid XHTML 1.0! Valid CSS

Page created in 0.201 seconds with 21 queries.