By: Piyush Gupta

Piyush Gupta — Fri, 09 Jul 2010 08:31:12 +0000

Reverse thing to load the dump to DB .

Open command line

Type below to get into mysql via command line
>> mysql -u root -p password ;
[Password is the actual mysql password]

then to check databases
>> show databases ;

Note down the database .

for mysql db dump , exit mysql

>> mysql -u root -p database < /path/to/database.sql

[Replace database with actual database name]

Piyush Gupta — Mon, 05 Jul 2010 12:08:46 +0000

Open command line

Type below to get into mysql via command line
>> mysql -u root -p password ;
[Password is the actual mysql password]

then to check databases
>> show databases ;

Note down the database .

for mysql db dump , exit mysql

>> mysqldump -u root -p database > database.sql

[Replace database with actual database name]

Comments on: “Simple MYSQL commands”