Link to home
Start Free TrialLog in
Avatar of maxalarie
maxalarieFlag for Canada

asked on

Import MySQL database Newbir Question

Good day,

I run a mysql server on Linux.

I have a mysql database dumpfile on a  prodserver . I would like to create a NEW DB on the same server and import this backup into it..  

I have logged in, and created a database like this:

Mysql> create database testmax;
Query OK, 1 row affected (0.06 sec)
mysql> use testmax;
Database changed
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| phpmyadmin         |
| procorp            |
| testmax            |
+--------------------+

(I want to import  procorp's backup in testmax)

Now, I am at the part where i want  to populate this testmax  database with my existing  procorp backup. I also want to make sure i dont overwrite the procorp database (production database)

How do I do that?

I know in Oracle you can set ORACLE_SID but im not familiar with mysql.
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of maxalarie

ASKER

Thanks guys,.