Linux MySQL Commands

 

  1.      Log into mysql 
mysql -u root -p
  1. Import database as root user 
mysql -u root -p mydatabase < backup.sql
  1. Import database as non root user 
mysql -u myuser -p mydatabase < backup.sql
  1. Check tables 
USE mydatabase;<br>SHOW TABLES;
  1. Delete all tables one by one 
SET FOREIGN_KEY_CHECKS = 0;<br>DROP TABLE IF EXISTS <code>table1, table2, table3, ...;
SET FOREIGN_KEY_CHECKS = 1;</code>

Take Backup of Database

mysqldump -u root -p mydatabase > mydatabase_backup.sql

Comments

Post a Comment

Popular posts from this blog

How to create dynamic HTML sitemap in WordPress with a shortcode (and exclude post types)

 An HTML sitemap is a simple way to display all your website’s content in one place. It helps visitors and search engines quickly navigate your site’s structure. In this tutorial, we’ll show you how to create a WordPress shortcode that generates an HTML sitemap displaying Pages , Posts , and Custom Post Types (CPTs) – with an option to exclude certain post types you don’t want to display. By the end, you’ll have a clean, dynamic sitemap you can insert anywhere using [html_sitemap exclude=”product,portfolio”] . Here’s an example: Pages - Home - About Us - Contact Blog Posts - How to Build a WordPress Site - Top 10 SEO Tips Products - Product A - Product B Add this code to your theme’s functions.php file or in a custom plugin: // [html_sitemap] shortcode with dynamic exclude option function generate_html_sitemap($atts) { // Parse shortcode attributes $atts = shortcode_atts(array( 'exclude' => '', // Default: no exclusions ), $atts, ...
Read more

How to add a GST number field to WooCommerce checkout and order emails

 If you’re running a WooCommerce store in India or working with B2B clients, you may need to collect GST numbers during checkout. In this tutorial, you’ll learn how to add an optional GST number field on the WooCommerce checkout page, save it with the order , and display it in the admin panel as well as in the order confirmation emails . Step 1: Add GST Number Field to Checkout Page Use the following code in your theme functions.php file to add a new optional field for the GST number just below the billing fields. // Add GST Number field to checkout add_action('woocommerce_after_checkout_billing_form', 'add_gst_field_to_checkout'); function add_gst_field_to_checkout($checkout) { echo '<div id="gst_number_field"><h3>' . __('GST Number (Optional)') . '</h3>'; woocommerce_form_field('gst_number', array( 'type' => 'text', 'class' => array(...
Read more

5 websites to get icons completely free

 As a web and application developer I need icons on my every project. Icons are copyrighted assets like images. I prefer to use kind of public domain graphics which are completely free for commercial purposes. From where we can get completely free icons for web and graphic design?  Here are the 5 best websites to get icons for your graphic design projects. Fontello   This is my 1st choice because of its large collection of fonts and customization options. At fontello you can get icons as a web fonts which is really great for web developers. They offer API for developers to integrate their application on any other web / mobile application. URL: www.fontello.com | Plan: Free Icomoon   Icomoon is another great resource for this with web fonts. You can generate SVG for each icon too. You can download lots of icons in different vector formats completely free. URL: www.icomoon.io | Plan: Free + Paid Iconmonstr {#a700.wp-block-heading} This websi...
Read more