how to import a database in phpmyadmin code example

Example 1: create database in mysql

The CREATE DATABASE statement is used to create a new SQL/MySQL database.

Syntax
CREATE DATABASE databasename;

CREATE DATABASE Example
The following SQL statement creates a database called "testDB":

Example
CREATE DATABASE testDB;

Example 2: Export / Import Large Database from MAMP using Terminal

/applications/MAMP/library/bin/mysql -u [USERNAME] -p [DATABASE_NAME] < [PATH_TO_SQL_FILE]

Tags:

Sql Example

Related