MySql imports

How to import and dump databases in MySQL (phpmyadmin)

Note: This page is intended for those who have more advanced requirements and knowledge of how to manage a database. If you are unsure of how this works, please contact support instead. By clicking the edit button for a database, you can get additional information and also access a web-based tool called phpMyAdmin: Start by logging into phpMyAdmin Here you enter the username and password database when you created it. After logging in you are met by the following view, which you can get ...

Import large sized sql dump through phpmyadmin

You are able to import the data from phpmyadmin to the databases upto 128 MB at a time. For more information on importing the data, please refer to this LINK (//servage.net/133761--How-to-import-and-dump-databases-in-MySQL-phpmyadmin) If you have a large sized database which needs to be imported, please use a SQL dump splitter and upload each part. You can split the database data into smaller segments of 125 MB and then import it using the phpmyadmin interface.

When I import my database it says that "it can not create the database INFORMATION_SCHEMA"

This is often because someone tried to export both the database and something called INFORMATION_SCHEMA (the latter should not) What you can do then is to edit SQL file with a text editor and remove the line and then try to import this SQL file : CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE` information_schema`;