InfoHeap
Tech tutorials, tips, tools and more
Navigation
  • Home
  • Tutorials
    • CSS tutorials & examples
    • CSS properties
    • Javascript cookbook
    • Linux/Unix Command Line
    • Mac
    • PHP
      • PHP functions online
      • PHP regex
    • WordPress
  • Online Tools
    • Text utilities
    • Online Lint Tools
search

Mysql tutorials

  • Enable query log without restarting mysql on Linux
  • How to find mysql query rate on Linux
  • Mysql - display row count and size of tables
  • Mysql - get size of all databases
  • Mysql - get total queries since beginning
  • Mysql - how to copy a table
  • Mysql - how to enable query log
  • Mysql 5.7 root password after installation
  • Mysql difference between CURDATE() and NOW()
  • Mysql find current timezone offset
  • Mysql find slave lag
  • Mysql how to dump schema of all databases
  • Wordpress Mysql Queries
  • mysql - how to enable query logs
  • mysql find recently created-tables
 
  • Home
  • > Tutorials
  • > Mysql

Mysql – how to copy a table

By admin on Jan 7, 2016

Cloning table with indexes/triggers and data

  1. First create new table with same structure. We’ll use wordpress table wp_posts for the purpose of this tutorial.

    mysql> CREATE TABLE wp_posts_bak LIKE wp_posts;
    Query OK, 0 rows affected (0.00 sec)
    
  2. Now copy the data

    mysql> INSERT INTO wp_posts_bak SELECT * FROM wp_posts;
    Query OK, 2857 rows affected (0.49 sec)
    Records: 2857  Duplicates: 0  Warnings: 0
    

Cloning table without indexes/triggers (data only)

This is handy approach to take backup of a table when we don’t need indexes, etc.

mysql> CREATE TABLE wp_posts_bak2 AS (select * from wp_posts);
Query OK, 2857 rows affected (0.09 sec)
Records: 2857  Duplicates: 0  Warnings: 0

Suggested posts:

  1. How to delete orphan wordpress wp_postmeta rows
  2. WordPress mysql query to get all custom keys and values for a post
  3. WordPress mysql query to get all posts with a specific custom field
  4. WordPress mysql query to get all posts with a missing custom field
  5. Mysql – get size of all databases
  6. How to find mysql query rate on Linux
  7. Mysql – how to enable query log
  8. CSS automatic table row numbering
Share this article: share on facebook share on linkedin tweet this submit to reddit
Posted in Tutorials | Tagged Mysql, Tutorials

Follow InfoHeap

facebook
twitter
  • Browse site
  • Article Topics
  • Article archives
  • Recent Articles
  • Contact Us
  • Omoney
Popular Topics: AngularJS | Apache | AWS and EC2 | Bash shell scripting | Chrome developer tools | CSS | CSS cookbook | CSS properties | CSS Pseudo Classes | CSS selectors | CSS3 | CSS3 flexbox | Devops | Git | HTML | HTML5 | Java | Javascript | Javascript cookbook | Javascript DOM | jQuery | Linux | Linux/Unix Command Line | Mac | Mac Command Line | Mysql | Networking | Node.js | Online Tools | PHP | PHP cookbook | PHP Regex | Python | Python array | Python cookbook | SEO | Site Performance | SSH | Ubuntu Linux | Web Development | Webmaster | Wordpress | Wordpress customization | Wordpress How To | Wordpress Mysql Queries

Copyright © 2021 InfoHeap.

Powered by WordPress