IndianWebPortal.com

Something Different In Linux

Home » mysql » Mysql commands

Mysql commands

Posted by Rishikesh Vispute Categories: mysql

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


Popular Posts

remove index.php fro

How to remove index.php from url in magento Ans : If you ...

PHP-Java bridge on p

  What is php-java bridge? The php-java bridge is the php ...

Set expiration for y

If you want to set the expiration to your site ...

Warning: Parameter 1

Error: Warning: Parameter 1 to modMainMenuHelper::buildXML() expected to be a ...

domain pointing to e

If you domain uses external MX record and it is ...