Different ways to import and export the Mysql database.
1) Using command Line:
c:\xampp\mysql\bin
mysqldump -u [username] -p [databasename] > [FileName].sql
databasename – name of the database to be exported.
FileName – Name of the SQL file you want to save. Also, you can add path in FileName as D:coverpoint.sql
mysql -u [username] -p [databasename] < [FileName].sql
databasename – name of the database to which you want to import.
FileName – Name of the SQL file you want to import. Also, you can add path in FileName as D: coverpoint.sql
(Click on the images to enlarge it.)
2) phpMyAdmin:
phpMyAdmin is a free and open source and cross platform tool for the administration of MySQL or MariaDB via a web browser. It is built with PHP, XHTML, CSS, and JavaScript. It is a browser-based administration tool hence, users can access it very easily on any browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields, and rows as well as executing SQL statements or managing users and permissions. Here, we will be learning about Importing and Exporting database of phpMyAdmin.
For Import:
When the database has been imported successfully, you should see the message “Import has been successfully finished, 16 queries executed. (coverpoint.sql)” (Figure 7).
For Export:
(Click on the images to enlarge it.)
Season after season, RCB fans await the start of the tournament with renewed vigor hoping their team will finally lift…
Are some of these cricketers really worth that amount? If not, why did the teams blow their purses on some…
The Melebourne Cricket Ground! The biggest cricketing hub of the globe was on its feet to host the very big…
Author: Adarsh Nim Pep Guardiola has done wonders at Barcelona following the Johan Cruyff philosophy of football, and the same…
Author: Adarsh Nim After Mikel Arteta's take over as new Arsenal boss in December 2019, Arsenal are looking like a…
Virat Kohli's use of cuss word in Hindi has led to some boisterously merry on social media. Virat Kohli's use…
This website uses cookies.