Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2007
    Posts
    143
    Plugin Contributions
    0

    Default Database problem with server move

    Hi,
    I have followed Wiki on moving to another host or a different server.

    I cannot called the database the same because of the hosts prefix ie, the old ones web20-woodyzen with no control over web20- and the new host anythin_woodyzen with no control over anythin_.

    I follow the guide but when I get to importing into the new database i get..

    Error

    SQL query:
    --
    -- Database: `web20-woodyzen`
    --
    CREATE DATABASE `web20-woodyzen` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;


    MySQL said:
    #1044 - Access denied for user 'anythin_woody'@'localhost' to database 'web20-woodyzen'

    I am lost can anyone help? I have searched the forums but can't find anything.

  2. #2
    Join Date
    Jan 2007
    Posts
    143
    Plugin Contributions
    0

    Default Re: Database problem with server move

    I tried opening the sql file and changing the database name web20-woodyzen to the new one anythin_woodyzen in 3 places, but just got errors or database already exists.

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Database problem with server move

    Try opening the sql and dropping the create database section as I assume that this DB is already created and if this is cPanel or similar you cannot create a DB with phpmyadmin or through sql as Db creation must be in the control panel
    Zen-Venom Get Bitten

  4. #4
    Join Date
    Jan 2007
    Posts
    143
    Plugin Contributions
    0

    Default Re: Database problem with server move

    Quote Originally Posted by kobra View Post
    Try opening the sql and dropping the create database section as I assume that this DB is already created and if this is cPanel or similar you cannot create a DB with phpmyadmin or through sql as Db creation must be in the control panel
    Excellent kobra that worked a treat.
    Thank you for your help and time it is very much appreciated.

 

 

Similar Threads

  1. Database problem, server move.
    By altzone in forum Installing on a Linux/Unix Server
    Replies: 1
    Last Post: 14 Jan 2011, 01:53 AM
  2. Problem with linkpoint after move to new server
    By kameleon in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 10 Jan 2011, 09:02 PM
  3. Database Move problem with un_wishlist
    By jabbawest in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 30 Aug 2010, 07:12 PM
  4. Server move - Problem with url and Server/Version Info - please help!
    By bethalicea in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 7 Jun 2009, 10:07 PM
  5. Problem with server move
    By jason8612 in forum Installing on a Linux/Unix Server
    Replies: 7
    Last Post: 21 Aug 2007, 04:10 AM

Posting Permissions

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