mysqldump -u USERNAME -p DATABASE-NAME > test.sql
Tag Archives: Linux
Linux command to import a database – MySQL
mysql -u USERNAME -p -h localhost DATABSENAME < sql-file-name.sql
MySQL command to modify password – Linux
mysqladmin -u root -p password Newspassword
MySQL command to show list of tables – Linux
show tables;
MySQL command to show list of databases – Linux
show databases;
How to connect to MySQL Database server using command line
mysql -h localhost -u root -ppassword
Enabling Location/Address Bar in ubuntu
Goto Terminal and type the given command
#gconf-editor
You can see a new configuration window and may follow the instructions.
apps -> nautilus -> preferences
Right side you can see some options , just enable the second option [always_use_location_entry ]