Textpattern CMS

#1 2006-05-21 21:38:06

puthupa

Member

From: ny

Registered: 2004-10-07

Posts: 27

Website

mysql errors when moving servers

ok – the wiki is lacking a tad on the ‘Moving Installation from one Host to Another’ page, specifically

Step 2: Installing Your Resources on the New Web Hosts Servers
Creating New Database, Uploading Folder/File Tree, and Editing config.php File
details needed

i know nothing about mysql, aside from whatever is necessary to create stuff for txp installs. what i’ve done so far is exported mysql stuff from my old host, as per Step 1. i waited until the DNS propagated before trying to do anything with mysql. i have successfully created a new database, and not having any further idea on how to proceed, took a suggestion from these forums to do a fresh txp install, and then import my old db and edit a path in the txp preferences. i’m not having any success, so i’m fine with either learning whatever is missing in Step 2 or figuring out how to insert my old db data into a new db.

when i try to either import the whole old db or just part of it (i guess each part is called ‘table’). i get this error

Error

SQL query:

— phpMyAdmin SQL Dump
— version 2.6.4-pl3
— http://www.phpmyadmin.net
—
— Host: db202.perfora.net
— Generation Time: May 14, 2006 at 09:13 PM
— Server version: 4.0.25
— PHP Version: 4.3.10-2
—
— Database: `db131679680`
—
CREATE DATABASE `db131679680` ;

MySQL said: Documentation

1044. - Access denied for user ‘secretusername’@‘64.111.96.0/255.255.224.0’ to database ‘db131679680’
      <br />

the host listed is my old host – do i need to change that to my new host? and the database name is different as well – must that also be changed in the export document? any direction here would be most appreciated as this is the first time i am trying to move an installation from one server to another. thank you.

---

arp laszlo
www.inkwire.net

#2 2006-05-21 22:48:35

zem

Developer Emeritus

From: Melbourne, Australia

Registered: 2004-04-08

Posts: 2,579

Re: mysql errors when moving servers

Whatever program you’re using to import the data (mysql command line or phpMyAdmin) requires that you specify the correct hostname, username and password for the destination database.

The error message is telling you that some or all of those things are incorrect.

---

Alex

#3 2006-05-22 00:43:19

puthupa

Member

From: ny

Registered: 2004-10-07

Posts: 27

Website

Re: mysql errors when moving servers

the database has already been created – i tried adjusting the hostname & database names and got this:

Error

SQL query:

— phpMyAdmin SQL Dump
— version 2.6.4-pl3
— http://www.phpmyadmin.net
—
— Host: db202.perfora.net
— Generation Time: May 14, 2006 at 09:13 PM
— Server version: 4.0.25
— PHP Version: 4.3.10-2
—
— Database: `laszlolove`
—
CREATE DATABASE `laszlolove` ;

MySQL said: Documentation

1007. - Can’t create database ‘laszlolove’; database exists <br /><br />

all i want to do import the exported stuff into the new db. lemme find the thread where i got this suggestion to begin with, perhaps that person can help. otherwise, is there any resource that someone has made that outlines how to move installations between servers without skipping some of the major details?

---

arp laszlo
www.inkwire.net

#4 2006-05-22 14:54:31

els

Moderator

From: The Netherlands

Registered: 2004-06-06

Posts: 7,458

Re: mysql errors when moving servers

I replied here.

#5 2006-05-22 21:42:48

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: mysql errors when moving servers

Closing this topic, we don’t need two. :)