Find the answer to your Linux question:
Results 1 to 2 of 2
I already installed mysql server and mysql-administrator under both linux and windows.I entered data into DB under windows, now I want restore it into the DB under linux. I use ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. 06-02-2005 #1
    michelew
    michelew is offline
    Just Joined!
    Join Date
    Jun 2005
    Posts
    1

    How to restore data into mysql under linux?

    I already installed mysql server and mysql-administrator under both linux and windows.I entered data into DB under windows, now I want restore it into the DB under linux. I use mysql-administrator to do all the operations.
    But when I restore, I hit this error:
    The server has returned this error message:No database selected

    Then I try to create new schema in mysql under linux, but hit this error:
    Could not execute query 'CREATE DATABASE s;'.
    Error executing SQL command.

    At the same time, the terminal show this error:
    Gtk-WARNING **: Ignoring the separator setting

    wondering what's the pbm to make all these happen?
    Reply With Quote Reply With Quote
  2. 06-02-2005 #2
    miceng
    miceng is offline
    Just Joined!
    Join Date
    May 2005
    Posts
    18
    Try this from the command prompt

    To restore the database run:

    Code:
    mysql -u user -p dbname < &#123;path&#125;/backup.sql
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules