Welcome Guest ( Log In | Register )



 
Reply to this topicStart new topic
> Moving Server To Server?, how to...?
harriko
post Jul 21 2005, 03:33 PM
Post #1


Premium Member
Group Icon

Group: Members
Posts: 279
Joined: 2-February 05
From: UK
Member No.: 2,480



i wondered how to moving all your data on a server to another new server. like invisionboards and database. moving them so it be exactly the same when moved to another server. I think it is done by backups? i tried it but didnt work? help?
Go to the top of the page
 
+Quote Post
acidburn0520
post Jul 22 2005, 07:19 PM
Post #2


Newbie [ Level 1 ]
Group Icon

Group: Members
Posts: 1
Joined: 22-July 05
Member No.: 7,366



Okay if you want to move a database, just go into phpMyAdmin and export the database into a .sql file. Then on the server that you're moving to use SSH/Shell to restore the database.

Command to execute in Shell for database restore:
CODE
mysql -u root -psecret -D stocks2 < stocksdb.sql


root = your cpanel username
secret = your password
stocks2 = the database you want to restore your sql file into. This must be created already!
stocksdb.sql = the path to your .sql backup you have of your invision board. In this case the .sql would need to be placed in your / directory... just outside of public_html.

Execute that command in Shell and it will restore your database, then just move over your FTP files and you're good to go!
Go to the top of the page
 
+Quote Post
harriko
post Jul 23 2005, 02:42 PM
Post #3


Premium Member
Group Icon

Group: Members
Posts: 279
Joined: 2-February 05
From: UK
Member No.: 2,480



is there any other way on cpanel? i dont think i have phpmyadmin..
Go to the top of the page
 
+Quote Post
Houdini
post Jul 23 2005, 04:07 PM
Post #4


Super Member
Group Icon

Group: Members
Posts: 572
Joined: 25-April 05
From: Nashville Tennessee
Member No.: 4,340



If you are hosted by astahost and have C Panel you have phpMyAdmin and it is here and looks like this:
user posted image
Go to the top of the page
 
+Quote Post
harriko
post Jul 31 2005, 03:33 PM
Post #5


Premium Member
Group Icon

Group: Members
Posts: 279
Joined: 2-February 05
From: UK
Member No.: 2,480



well the server at the moment i am on doesnt have any phpadmin so i cant move it....
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Mini Apache Server W/ Php(5)
  2. Server Os(16)
  3. How To: Create PDF With Php(18)
  4. Uploading Image File Through JSP Code To Server(9)
  5. Counter-Strike Source Clans - Post Your Server IPs(18)
  6. Restarting Apache Server(14)
  7. How Do I Host My Own America's Army Server?(4)
  8. Server Behind Router(7)
  9. How To Set Up A Dedicated Server(29)
  10. Help: Setting Default Index Page on XAMPP Web-Server(6)
  11. Free Ragnarok Online Server(5)
  12. Counter Strike Server(4)
  13. Database Access On Remote Server W/jsp(0)
  14. Common Ftp Server Error Codes(0)
  15. Create An Ftp Server On Your Pc With Serv-u(1)
  1. Bulletproof Ftp Server Tutorial(0)
  2. Moving To Fedora 9(1)
  3. Free Remote Wireless Server?(1)
  4. New Ro Server(2)
  5. Wamp Server Problems(5)
  6. Server With Quest?(6)
  7. Gmail For Mail Server.(7)
  8. How To Validate The Login Form Using Php Pcre(0)
  9. How To Make Sure Your Server Can Generate Images(0)
  10. Google App Engine(1)
  11. Email Server / Cpanel Problems(1)
  12. In Php- How To Send Mail From Localhost To Web Mail Server(0)
  13. View Php In Another Server(4)


 



- Lo-Fi Version Time is now: 5th December 2008 - 01:08 AM