harriko 0 Report post Posted July 21, 2005 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? Share this post Link to post Share on other sites
acidburn0520 0 Report post Posted July 22, 2005 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: mysql -u root -psecret -D stocks2 < stocksdb.sql root = your cpanel usernamesecret = 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! Share this post Link to post Share on other sites
harriko 0 Report post Posted July 23, 2005 is there any other way on cpanel? i dont think i have phpmyadmin.. Share this post Link to post Share on other sites
Houdini 0 Report post Posted July 23, 2005 If you are hosted by Xisto and have C Panel you have phpMyAdmin and it is here and looks like this: Share this post Link to post Share on other sites
harriko 0 Report post Posted July 31, 2005 well the server at the moment i am on doesnt have any phpadmin so i cant move it.... Share this post Link to post Share on other sites
