SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast mecha51's Avatar
    Join Date
    Dec 2008
    Location
    Raleigh, NC
    Posts
    75
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Trying to move Joomla site & having MySQL problem

    Hi. I have a VPS and built a Joomla site for a client on an IP I wasn't using. I eventually needed the IP for another site, and now I am attempting to move the Joomla install to another IP on the same VPS.

    I read up a bit, backed up all my files, & exported my Joomla db to an .sql file. Then I moved all the files to the new location. Everything is fine except the db. Using phpMyAdmin the only time I can see how to import a db is when I am in an existing db. So I create a db with the name of the Joomla one (abc). Then when I try to import the .sql file it says "db abc already exists".

    Is there a way to just import into an existing db without creating one?? I'm not seeing that option. And the only time I even get the import option is when I am inside an existing db. I'm very confused as to how this is supposed to work.

    Thanks in advance for any help.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    have a look at the .sql file -- it'll probably include a CREATE DATABASE statement, which you can simply edit out
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast mecha51's Avatar
    Join Date
    Dec 2008
    Location
    Raleigh, NC
    Posts
    75
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    have a look at the .sql file -- it'll probably include a CREATE DATABASE statement, which you can simply edit out
    That did the trick alright. Thanks a million!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •