Derek Posted November 21, 2008 Share Posted November 21, 2008 On my old web hosting service I spent a long time to make my database. Once I decided to switch services I downloaded the database. I've renamed the database to have the "username_" prefix using TextEdit, but I have no idea how to upload the .sql file into my database. Please help, I really don't want to remake the database Thanks, ~Derek Quote Link to comment Share on other sites More sharing options...
kvhc128 Posted November 21, 2008 Share Posted November 21, 2008 Go to phpmyadmin(in Cpanel), click on import (top menu), browse and find your sql file, then click Go. You can also execute a SQL query by clicking on SQL (top menu), typing or pasting your query and clicking go. The first method is the easier one. Quote Link to comment Share on other sites More sharing options...
Derek Posted November 21, 2008 Author Share Posted November 21, 2008 Thanks, I can't believe I missed that. It was the first place I checked! But I also have another question. I have a forum on my webpage thats based on PunBB. I renamed my database so HelioHost can use it. But I would have to re-setup my forum to use the database. Do you think, in your opinion, that if I re-setup the forum and tell it to use my database, that it will use the stuff in the database and not overwrite it? Quote Link to comment Share on other sites More sharing options...
kvhc128 Posted November 21, 2008 Share Posted November 21, 2008 I am not that familiar with PunBB, but I believe that you can just change the config.php file(or some other configuration file, like most php forum software that require MySQL). Set the database information inside the file to that of Heliohost. It will not overwrite the data, it is just telling PunBB to get information (threads, replies, users, et cetera) from that database. Since you already transfered the .sql data, everything should then be working properly. Quote Link to comment Share on other sites More sharing options...
Derek Posted November 21, 2008 Author Share Posted November 21, 2008 One last question--Do you know the Database host? Is it stevie.heliohost.org or something? Quote Link to comment Share on other sites More sharing options...
Ashoat Posted November 21, 2008 Share Posted November 21, 2008 It is "localhost". Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.