CAll Us: USA +1 9176775553   Login

Mysql commands

How to connect to Database for any user through Server

# mysql -u DBNAME -p DBPASS

command for taking  mysql backup:=>

#mysqldump databasename > file.sql

command for restoring : =>

# mysql -u [username] -p[password] [database] < [backup_file]

or

#mysql database name < file.sql

Leave a Reply