Web Hosting Forum | Lunarpages

Author Topic: How To: Add tables to your existing Database  (Read 25738 times)

Offline TranzNDance

  • Princess of Naboo
  • Berserker Poster
  • *****
  • Posts: 11607
    • Thu Tu's Blog
How To: Add tables to your existing Database
« Reply #30 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.
:whip: :love: :whip: :love: :whip: :love:

Offline draca

  • Pong! (the videogame) Master
  • *****
  • Posts: 26
    • http://www.draca.com
How To: Add tables to your existing Database
« Reply #31 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.
Oniisan is watching

www.pandahub.com
"you can't find a more useless place in cyberspace"

www.draca.com <--(yes this one is a real company)
"if we can't protect you, no one can"

Offline SunspotWendy

  • Trekkie
  • **
  • Posts: 17
How To: Add tables to your existing Database
« Reply #32 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.  :)
SUNSPOT - Arena Rock for Geeks from Madison, WI

Offline SunspotWendy

  • Trekkie
  • **
  • Posts: 17
How To: Add tables to your existing Database
« Reply #33 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?  :(
SUNSPOT - Arena Rock for Geeks from Madison, WI

Offline Chelle

  • Spaceship Captain
  • *****
  • Posts: 103
How To: Add tables to your existing Database
« Reply #34 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:
"The axe forgets.  The tree remembers" -African Proverb

Offline SunspotWendy

  • Trekkie
  • **
  • Posts: 17
How To: Add tables to your existing Database
« Reply #35 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!  :)
SUNSPOT - Arena Rock for Geeks from Madison, WI

Offline Chelle

  • Spaceship Captain
  • *****
  • Posts: 103
How To: Add tables to your existing Database
« Reply #36 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
"The axe forgets.  The tree remembers" -African Proverb

Offline h2-one

  • Intergalactic Cowboy
  • *****
  • Posts: 69
How To: Add tables to your existing Database
« Reply #37 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?

Offline JamesG

  • Web Designer UK
  • Berserker Poster
  • *****
  • Posts: 11732
  • Web Designer
    • Affordable Web Design
How To: Add tables to your existing Database
« Reply #38 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?

Offline h2-one

  • Intergalactic Cowboy
  • *****
  • Posts: 69
How To: Add tables to your existing Database
« Reply #39 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.

Offline h2-one

  • Intergalactic Cowboy
  • *****
  • Posts: 69
How To: Add tables to your existing Database
« Reply #40 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?

Offline JamesG

  • Web Designer UK
  • Berserker Poster
  • *****
  • Posts: 11732
  • Web Designer
    • Affordable Web Design
How To: Add tables to your existing Database
« Reply #41 on: October 27, 2004, 04:33:40 AM »
you will have to go into the mysql databse and remove the tables manually...

Offline rbweh

  • Spacescooter Operator
  • *****
  • Posts: 42
    • http://www.theidea.bz/
How To: Add tables to your existing Database
« Reply #42 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?

Offline Chelle

  • Spaceship Captain
  • *****
  • Posts: 103
How To: Add tables to your existing Database
« Reply #43 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.
"The axe forgets.  The tree remembers" -African Proverb

Offline Matt2005

  • Pong! (the videogame) Master
  • *****
  • Posts: 24
How To: Add tables to your existing Database
« Reply #44 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.

 

Share |