Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » problem with import database
 
Thread actions
Print this page
  • Print all pages

    • problem with import database

    Posted by sergrlager posts: 124 Russian Federation

    i tried import database to another hosting, i use documentation tiki to do export correctly and i had an error when i try to import database:
    here a printscrin:

    Снимок1.png (12.39 Kb)
    Reads: 1535
    Posted by sergrlager posts: 124 Russian Federation
    have anybody ideas?

    Posted by Tom Jarvis posts: 215

    You have to create the database and a user before you import. If you have already created the database and have a user defined, then you can fix the problem by either:
    1) Selecting the database before selecting the import option in phpmyadmin. The phpmyadmin heading has to be something like "localhost databasename", you have to do this so it knows which database to import the data into.
    or
    2) Edit the text of the mysql dump and add the following line before any other mysql statements:

    Copy to clipboard
    USE databasename;

    That line will tell mysql which database to import the data into.


    Posted by sergrlager posts: 124 Russian Federation

    the database on my hosting is "information_schema"
    i add to dump file this line
    USE information_schema;

    and have this error when i tried to import it:

    1. 1109 - Unknown table 'messu_archive' in information_schema

    Posted by Tom Jarvis posts: 215
    You should not be using information_schema, that database is for use by MySQL. You need to create a new database and a database user. Check out Rick's TikiForSmarties.com, it describes how to create the database and the database user here: Creating the Database.