View original (French)

Import my new database into mysql 1&1

Solved
furf Posted messages 3 Status Membre -  
 Gariig -
Hello everyone,

I temporarily hosted my site with the free host olympe-network. Now that I have purchased my domain name, I would like to transfer my database to https://phpmyadmin.1and1.fr/. I have exported my database from http://phpmyadmin.olympe-network.com/ via the export tab. Now, I want to import this database into https://phpmyadmin.1and1.fr/, but there is no import tab. What should I do??

Thank you in advance

There is only one truth, and that is gliding
Configuration: Windows XP Firefox 2.0.0.14

3 réponses

Réponse 1 / 3
furf Posted messages 3 Status Membre 2
 
Hello again,

I think I found out how to do it. I exported it in gzipped format, and in https://phpmyadmin.1and1.fr/, I went through the SQL tab.

But when I execute it, I get this error message:

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.11.6-rc1
-- https://www.phpmyadmin.net/
--
-- Server: sql.olympe-network.com
-- Generated on: Sun Jun 15 2008 at 18:27
-- Server version: 5.0.32
-- PHP version: 5.2.0-8+etch11
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"

MySQL responded:Documentation
#1193 - Unknown system variable 'SQL_MODE'

Has this happened to anyone before? Maybe I didn't check the right options when exporting??

Thank you in advance
2
furf Posted messages 3 Status Membre 2
 
It was indeed a compatibility issue between the two MySQL. So I chose compatible when exporting.
0
Réponse 2 / 3
Gariig
 
I am encountering the same problem. I cannot import an SQL file into the phpMyAdmin of 1and1.

I have the same error as you.

How did you solve this compatibility issue at the time of export?

Thank you for your help.
2
Réponse 3 / 3
eddy
 
Hi,
Just wanted to say thank you, because I had no idea how to do it and 1&1 doesn’t seem to want to respond to my request!
Thanks again
ed
0