Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Question Unanswered: [RESOLVED]Recover Database From MySQL Dump File?

    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'.
    Last edited by CacheDrive; 10-07-11 at 12:00. Reason: Resolved

  2. #2
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Code:
        mysql -p finance < dumpfile.sql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •