How to restore a database through mysql command ?

 

         If you want to restore a database, you have to follow these steps.

         1) Use ftp to upload the file

         2) Login to the server, and cd to the directory that you have uploaded.

         3) Execute the command.

             mysql -u usernaem -p password databasename < databasename.sql

             where username is the mysql username

                      password is the mysql user password

                      databasename is the name of the database to be restored.

                      databasename.sql is the dump file or the backup file.

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to generate an SSH key in linux?

        To generate an ssh key in linux you have to execute the command...

How to install ClamAV antivirus from a source code?

    Download the clamAV source from http://www.clamav.net.The latest version is...

Steps to install BFD(Brute Force Detection). using source code

  BFD Brute Force Detection is a modular shell script for parsing applicable logs and...

How to backup a data base in linux through mysql command ?

       If you want to take the backup of a database, follow these steps...

What are dns records?

       DNS records or zone files are used for mapping urls to an ip,...