Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Transfering a Remote DB to another Remote Server

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 889 Views
  • Pixel
    Avatar
    Community Member
    78 Posts

    Transfering a Remote DB to another Remote Server Link to this post

    Hi, I am nearing completion of a website and need to move it from a test domain on one server to the actual domain on another server.
    I have transferred the httpdocs files over and now need to import the DB that I have been working on on the test domain.
    I create a new DB and user in the control panel and then import the sql file
    However, when I import it I keep getting this error

    #1007 - Can't create database 'magazine'; database exists

    What am I doing wrong?

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Transfering a Remote DB to another Remote Server Link to this post

    Is it possible to import the SQL without creating a new DB then?

    Second question: Does your host have phpMyAdmin installed?

  • Pixel
    Avatar
    Community Member
    78 Posts

    Re: Transfering a Remote DB to another Remote Server Link to this post

    Im using Plesk 8.4.0 and you need to create a new DB and a user before you can get onto phpMyAdmin

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Transfering a Remote DB to another Remote Server Link to this post

    Alright. So where did you export the existing database from, and how?

  • Pixel
    Avatar
    Community Member
    78 Posts

    Re: Transfering a Remote DB to another Remote Server Link to this post

    From another server using Plesk 8.2.0, opened phpMyAdmin and did a straight-up export of the DB as an SQL with no compression.

    Ive just been playing with importing the DB and I just got a error

    #1044 - Access denied for user 'pandp'@'%' to database 'magazine'

    This is my first SS site that I am putting live and I am not great with Dbs and php so im a bit of a noob atm.
    I have another site on a test server which i will have to do the same in the near future

  • Pixel
    Avatar
    Community Member
    78 Posts

    Re: Transfering a Remote DB to another Remote Server Link to this post

    Ok I set up the database and user exactly the same on both domains and exported just the tables of the test DB and imported them to the live site DB with success.
    However, I am now getting a 403 Access forbidden! error so I shall now need to sort that out

    889 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.