–Dumping the Database –

You can dump the database in the server, in sql format using ‘mysqldump’

Syntax:

mysqldump -u root -p demo_db > dump.sql

Here ‘demo_db’ is the name of the database and dump.sql is the name we give for the sql file in which the data is to be dumped.

when once this command is executed, there will be a prompt for password and after giving the password, we can generate the dump.sql in the server.

Then we can download the dump.sql from the server using via ftp.

–Loading the Database –

Suppose, we have the database as dump.sql, locally, and we want to load it, we can use the following syntax from the command prompt

mysql -u root demo_db

eg: C:\Program Files\xampp\mysql\bin ——————————————————————— Jayapal