Pages: [1] 
|
 |
|
Author
|
Topic: MySQL database set-up (Read 629 times)
|
colliope
ZboXian
 Offline
Posts: 33
|
Me again. This time I have questions on the database set-up. I'm moving my forum & gallery from their current host to Zbox and so need to change the database info included in one of the files.
1) I need the "dbname", which I will safely assume will be whatever I name it from the MySQL manager in the CP.
2) I need to know the "dbhost". On my other server, it's "db165.perfora.net". Not sure where to find this info/name for Zbox.
3) I need db user & password. Would this be the same username & password I use to log-in to my CP, or do I need to create a new user name & pw in the MySQL manager just for the database? The MySQL manager has a section that shows "Existing MySQL Users", a text box to enter a name & password, and then below that, a button that says "create MySQL user". I'm not sure if that means to enter my existing name & pw (for CP), or to make new ones and then press the "create" button.
Thanks,
Col
|
|
|
|
|
Logged
|
|
|
|
ZboX
Founder
Administrator
Posting Maniac
Offline
Posts: 1622
What 'ya got there??
|
Hi Col,
Ah, good ole 1and1.com. Man I haven't touched my account there in ages! 
1) I need the "dbname", which I will safely assume will be whatever I name it from the MySQL manager in the CP.
Right name it whatever you want. Keep in mind that ZboX will always put a "prefix" in front of your db name. The prefix will always be the username of your ZboX account followed by an underscore. For instance, for username "bill" and the database name "phpbb" the dbname would be "bill_phpbb". Without the quotes of course.
2) I need to know the "dbhost". On my other server, it's "db165.perfora.net". Not sure where to find this info/name for Zbox.
On ZboX it will always be "localhost".
3) I need db user & password. Would this be the same username & password I use to log-in to my CP, or do I need to create a new user name & pw in the MySQL manager just for the database? The MySQL manager has a section that shows "Existing MySQL Users", a text box to enter a name & password, and then below that, a button that says "create MySQL user". I'm not sure if that means to enter my existing name & pw (for CP), or to make new ones and then press the "create" button.
Ok I will need to know what it is you are trying to do to answer this one. If you are starting with a brand new database then yes, you will create a new username and password for the db in Cpanel's Mysql manager. If you are going to import your db from 1and1, that is a whole different can of worms. If you are importing, do you have the db file already on your PC? And if so, what form is it in? Is it a tar.gz file? Or a .sql file? Or is it just simply a .txt file?
Ain't this fun?
Bert
|
|
|
|
|
Logged
|
|
|
|
colliope
ZboXian
Offline
Posts: 33
|
If you are going to import your db from 1and1, that is a whole different can of worms. If you are importing, do you have the db file already on your PC? And if so, what form is it in? Is it a tar.gz file? Or a .sql file? Or is it just simply a .txt file?
For my phpforum, I used the "back-up database" option right in the admin panel to make a back-up file to save to the pc. First time I did it, I choose the tar.gz format. But then, following the instructions I found in the phpBB help forum, I didn't know what to do with it after. So I did the backup again but it saved as a .sql file. The instructions I have say to go to phpMyAdmin on my new server (Zbox) and choose "run a query from a textfile". Then it says to click on "browse", select the .sql file, and then press "Go". Then i'm supposed to be all set, assuming i did everything prior right. Does that sound right to you? I'm all ears if i should be doing it differently. I've already uploaded the directories/files, so my next step is figuring out the correct names/pws for the config file, and then I'll try uploading the .sql and see if it works. Which reminds me - please tell me there isn't going to be another name/password option in the MyAdmin! 
Ain't this fun!
Yes! Getting the forum & gallery going was the main reason I needed to move out of Arbor. Did not have enough space there, did not have a MySQL database to use, and something else - I think their version of php was wrong or something. So I signed up for the trial account at 1 & 1 where I had the goods I needed to try my hand at making the forum & gallery. It went so well and I had so much fun customizing them, I decided, ok, I can handle this, now I need a real home to move to. And hence Zbox.
The worst part was that phpMyAdmin is not pre-installed there, so in addition to installing the scripts for the gallery and the forum, I had to install that, too! But before I could install MyAdmin, I had to install something else called "Putty". I was going crazy trying to remember names/pwrds and what went went where. I am awful glad phpMyAdmin is already installed for me at Zbox!
After I get the forum move accomplished, I have to move my Coppermine gallery the same way. I already have the directories/files uploaded for that, but will have to go thru the same transfer of database and change of config file. I choose not to integrate the forum with the gallery, but know that they share the same database at 1 & 1. So, hmmm - since they share the same database, maybe that changes the whole process of how to transfer it?
Col
|
|
|
|
|
Logged
|
|
|
|
ZboX
Founder
Administrator
Posting Maniac
Offline
Posts: 1622
What 'ya got there??
|
For my phpforum, I used the "back-up database" option right in the admin panel to make a back-up file to save to the pc. First time I did it, I choose the tar.gz format. But then, following the instructions I found in the phpBB help forum, I didn't know what to do with it after. So I did the backup again but it saved as a .sql file. The instructions I have say to go to phpMyAdmin on my new server (Zbox) and choose "run a query from a textfile". Then it says to click on "browse", select the .sql file, and then press "Go". Then i'm supposed to be all set, assuming i did everything prior right. Does that sound right to you? I'm all ears if i should be doing it differently. I've already uploaded the directories/files, so my next step is figuring out the correct names/pws for the config file, and then I'll try uploading the .sql and see if it works.
Ah ok. In that case, in your Cpanel in the "Site Management" section, click on "MYSQL Databases". In that screen look for the text box labeled "MYSQL Database". Enter the name you would like for your db there. Do not add the prefix. That will be added automatically. Then click on the "Create MYSQL Database" button.
Next, you need to create the db username and password. Scroll down to "Existing MYSQL Users". In the form box there enter the username and password you prefer. Once again, don't add the prefix, that will be done automatically. Now click on the "Create MYSQL User" button.
Now we add the usernam and password to the db. Scroll to the Grant permissions on a MySQL database to a MySQL user" section. In the "User" drop down list, select the user you just created. In the "MySQL Database" drop down list to the right select the db you just created. In the "Permissions" checkboxes make sure the "All" box is checked. Then click on the "Grant Permissions" button. Ok, now your db, username, and password have all been created and linked.
Now we go to Phpmyadmin. On the drop down list at the top left, select the db you just created. Now, click on the "SQL" button to the top right in the button row. When the screen comes up, click on the "browse" button and upload the .sql file you downloaded from your Phpbb intstall from the other server. Watch the progress bar in your browser. That is the only indication you will get during the upload. It will NOT tell you when the upload is complete. Once that is done, click on the "Structure" button at the top. When the screen comes up, you should now see all of your db tables listed.
Now all you need do is edit the php.conf file in your Phpbb directory at ZboX and change to the new db name, password, and severname "localhost".
Bert
|
|
|
|
|
Logged
|
|
|
|
colliope
ZboXian
Offline
Posts: 33
|
Thankyou! I am printing these directions . Will let you know how I make out.
Col
|
|
|
|
|
Logged
|
|
|
|
Pages: [1] 
|
|
|
|
|
