View original (French)

Import my new database into mysql 1&1

Solved
furf Posted messages 3 Status Member -  
 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 answers

  1.
    furf Posted messages 3 Status Member 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
    1. furf Posted messages 3 Status Member 2
       
      It was indeed a compatibility issue between the two MySQL. So I chose compatible when exporting.
      0
  2. 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
  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