Back to Blog
![]() ![]() ![]() If you found this tutorial helpful then don't forget to share. With Command-Line you can also import SQL file in your MySQL database. The SQL file stored in xampp/mysql/bin/ folder if you have used the command line. You can either export your MySQL database using phpMyAdmin or Command-Line. Here, I am exporting country and userinfo tables from tutorial database, and and set export file name – tutorial.sql.A new SQL file will create in the xampp/mysql/bin/ folder.Įxample (Export multiple tables) – mysqldump -p -user=root webinar tutorial country userinfo > tutorial.sql.In this example, the database is named bitnamiwordpress. Select the application database in the left navigation menu. Enter the user password if you have defined otherwise press enter. Export a database with phpMyAdmin Follow these steps: Log in to the included phpMyAdmin application using these instructions.Here, I am exporting country table from tutorial database, and set export file name – tutorial.sql.> export-file-name.sqlĮxample (Export single table) – mysqldump -p -user=root webinar tutorial country > tutorial.sql Syntax – mysqldump -p -user= tablename1 tablename2. ![]() If you want to export specific tables instead of whole database then you can use below command – Here, I am exporting tutorial database and set export file name – tutorial.sql.Įnter the user password if you have defined otherwise press enter.Ī new SQL file will create in the xampp/mysql/bin/ folder. Syntax – mysqldump -u username -p database-name > export-file-name.sqlĭatabase-name – Database name which you want to export.Įxport-file-name.sql – Specify you export file name.Įxample – mysqldump -u root -p tutorial > tutorial.sql I am exporting tutorial database using Command-Line.In this tutorial, I am using XAMPP in windows. ![]()
0 Comments
Read More
Leave a Reply. |