Lunarpages Web Hosting Forum

Learn More About Lunarpages Hosting => Web Hosting Tutorials, FAQs and Resources => Topic started by: Admin on April 08, 2004, 07:00:11 AM

Title: How To: Add tables to your existing Database
Post by: Admin on April 08, 2004, 07:00:11 AM
Posted for Chelle.  Thank you so much for doing this :)
 
======================================
 
Feedback/Suggestions will be much appreciated.

If youíre on the Shuttle plan, youíve been given one database.  Perhaps youíve installed the nifty board/Nuke/shopping cart/phpMyChat via Cpanel, using the one click, no worries install.  Now you want something else on your site that requires a database.  So you simply do another one click install, but it tells you you need a database.  Oh no!

Fear not.  If you donít want to buy another database, this How To will show you how to add to your existing database.  Basically what youíll be doing is adding tables to your existing database.  First things first, getting acquainted with your database tools.

On CPanel, you have an icon that says MySQL Databases.  Click on that.

(http://www.sansdreamscape.net/images/howto/db/db1.gif)


If you installed anything using CPanel, the database was automatically created for you.  Per the figure, the user name is the user name you were given when you first got your Lunarpages account.  The data base name is the name of your database.  The syntax is that your user name is the prefix for anything related to the database, as you can see in the figure.  In this figure, chelle is the user name created for the database.  

As a review, syntax is as follows:

Lunar-Pages-User-Name_Database-Name
AND
Lunar-Pages-User-Name_Database-User-Name

*NOTE: the prefix isnít attached to the passwords.  Bear that in mind when you edit any config files.


The one click install already created a user.  You can see this in the figure above. This picture shows the users in the database nuke, which is usern2_chelle.  It shows the user, the privileges granted, and the option to Delete the user.  usern2_chelle has all privileges.  For the things your installing the user you put into your config files needs to have the ĎAll Privilegesí box checked.  For simplicity, you can use the same user that the one click install created.  If this is fine, skip down to Using phpMyAdmin.  

If you want to create a different user, follow the following steps:

To create a user for your database

Scroll down to the next section.

(http://www.sansdreamscape.net/images/howto/db/db2.gif)

Enter a username and a password, then click Add User.  You should see the new user when the page refreshes.  For this example, usern2_chelle will be the user for the database.

Now you have to add this user to the database.  Basically you're letting the database know that this user is ok'ed to manipulate the data stored in there.  Scroll up till you see this

(http://www.sansdreamscape.net/images/howto/db/db1.gif)  

[orange arrow indicators]  Select the user you just created in the drop down box.  Make sure the ĎAll Privilegesí box is checked.  Then click Add user.  You should see your new user when the page refreshes. Now you're set as far as the user is concerned.

Using phpMyAdmin

Scroll to the bottom of the page, and click on phpMyAdmin [red circle].

(http://www.sansdreamscape.net/images/howto/db/db2.gif)

 Youíll get a pop up asking for a user name and password.  Use the user name and password given to you by Lunar Pages.  A new page will open up.  Sometimes, Iíll get an error page.  Just refresh and phpMyAdmin should load. Once logged in, you should get a screen like this:

(http://www.sansdreamscape.net/images/howto/db/db3.gif)

This tool will help you manage the data in your database.  Click where indicated on the figure [yellow arrows].  If you click Databases you'll see your database name, click on that. Depending on what you installed will determine what you see.  In my case, I had Nuke installed, so I saw rows of nuke_filename where nuke is the prefix for all the table entries associated with my Nuke install.  These are table entries.

(http://www.sansdreamscape.net/images/howto/db/db4.gif)

 If you let your mouse settle over the icons, it will tell you their function.

(http://www.sansdreamscape.net/images/howto/db/icons.gif)

1st: Browse will let you browse the content of that table.
2nd:Search will let you search through the data in that table
3rd:Insert will let you insert a new instance of data into the table
4th:Properties will show you the table properties of the fields in it
5th:Drop: the red trashcan deletes the whole table, everything
6th:Empty: the white trashcan just empties out the data in the table, but leaves the table still there.

A breakdown of terminology:

Table: A database is made up of tables, that contain information
Field: is a value in the table. For instance, when you register somewhere, Name is a field within the a table. A table can have many fields.
Data: specific values held in fields. What you input. So the data in the field ĎNameí would be Joe Smith.

Creating Tables in phpMyAdmin

The file that actually creates tables is the .sql file that should be in the files you've downloaded.  Most times it's in its own folder called sql.  Now there are one of two things you're going to be doing.  You're either going to edit the .sql file or you'll leave it alone.  If you're installing another of the same thing [in my case, I have two instances of Nuke installed on my site], you'll need to edit the .sql file.  It's really simple.  If you're not, then you just need to know where the .sql file is located.  [If this applies, you can skip to the next section].

When you have to edit the .sql file

Using Nuke as an example:  the file that creates the database for Nuke is nuke.sql.  A quick way to create a new set of tables for an additional instance of nuke is to open nuke.sql in an editor, click on search/find and enter the word nuke and have it replaced with a new name.  For simplicity sake, I replaced nuke with nuke2.  Save your new .sql file under a new filename.  

The reason you're doing this is because you already have tables in your database with the 'nuke' prefix.  So to have a totally different  instance of nuke on your site, you will have to give its tables a different prefix.  To see an example, compare

http://portal.sansdreamscape.net and

http://sansdreamscape.net/chronicle

They look the same [theme being the same was my doing], but the data is different. A good way to see this is to look at the Forums module. The posts, and even the boards themselves aren't the same because the data for each has their own 'home.'


Uploading the .sql File

Now, in your phpMyAdmin window, click the link in the lower left hand corner 'Query window'  A new window will pop up.  

(http://www.sansdreamscape.net/images/howto/db/db5.gif)

Click on import files [middle tab at the top].  Click Browse and choose the .sql file you've changed [if you're installing two of the same thing] or the .sql file that came with the downloaded files.  In this case, the new file saved was nuke2.sql.  Then click go.

(http://www.sansdreamscape.net/images/howto/db/db6.gif)

After a moment, your page should refresh and you should get a message informing you of how many new tables were recreated.  On your left, the frame should refresh, showing the new tables as well.

(http://www.sansdreamscape.net/images/howto/db/db7.gif)

You've just created the database for your what you wanted to install.  Now, follow the rest of the installation instructions.  In this case, for my second installation of nuke, I have all the tables it needs [the nuke2 tables].  The config.php file for that instance should look like:

Code: [Select]
$dbhost = "localhost";
$dbuname = "usern2_chelle";
$dbpass = "your_chosen_password_here_without_usern2_prefix";
$dbname = "usern2_nuke";
$prefix = "nuke2";
$user_prefix = "nuke2";
$dbtype = "MySQL";
$sitekey = "your_chosen_site_key";
$gfx_chk = 6;
$subscription_url = "";


Essentially you can copy your original config file and just change the prefix and user prefix unless you created a different user.  Just make sure the user you put in your config file has been added to the database and has all privileges. [See above steps].

Congrats, you've just added table to your existing database!  Go you :thumb:
Title: How To: Add tables to your existing Database
Post by: DaveW on April 17, 2004, 03:21:18 PM
Nice tutorial and addition to a very popular and most asked question Kathleen :yey:
Title: How To: Add tables to your existing Database
Post by: leighsww on April 17, 2004, 03:29:45 PM
WOW, awesome and extensive tutorial!  Good work, Chelle!!  :thumb:  :yey:
Title: How To: Add tables to your existing Database
Post by: Chelle on May 01, 2004, 09:38:52 AM
Just noticed the feedback.  :)   Thanks, I'm glad I could contribute!
Title: How To: Add tables to your existing Database
Post by: MPG on June 23, 2004, 03:30:26 PM
Thank you for this!  Its great. :thumb:
Title: Re: How To: Add tables to your existing Database
Post by: martino on June 25, 2004, 06:26:53 PM
Click on import files [middle tab at the top].  Click Browse and choose the .sql file you've changed [if you're installing two of the same thing] or the .sql file that came with the downloaded files.  In this case, the new file saved was nuke2.sql.  Then click go.

I am missing something on this part. I have the phpbb on my inital database. I cant seem to find the sql file that i dowloaded. CAn you help me or elaborate cause i am having a bit of difficulty understanding. Thanks in advance.
Title: How To: Add tables to your existing Database
Post by: Chelle on June 26, 2004, 11:42:16 AM
Sure!  Basically what this means is this.  The file that creates the tables in your database is a .sql file.  For php Nuke, the filename is nuke.sql. SOme other scripts will actually do everything for you after you enter in some key information.  Using Hush's How To found here (http://www.lunarforums.com/forum/viewtopic.php?t=9761&postdays=0&postorder=asc&start=0)  phpbb [I'm assuming you're wanting to add another phpbb?] creates the tables in the database for you based on your input on the install.php page.

Quote
INSTALLING PHPBB

You will need the following information ready:

+ Your database name (this will be in the format username_databasename)
+ Your database User (this will be in the format username_databaseuser)
+ Your database password (this will simply be as you typed it)

Start by opening a new browser and typing in the address to your PHPBB directory and the install file:
http://www.yourdomain.com/phpBB2/install/install.php

This will load a simple form for you to fill out. The import fields are:

DATABASE TYPE: MySQL 4.xx
DATABASE SERVER: localhost
DATABASE NAME: - per my example in the how to: usern2_databasename
DATABASE USER: - per my example in the how to: usern2_databaseusername
DATABASE PASSWORD: - password, with no prefix

The remaining settings are personal to you, and should be straight forward to complete.

You will then need to click the submit button at the bottom of the page. This will process the information and is meant to

update the configuration file for PHPBB. In my experience, however, this is normally stopped by permissions. Do not worry,

simply select to down load the file and install manually.

As you click the submit button you will be prompted to save the configuration file, select a folder where you will easily

find the file. Once downloaded, you must upload this file to your PHPBB folder:
http://www.yourdomain.com/phpBB2

Now delete the following folders within your phpBB2 folder:

install
contrib

Finally, open up a browser window and type the address for your PHPBB:
http://www.yourdomain.com/phpBB2



So a few things to check:  The folder you're putting your new phpbb in.  Is it created?

If so, then all you need to do is upload all of your phpbb files into that folder.  Per the above, type into your browser the address to get to the install.php page.

Fill in your info.  When you get to table prefix..choose a prefix different than what your current phpbb uses.  For example, if your current one uses phpbb then use something like bb2.  For security, you might want to use something that isn't overtly obvious.  I hope that clears up your confusion.  Keep posting till you get it the way you want it! :D
Title: How To: Add tables to your existing Database
Post by: Chelle on June 26, 2004, 11:43:09 AM
Quote from: MPG
Thank you for this!  Its great. :thumb:


Aww shucks.  :D   I'm glad people have found it helpful.
Title: .sql
Post by: Campus Frenzy Dot Com on June 28, 2004, 09:11:08 AM
I cant seem to find the .sql file.. i only have phpbb installed.. can anyone help?
Title: Re: .sql
Post by: martino on June 28, 2004, 10:17:46 AM
Quote from: Campus Frenzy Dot Com
I cant seem to find the .sql file.. i only have phpbb installed.. can anyone help?


Thats the same problem I am having. I also only have phpbb installed, and now i want to install the poll script, but i cant find the .sql file to change it. Can somebody help please. Thanks in advance.
Title: How To: Add tables to your existing Database
Post by: Chelle on June 28, 2004, 12:50:52 PM
FOr both martino and Campus Frenzy Dot Com:

If there isn't an .sql file in the files you downloaded, there's a chance that the script you wanting to add creates the tables itself, much like phpbb does when you run the install.php page.  Martino, I"ll go look at the poll script to double check and get back to you.

CFDC:  what script are you trying to install?
Title: How To: Add tables to your existing Database
Post by: Chelle on June 28, 2004, 01:06:04 PM
Martino:  If you're trying to add Advanced Poll, the installer script creates the tables for you.  The only thing you need to worry is that you have the file config.inc.php correct.

If you're trying to add phpESP there is a .sql file, but I think you would have found that  :)


If you're trying to add phpsurveyor, it has a script that creates tables for you.  Again, be sure your configuration settings are correct and you should be good to go.

Let me know how it goes for you.
Title: Umm in particular the 4images gallery
Post by: Campus Frenzy Dot Com on June 28, 2004, 04:31:08 PM
Umm in particular the 4images gallery  :D
Title: How To: Add tables to your existing Database
Post by: Campus Frenzy Dot Com on June 28, 2004, 04:33:42 PM
as well as phpadsnew
Title: How To: Add tables to your existing Database
Post by: Chelle on June 28, 2004, 05:17:11 PM
CFDC:  According to the install file for 4images, the install script will create the tables for you.  So all you have to worry about is making sure the config file is correct.i.e. that your database name, username, password are all correct.  After running the install script, you should be right as rain.


For phpadsnew:  Same thing.  It has an installer script that does the work for you.  As long as you fill in the correct settings, you should be fine.

Hope this clears things up for you.
Title: hmm
Post by: Campus Frenzy Dot Com on June 28, 2004, 05:20:58 PM
It wont let me install, it says my dbs are taken up.. how do get to/edit the config file..? :?
Title: How To: Add tables to your existing Database
Post by: Chelle on June 28, 2004, 05:24:31 PM
Are you trying via Fantastico?  It sounds like you are.  You won't be able to do one click installs if you want to add more scripts and only have one database.  From what I've read on the installs of the scripts you want to add, you're going to have to do this manually.  Which really is just downloading the files, uploading them to where you want them and running the install scripts per the install instructions.

If you have all those files, you can edit the config file directly using an editor.  For the gallery it was called config.php.  For the ads script it was something like config.inc.php.  However, the instructions say to not edit it outright, it could give you problems.
Title: How To: Add tables to your existing Database
Post by: Campus Frenzy Dot Com on June 28, 2004, 05:25:03 PM
""You have reached the maximum of allowed MySQL databases. Fantastico can not proceed with installations until you upgrade your account or reduce the number of used databases (for example by uninstalling a script).""

How do I edit my "config" file.... and where is that at? :?
Title: How To: Add tables to your existing Database
Post by: Campus Frenzy Dot Com on June 28, 2004, 05:25:42 PM
oh sorry :) thanks
Title: How To: Add tables to your existing Database
Post by: Chelle on June 28, 2004, 05:32:13 PM
No worries.  We've all been there before.  Hope it'll play nice for you now.
Title: 4images isntall
Post by: Campus Frenzy Dot Com on June 28, 2004, 05:48:30 PM
Im getting the error


DB Error: Bad SQL Query: SELECT setting_name, setting_value FROM 4images_settings
No Database Selected

when trying to install 4images
Title: How To: Add tables to your existing Database
Post by: Chelle on June 29, 2004, 01:00:29 AM
When you get a no database selected error, it means it can't connect. 9 times out of ten, the culprit is incorrect configuration settings in the script's config file.

According to the install instructions:  Upload everything to you site.  So, let's say you want to put 4images into a folder called gallery.  Then you should have all of your 4images files located at

http://www.campusfrenzy.com/gallery

Next type the following into your browser to start the install

http://www.campusfrenzy.com/gallery/install.php

It should ask you for settings[database name, username, password.  See the first post for what this would be], according to the install.  Be sure to fill everything correctly.  After that, you should be good to go.  You should do something similiar with the ads script you want to add.  Be sure to follow the instructions carefully.
Title: How to upgrade acct to add another db
Post by: BlakeEHSO on July 10, 2004, 02:50:35 PM
fantastico tells me my one db is in use (true) and I need to upgrade to add another DB so I can install PostNuke.  How do I do this?  

thanks

Blake
Title: How To: Add tables to your existing Database
Post by: Chelle on July 10, 2004, 03:41:23 PM
In order to install PostNuke, you'll have to do it manually.  Meaning that you'll have to download the latest PostNuke and follow the install directions that come with it.  If it's similar to PHP Nuke, then there's prolly a .sql file that will create the tables you need to have that running.  And how to do that is detailed in this How To.  So far ppl haven't had troubles following it, so you should be good to go in that aspect.  Plus the forums are awesome in helping you through any troubles you encounter.

The thing with Fantastico, like all the other scripts you can install with LunarPages is that it requires a fresh database.  If you don't want to do the install manually, you'll have to purchase an additional database at the cost of $1/month.  

It might seem daunting, but it isn't all that hard.   Give it a try.  Plus, make a backup of your database as it is now
Title: How To: Add tables to your existing Database
Post by: BlakeEHSO on July 10, 2004, 06:06:50 PM
Ah... actually my problem isn't the technical side; it is simply that I need to know how, who or where I go to order another db to be added to the website.  I can't find a link to your ordering process.  At least not on control panel.  Did I miss it there or is there another logon that I've forgotten about for account maintenance and ordering more features?

Thanks!!

Blake
Title: How To: Add tables to your existing Database
Post by: Chelle on July 11, 2004, 03:03:23 AM
Here's a thread that has a workaround

http://www.lunarforums.com/forum/viewtopic.php?t=16825&highlight=order+another+database

You can e-mail support@lunarpages.com with your username, server name, and last 4 digits of your credit card, and tell them you want another database ($1/month).  If I'm not mistaken, they'll charge you for a year up front so you'll pay $12.


  Hope that helps!  :D
Title: How To: Add tables to your existing Database
Post by: BlakeEHSO on July 11, 2004, 07:57:17 AM
Thanks!  That is very helpful!  

I wonder why they simply don't add that to the text that appears to say "you need to order another database to add this feature".  Duh!  they have actually made it difficult to order more of their services... strange.

Blake

Quote from: Chelle
Here's a thread that has a workaround

http://www.lunarforums.com/forum/viewtopic.php?t=16825&highlight=order+another+database

You can e-mail support@lunarpages.com with your username, server name, and last 4 digits of your credit card, and tell them you want another database ($1/month).  If I'm not mistaken, they'll charge you for a year up front so you'll pay $12.


  Hope that helps!  :D
Title: How To: Add tables to your existing Database
Post by: BlakeEHSO on July 11, 2004, 07:59:14 AM
You have the same problem I do.  We need to order another db - see Chelle's note to me.

Blake

Quote from: Campus Frenzy Dot Com
""You have reached the maximum of allowed MySQL databases. Fantastico can not proceed with installations until you upgrade your account or reduce the number of used databases (for example by uninstalling a script).""

How do I edit my "config" file.... and where is that at? :?
Title: How To: Add tables to your existing Database
Post by: Chelle on July 13, 2004, 06:57:27 AM
No problem.  Glad I could help you out.  :thumb:
Title: How To: Add tables to your existing Database
Post by: draca on August 05, 2004, 03:00:35 AM
i added the tables just like in that guide (but i didn't read the guide)
anyway, i'm trying to use phpcomic-.. i got the imported database tables..
but when i access the phpcomic site i don't get an index file or anything i just see the list of files in that dir. something's wrong O_O
Title: How To: Add tables to your existing Database
Post by: TranzNDance on August 05, 2004, 04:22:06 AM
Quote from: draca
i added the tables just like in that guide (but i didn't read the guide)
anyway, i'm trying to use phpcomic-.. i got the imported database tables..
but when i access the phpcomic site i don't get an index file or anything i just see the list of files in that dir. something's wrong O_O

What is the index file called exactly? Capitalization matters. Please provide a url to the problem folder.
Title: How To: Add tables to your existing Database
Post by: draca on August 07, 2004, 03:16:21 PM
it solved itself.. it wasn't an SQL problem as i first thought..

the dev of the cusp script had not bothered with putting a collect index file for the contents his script provided. i just needed to build an index.php which sustained dynamic contents from the other pages.

i'm problem free running 3 applets in 1 database now.. works like a charm.
Title: How To: Add tables to your existing Database
Post by: SunspotWendy on August 12, 2004, 08:34:01 AM
Hi,

I'm trying to Import the SQL file for PHPlist.

When I click the Query button to use the "Import files" function, the window pops open but in the corner of the browser it says:

"Done, but with errors on the page".

Then when I select my .sql file and click Go, it doesn't do anything.  I checked the database and nothing seems to have changed...

Any suggestions?  Thanks in advance.  :)
Title: How To: Add tables to your existing Database
Post by: SunspotWendy on August 12, 2004, 08:46:39 AM
Thanks, but I don't think that will help: I tried logging in again and starting over, and it seems the "errors on page" message appears the instant I click on the text entry box in the Query window.

What's going on... Could this be an IE security thing?  :(
Title: How To: Add tables to your existing Database
Post by: Chelle on August 15, 2004, 06:15:53 AM
Hmm, never ran into that.  phpMyAdmin is third party, so perhaps it's on their side?? You said you've tried refreshing and relogging in....I've had it happen where I created tables and nothing, but I kept trying and they got added eventually.  Sorry if the whole 'Keep on, keepin on' isn't all that helpful,  :?

Here's another way.  Log in, click on MySQL databases, scroll to the bottom and click on phpMyAdmin.  Then once logged in there, click on Databases link in the right frame.  Click on the link of your database.  You should get a listing of all tables in there.  Now click on the SQL tab.  This is just another way to get to that page w/o it popping up.  Either paste the .sql contents in the field like TranzNDance suggested, or upload the provided sql file.  See if it'll take that way and keep up posted :thumb:
Title: How To: Add tables to your existing Database
Post by: SunspotWendy on September 20, 2004, 10:22:32 PM
Quote from: Chelle
Log in, click on MySQL databases, scroll to the bottom and click on phpMyAdmin.  Then once logged in there, click on Databases link in the right frame.  CLick on the link of your database.  You should get a listing of all tables in there.  Now click on the SQL tab.  This is just another way to get to that page w/o it popping up.  Either paste the .sql contents in the field like TranzNDance suggested, or upload the provided sql file.  See if it'll take that way and keep up posted :thumb:


I know I am WAY late responding to this, but in case somebody turned this up in a search and is wondering the end result, the above suggestion did work.  Thanks for your help!  :)
Title: How To: Add tables to your existing Database
Post by: Chelle on September 21, 2004, 02:32:21 AM
:yey:

So glad it worked for ya!  Thanks for letting everyone know how it turned out.   :D
Title: How To: Add tables to your existing Database
Post by: h2-one on October 27, 2004, 04:17:07 AM
I have installed the phpBB on my site, but only for temporary. I would like to install an e107 board. I know that you need a database for this before the install.php will work.
Can I create a table using the existing phpbb database that was auto created, before I ftp the e107 board?
Title: How To: Add tables to your existing Database
Post by: GarveysIT on October 27, 2004, 04:19:20 AM
if the install of e107 has no tables the same names phpbb you should be ok with the install, if it has some the same you will have to set a prefix to all the tables, have you checked if the install file has a prefix option?
Title: How To: Add tables to your existing Database
Post by: h2-one on October 27, 2004, 04:21:19 AM
No, but I will look now. I do not believe any of the files have the name phpbb.
Title: How To: Add tables to your existing Database
Post by: h2-one on October 27, 2004, 04:25:33 AM
Yes, I was correct..no files have the name phpbb. So I can use the existing database without having to create another table?
What happens when I wish to uninstall the phpbb?
Title: How To: Add tables to your existing Database
Post by: GarveysIT on October 27, 2004, 04:33:40 AM
you will have to go into the mysql databse and remove the tables manually...
Title: How To: Add tables to your existing Database
Post by: rbweh on November 28, 2004, 01:36:52 PM
My 'go' button on the Import Files tab seems to be broken in Mozilla and IE.  It doesn't do anything!  What's going on?
Title: How To: Add tables to your existing Database
Post by: Chelle on January 04, 2005, 11:48:25 AM
Quote from: Chelle
Hmm, never ran into that.  phpMyAdmin is third party, so perhaps it's on their side?? You said you've tried refreshing and relogging in....I've had it happen where I created tables and nothing, but I kept trying and they got added eventually.  Sorry if the whole 'Keep on, keepin on' isn't all that helpful,  :?

Here's another way.  Log in, click on MySQL databases, scroll to the bottom and click on phpMyAdmin.  Then once logged in there, click on Databases link in the right frame.  Click on the link of your database.  You should get a listing of all tables in there.  Now click on the SQL tab.  This is just another way to get to that page w/o it popping up.  Either paste the .sql contents in the field like TranzNDance suggested, or upload the provided sql file.  See if it'll take that way and keep up posted :thumb:


Sorry, for some reason, I can't keep this topic watched...anyway, if you're still having trouble, try the above.  I have noticed from time to time that I'll click go and nothing happens, or something happens, but I don't see my new tables.
Title: How To: Add tables to your existing Database
Post by: Matt2005 on February 23, 2005, 06:38:15 AM
I'm trying to install phpList, but I can't find the config.php file (or anything like it) in my download (from the official phpList site) - what can I do?

Many thanks.
Title: How To: Add tables to your existing Database
Post by: TranzNDance on February 23, 2005, 10:18:31 AM
It might be one of the files that gets created by the script once you install it. Have you gone through installation?
Title: How To: Add tables to your existing Database
Post by: Matt2005 on February 23, 2005, 10:51:10 AM
Can I still do this, even though I don't have any mySQL db's left (only had 1 originally)?  :oops:
Title: How To: Add tables to your existing Database
Post by: TranzNDance on February 23, 2005, 10:54:58 AM
If you are installing manually, yes, you can install using the database you are using. To make it easiest, look for the config file of the current application using the database. You can get the database name/username/password and use it for installing phplist.
Title: Re: How To: Add tables to your existing Database
Post by: bright on August 25, 2005, 05:17:53 AM
Absolutely wonderful tutorial! Thanks Chelle! Was really confused as how to import the sql commands for phpnuke until I saw this. Thanks for taking the time. phpnuke is telling me to "Begone" when I try to login unfortunately but I'm sure somebody will know the answer to that when I post it as a new topic.
Title: Re: How To: Add tables to your existing Database
Post by: Chelle on August 25, 2005, 05:25:21 AM
Well I'm glad this walked you through the manual install.  Hope you get your 'Begone' sorted.
Title: Re: How To: Add tables to your existing Database
Post by: bfarber on September 25, 2005, 05:14:28 PM
I have added and altered tables but how do I perform the following from cpanel: 

UPDATE phpbb_auth_access SET auth_cal = auth_sticky;
Title: Re: How To: Add tables to your existing Database
Post by: Chelle on November 29, 2007, 08:51:14 AM
Answering just in case someone that reads through this and needs to know, you execute commands like that via phpMyAdmin

When you access your database, you'll see a tab that says SQL, simply paste that into the box and hit enter.  If you're syntax is correct, it'll run the query.