Jamroom Logo Jamroom 5 Core
is now Open Source!
User Support Forum Archive (Read Only)
The Greenroom:
How easy is....
Kaduce



Joined: 16 Dec 2003
Posts: 133

Posted: 01/12/04 23:11 
Jamroom to transer to another server? I won't lose any data will I?

Back to top
Jorel



Joined: 26 Nov 2003
Posts: 404
Location: Grand Rapids, Michigan

Posted: 01/12/04 23:17 
really pretty easy. it depends on the setup though.
you just FTP everything from your site to your computer. and then download your database.
upload everything onto the new server, and then upload the database. change permissions if needed. that's pretty much it.


_________________
http://www.hxcmp3.com - 20,000+ bands and counting
Back to top
Kaduce



Joined: 16 Dec 2003
Posts: 133

Posted: 01/12/04 23:27 
What do you mean by download your database? Won't I have to change MySQL info?

Back to top
Kaduce



Joined: 16 Dec 2003
Posts: 133

Posted: 01/13/04 20:57 
How do I download my database?

Back to top
musicbuzz



Joined: 23 Sep 2003
Posts: 19
Location: Bay Area, CA

Posted: 01/14/04 01:40 

Kaduce:
How do I download my database?


Use phpMyAdmin. Go to export and select all your tables and do a save as.


_________________
http://www.MP3N.com { my jamroom site coming soon }
http://www.paulandre.com
http://www.2nv.com
http://www.jockable.com
Back to top
member



Joined: 02 Oct 2003
Posts: 82

Posted: 01/14/04 13:05 
Be carefull..if your admin is lke mine you will have words like DUMP, and DROP. Be warry warry careful.

Read on your support site about backing up your MySQL files before you jump into it.

Back to top
Kaduce



Joined: 16 Dec 2003
Posts: 133

Posted: 01/14/04 17:05 
Alright, I am way confused, no way I'm going to be able to do this. If someone will help me.... like walk me thru it, I will be more than happy to pay a little something via paypal.

Back to top
Kaduce



Joined: 16 Dec 2003
Posts: 133

Posted: 01/14/04 17:36 
Alright, I have it downloaded, now where do I upload the database in myphpadmin?

Back to top
Brian
Jamroom Team


Joined: 09 Jul 2003
Posts: 37583
Location: Seattle, WA

Posted: 01/14/04 18:54 

Kaduce:
Alright, I have it downloaded, now where do I upload the database in myphpadmin?


I'm not sure about using phpmyadmin, but here's some steps yo can do using Jamrooms's database backup (you'll need to have shell access for these steps):

1. Backup your current database by choosing "Backup Database" from the Admin menu. It will download an SQL file to your computer, so save it somewhere.

2. backup your current Jamroom data by downloading your jamroom directory to your compter - this could take a while if you have gigs and gigs of songs. Note that if you are transferring servers on the internet, you can also just FTP directly from host to host.

3. On your new server you are going to, create a directory for Jamroom, and install Jamroom as if you were doing a new install. DO NOT add anything or modify anything in this new install though - once you see the "install successful" screen that's as far as you need to go. This will let you use a different database user/password then you are currently using, if needed.

4. Now copy all the data (everything in the songs / bands and uploads directories) that you backed up in step 2 into your new Jamroom directory, basically re-creating on the file side what your previous server looked like. Once again, there wil already be a jamroom/config/.htaccess file in your new Jamroom from your new install - don't over write that.

5. copy the .sql file from step one up to your new server into your jamroom directory. Let's say it is called "jamroom_backup.sql". From your new server, run the command:

Code

mysql -u (database_user) -p < jamroom_backup.sql

where "(database_user)" is the name of the Jamroom database user on your new server. You'll be prompted for your Jamroom database user password - enter it, and mysql wil read in all of the commands from the jamroom_backup.sql file and "reload" your database with the contents of your previous database.

That's it - you should be good to go!

Hope this helps!

- Brain


_________________
Make sure and check out:
* The Jamroom FAQ
* The Jamroom Documentation
Back to top
Display posts from previous:   
User Support Forum Archive (Read Only)
The Greenroom

 
Solutions
• Social Media Platform
• Social Networking Software
• Musician Website Manager
• Community Builder
Products
• Jamroom Core
• Jamroom Addons
• Jamroom Modules
• Jamroom Marketplace
Support
• Support Forum
• Documentation
• Support Center
• Contact Support
Community
• Community Forum
• Member Sites
• Developers
Company
• About Us
• Contact Us
• Privacy Policy
©2003 - 2010 Talldude Networks, LLC.