maxalarie
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER