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
Author Widget
Advertisement
Latest Blog
Categories
- aws
- Basic Linux
- Blogger
- Computer
- cPanel
- DDOS
- Drupal
- Economy
- Email Marketing Series
- Email problems
- Entertainment
- Error and solution
- Fashion
- Featured
- Food
- ftp issues
- How to
- htaccess
- Installation
- Joomla
- Knowledge
- Linux Commands
- magento
- ModSecurity
- mysql
- Nature
- Network
- PHP
- Plesk
- Questions And Answers
- ruby and rails
- security
- Shell Programming and Scripting
- Sports
- Technology
- Tomcat
- Travel
- Uncategorized
- Wordpress