How to export each tables from a database into a separate files using mysqldump command

-

How to export each tables from a database into separate files using mysqldump command. Create a script file, and put the below content into it.


  #!/bin/bash 
  T_PATH=Downloads/tables_templates
  for TB in `mysql -u root -proot -N -B -e 'show tables from drupal'`;
  do
  echo "Backing up $TB"
  mysqldump --add-drop-table --add-locks --complete-insert -u root -proot drupal $TB > $T_PATH/template_$TB.sql

Where T_PATH is location of the file where script will export the table. and TB is a reference to the current value of show tables command.

Comments

Post a Comment

There is comment posted on your blog, chandu7929@blogpost.com

Popular posts from this blog

How to setup Drupal 8 Multisite on nginx webserver with different domain.

-
How to setup Drupal 8 Multi site on nginx web server with different domain. In this example we are going to use three different domain for our drupal-8 multi site ex: drupal-main.com, drupal-first.com, drupal-second.com Here drupal-main.com will be main site pointing to our drupal-8 installation, while two others will be pointing directory site1 and site2 respectively. Directory structure will be as follows: var/www/drupal-main.com/public - will contain drupal-8 installation var/www/drupal-main.com/public/sites/site1 var/www/drupal-main.com/public/sites/site2 Create above directory structure on your server. Now create a copy of sites/default/default.settings.php to sites/default/settings.php and also make a copy of example.sites.php to sites.php available in sites folder and put the following site alias at the end of file: $sites['drupal-first.com'] = 'site1'; $sites['drupal-second.com'] = 'site2'; After that also m...
Read more

Install drush globally using composer on WSL

-
With reference to my previous post, Setup development environment for Drupal on windows 10 , I noticed that installing drush on WSL using composer doest work by default, in this post I am going to demonstrate how to install drush globally using composer on WSL. I am assuming you have composer install, in order to install drush we have to follow below mentioned steps: $ composer global require drush/drush Now check drush installed path by running: $ composer config --global home This will print path for drush currently install i.e. /home/my-user-name/.config/composer , now we have to set this in PAHT so that drush command can be run from anywhere, using command replace my-user-name with your own: $ echo 'export PATH="/home/my-user-name/.config/composer/vendor/bin:$PATH"' >> ~/.bashrc $ source ~/.bashrc Now check that drush command is working by running $ drush
Read more

Drupal views create exposed filter programmatically

-
Lets assume there is requirement where we need to create a views exposed filter that will filter node content for the selected year. Here I am going to create a module with name custom_views_filter for demonstration Create custom_views_filter.module file and add below code /** * Implements hook_views_data_alter(). */ function custom_views_filter_views_data_alter(array &$data) { $data['node']['year_filter'] = [ 'title' => t('Year'), 'filter' => [ 'title' => t('Year'), 'help' => t('Provides a custom filter for nodes to search yearly.'), 'id' => 'year_views_filter', ], ]; } This will register filter with views plugin, now create views plugin filter. Create folder Plugin/view/filter under src folder and add file with name ContentYearViewsFilter.php , then add below code: ...
Read more