Horje
database dump mysql command Code Example
mysql dump mysql db cli 
#note by specifying -p flag without a password it'll prompt you for pass

DUMP:
mysqldump -u username -p dbname --lock-tables=false > filename.sql

Import:
mysql -u username -p dbname < filename.sql

Import external:
mysql -h host -u username -p dbname < filename.sql
database dump mysql command 
mysqldump -u username -p dbname > filename.sql
database dump mysql command 
mysqldump -h <hostname> -u <username> -p <database_name> > file-dump.sql



Sql

Related
mysql trim whitespace Code Example mysql trim whitespace Code Example
mysql slave status Code Example mysql slave status Code Example
t sql get foreign key Code Example t sql get foreign key Code Example
how to drop a database in sql server when it is in use Code Example how to drop a database in sql server when it is in use Code Example
su: Authentication failure mysql Code Example su: Authentication failure mysql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje