Labels

MySQL

Action Command
EXPORT DATABASE mysqldump -u root -p database_name > path/to/directory/sql_dump.sql

// Linux example, with added date in the file.
mysqldump -u root -p database_name > path/to/directory/sql_dump_`date +"%Y_%m_%d_%H%M%S"`.sql
IMPORT DATABASE // Enter MySQL shell using below command.
mysql -u root -p
// Now, first select your database and then import using use and source command respectively.
use database_name
source path/to/your/sql_dump.sql

// Or, direct way of importing.
mysql -u root -p database_name < path/to/your/sql_dump.sql

// Example in Windows.
C:\wamp\bin\mysql\mysql5.5.8\bin> mysql -u root -p db_name <c:\db_file.sql
IMPORT DATABASE [Multiple SQL] Importing multiple SQL files in a single database, could be achieved by merging all SQL files in to single SQL file and then importing the merged SQL.

// Merging in WINDOWS.
copy /b *.sql merged_sql_dump.sql

// Merging in LINUX.
cat *.sql > merged_sql_dump.sql

// Now, you can import using method specified in IMPORT DATABASE section. Example.
source path/to/your/merged_sql_dump.sql
Labels:

Comments

Post a Comment

Drupal Contribution
Miscellaneous
Git Commands
Tools
RESTful Services
Module
Lando Commands
Tools
Docker Commands
Tools
MySQL
Database
Database Quick Code
Database
Drush Commands
Tools
Drupal Console
Tools
PHP Quick Code
Module
Drupal Quick Code
Module
Composer Commands
Tools
Linux Commands
Environment
Linux Shell Scripting
Environment
Drupal Hooks
Module
Twig Tricks
Theme
PHPUnit Test
Module
PhpMyAdmin
Database
Drupal Constants
Module
CSS Clues
Theme
BLT Commands
Tools
Vagrant Commands
Tools
Localhost
127.0.0.1
Environment
Drupal Interview
Miscellaneous
Drupal Certifications
Miscellaneous
Concept & Definitions
Miscellaneous
Mac Tips
Miscellaneous
Windows Tips
Miscellaneous
Browser Tips
Miscellaneous

Best Practice

Use 'elseif' instead of 'else if'
#CodingTips

As of PHP 5.4 you can also use the short array syntax, which replaces array() with []
#CodingTips

Functions in general shall be named using snake_case(say, my_function()), and using camelCase(say, myFunction()) when declared within a plugin class
#CodingTips

Variables in general shall be named using snake_case(say, $my_variable), and using camelCase(say, $myVariable) when declared within a plugin class
#CodingTips

Manage automatically assigning of new permissions whenever a module is enabled here- admin/config/people/accounts
#ConfigurationTips

Manage source of Main-menu and User-menu links here- admin/structure/menu/settings
#ConfigurationTips

Helper function(s) shall be named prefixing an underscore(say, _my_helper_function()), which can prevent hooks from being called
#CodingTips

Ideally, configuring of 'Private file system path' at admin/config/media/file-system should be located outside of your Drupal root folder(say, ../my_private_files)
#ConfigurationTips

You should be aware that uploading files as 'Private file' will slow down the process of loading the files as Drupal has to be bootstrapped for every file that needs to be downloaded
#ConfigurationTips #BeAware

Code should always be pushed up(dev -> staging -> production) and databases should only be pushed down(production -> staging -> dev)
#DevelopmentTips

Get Raw SQL Query of drupal dynamic queries before executing it using $query->__toString();
#DebugTips

In VI-Editor, Press ESC key to come in command mode and for undo type :U and for redo type :Ctrl+R
#LinuxTips

Insert queries must always use a query builder object(layer of abstraction), allowing individual database drivers special handling for column values (if applicable), example case for LOB and BLOB fields.
#DatabaseQueryTips

Drupal uses the .inc extension to prevent files from being executed directly.
#DevelopmentTips

Popular Posts