XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Help to import database
Register
1
hipoonios
Help to import database

  • 2010/3/7 16:31

  • hipoonios

  • Friend of XOOPS

  • Posts: 298

  • Since: 2005/9/24


Here comes a noob question.

I'm moving one of my sites to a new host. But I having problems to import the database (using phpmyadmin).

The problem is: The host have already created a database. But I can't import it because there is already
a database with the same name. (see pic below).

Resized Image


I have also tried to rename the database and tried to import it again. But then i got a permission error. This because
the host only let me have 1 database:

Resized Image


So any sugesstions? Is there is a way to just import the tables from the database?
2
Mamba
Re: Help to import database

  • 2010/3/7 17:54

  • Mamba

  • Moderator

  • Posts: 11412

  • Since: 2004/4/23


1) You can import tables via SQL to you existing database (assuming that it's empty)

2) You can change your Host, so you have more than only one database allowed
3
ghia
Re: Help to import database

  • 2010/3/7 21:45

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Quote:
1) You can import tables via SQL to you existing database (assuming that it's empty)
No, the only requirement is that the tables have a different name. This can be easily obtained by having the 'right' prefix.

Your backup file probably has at the start a statement to create the database. You can edit the file and comment it out. That way the tables will be added to your existing database.
4
hipoonios
Re: Help to import database

  • 2010/3/14 10:51

  • hipoonios

  • Friend of XOOPS

  • Posts: 298

  • Since: 2005/9/24


Thanks, guys. It worked for me to select just the tables and export it to a sql file.
5
terrion
Re: Help to import database

  • 2010/3/18 2:29

  • terrion

  • Friend of XOOPS

  • Posts: 300

  • Since: 2004/9/19


Use a host that allows you to have control over your own databases.

http://www.UltranetDomains.com comes to mind.

6
terrion
Re: Help to import database

  • Yesterday 5:02

  • terrion

  • Friend of XOOPS

  • Posts: 300

  • Since: 2004/9/19


Happy holidays,

Just dropping a note that if anyone comes looking for me I can be found over that https://ultranet.domains. Still the same great hosting company, just ditched the .com.

Been a minute since I dropped in on the Xoops crowd. Looks nice over here.

Cheers!
--Terrion

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

138 user(s) are online (116 user(s) are browsing Support Forums)

Members: 0

Guests: 138

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Dec 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits