vitess.io/vitess@v0.16.2/support/mysqldump/README.md (about)

     1  # Support for Mysqldump
     2  
     3  In order to export and import mysqldump through vtgate, unsupported queries and statements need to be stripped from the dump.  
     4  A 2-step process is advised. 
     5  1. Dump the schema only and import.
     6  2. Dump the data and import.
     7  
     8  ## Export and Import mysqldump into Vitess
     9  
    10  Define the variables then run the script
    11  ```
    12  vitess/support/mysqldump$ ./mysqldump.sh
    13  ```
    14  The script will output 2 files to enable debugging;  
    15  `schema.sql`  
    16  `data.sql`  
    17  The script will also attempt to import the schema and data into Vitess via vtgate.
    18  
    19  
    20  ## Notes
    21  1. This has been tested for small databases.  
    22  2. The script can be modified to include other unsupported statements that may be present.  
    23  3. The script has been tested with GNU sed, BSD sed users e.g. MacOS will need to update the script.