website: http://www.memororis.com/efiction/ * http://www.tokiohotelfiktio.net/
I tried to look for similar problems, but I couldn't find any. :/ I think I know where I might have gone wrong as I'm absolutely clueless as to how I'm supposed to take the memororis.com archive and move it to tokiohotelfiktio.net. I installed the eFiction to the new database already; before trying to move the old one's data; is that where I've gone wrong?
Since now that I try to import the data from the memororis.cm archive, the phpAdmin says:
"Error
SQL-kysely:
--
-- Database: `tokiohot_efiction`
--
CREATE DATABASE `tokiohot_efiction` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL reports: Directions
#1007 - Can't create database 'tokiohot_efiction'; database exists "
and I'm getting different errors after I've deleted the efiction from the new place and deleted both of the databases I'd tried the moving to. 0_o
Both of the websites have the same host, I don't know if that has any importance.
... Could some please help me by telling me how to do this whole thing from the beginning? Or guide me to a similar answer if there is one somewhere? This is too difficult :/
I'd really really appreciate it 🙂
That's because a database with this name (tociohot_efiction) already exists on the new host. Go to the old database and export only the tables in it, but not the database itself. Then login to the new host, select the new database and import the tables there. This should work.
When I tried that or importing the whole thing it keeps saying I don't have access to the database at the old adress with the new one. :Z I don't understand. 😀
Error
SQL query:
--
-- Tietokanta: `csxkwzob_efictionth`
--
CREATE DATABASE `csxkwzob_efictionth` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL said: Documentation
#1044 - Access denied for user 'tokiohot'@'localhost' to database 'csxkwzob_efictionth'
0__O
Are these two databases on the same host with the same name? I don't think you can do that because your sql server is usually just one big server and if you had a database on your old site, it won't let you create one with the same name on your new site because it's already going to be there.
You'll have to create a new database with a different name and import just the tables individually, or you can change the line in the SQL file with a different name.
Also make sure you add the appropriate users to your new database or they won't work. That looks like what might have happened above.
I got the same problem. Trying to move an archive from a free host to a paid one.
Erro
consulta SQL:
-- phpMyAdmin SQL Dump
-- version 2.6.4-pl3
-- http://www.phpmyadmin.net
--
-- Servidor: fdb1.awardspace.com
-- Tempo de Geração: Mai 15, 2008 as 11:22 PM
-- Versão do Servidor: 4.1.18
-- Versão do PHP: 4.4.1
--
-- Banco de Dados: `ssdfanfiction_e1`
--
CREATE DATABASE `ssdfanfiction_e1` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Mensagens do MySQL : Documentação
#1044 - Access denied for user 'axiaforu'@'localhost' to database 'ssdfanfiction_e1'
Any ideas?
Tanko, did you change your username and/or password on the new server? Chances are, it's not the same as your old...
You probably need to create the database via your host's control panel, then delete that create database statement from your database dump and try running it. Most hosts don't give phpmyadmin rights to create databases.
I don't know how, but my host sorted it out. They moved it for me and helped me with the database rights problems etc. So it's sorted, but I have no idea how. 🙂
Thank you everyone for your help! 🙂
