|
|
|
|
![]() ![]() |
Jul 21 2005, 03:33 PM
Post
#1
|
|
|
Premium Member 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?
|
|
|
|
Jul 22 2005, 07:19 PM
Post
#2
|
|
|
Newbie [ Level 1 ] 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! |
|
|
|
Jul 23 2005, 02:42 PM
Post
#3
|
|
|
Premium Member 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..
|
|
|
|
Jul 23 2005, 04:07 PM
Post
#4
|
|
|
Super Member 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:
|
|
|
|
Jul 31 2005, 03:33 PM
Post
#5
|
|
|
Premium Member 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....
|
|
|
|
![]() ![]() |
Similar Topics
|
Lo-Fi Version | Time is now: 5th December 2008 - 01:08 AM |