How to use a .sql file as a database

[Derek]

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

[kvhc128]

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.

[Derek]

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?

[kvhc128]

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.

[Derek]

One last question--Do you know the Database host? Is it stevie.heliohost.org or something?

[Ashoat]

It is "localhost".