over 5 years ago
Here we will learn how to restore the database from a backup using mysql commands
we need to follow the following steps for the process
Lets say we have a dump for a database name test.sql
and we have a database test in the MYSQL Workbench or SQLyog.
Now we will use the following mysql command to restore our test.sql file to the test database.
$ mysql -u root -p test <test.sql
$ mysql -u root -p test < /var/www/html/myfolder/test.sql
Restoring the database from a compressed dump file we use the following command and we must have a database in the targeted machine for which we are restoring:
gunzip < [test.sql.gz] | mysql -u [uname] -p[pass] [dbname]
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using