Exporting MySQL database from XAMPP [closed]

Question

I need to send my website with the MySQL database. I have done the website and MySQL database in XAMPP but don’t know how to send the database.

Answer 1

Exporting MySQL database from xampp

The command line :

1. First of all open command prompt
2. Syntax:-

Import Database :- D:/xampp/mysql/bin/mysql – u root -p databasename < D:/test.sql (sql file name)

Export Database :- D:/xampp/mysql/bin/mysqldump -u root -p databasename > D:/text.sql(sql file name)

Answer 2

You have 2 possible ways to do that

• by command line

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

• or use phpmyadmin (usually installed with XAMP), or something like that and export it from browser