Recover Database From MySQL Dump File?

CarlosinFL · #1 (**permalink**) 10-07-11, 10:32

I've got a database I needed to move from one server to another. I performed what I think is a successful dump into a text file however I don't know and can't find the process on how to upload the file into the new server so I can recover the data. I've created the database on the new server:

Code:

CREATE DATABASE finance;
Query OK, 1 row affected (0.00 sec)

Now I've copied the MySQL dump file to the server but don't know how I would execute the command to reload this into my newly created database 'finance'.

CarlosinFL · #2 (**permalink**) 10-07-11, 11:01

Code:

    mysql -p finance < dumpfile.sql

Internet Services

Web Development

Digital Marketing

Consumer Tech