Download the PHP package firevel/mysql-to-spanner without Composer
On this page you can find all versions of the php package firevel/mysql-to-spanner. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download firevel/mysql-to-spanner
More information about firevel/mysql-to-spanner
Files in firevel/mysql-to-spanner
Download firevel/mysql-to-spanner
More information about firevel/mysql-to-spanner
Files in firevel/mysql-to-spanner
Vendor firevel
Package mysql-to-spanner
Short Description Laravel tool to convert MySQL schemas to Cloud Spanner Data Definition Language (DDL)
License MIT
Package mysql-to-spanner
Short Description Laravel tool to convert MySQL schemas to Cloud Spanner Data Definition Language (DDL)
License MIT
Please rate this library. Is it a good library?
Informations about the package mysql-to-spanner
Laravel tool to convert MySQL schemas to Cloud Spanner Data Definition Language (DDL)
Migrating from MySQL to Cloud Spanner
Start here: Migrating from MySQL to Cloud Spanner.
Make sure that:
- All tables got primary keys.
AUTO_INCREMENT
can be ignored (not supported by Cloud Spanner).
Installation
You can install the package via composer:
Usage
MySQL dump
You can dump your MySQL database using command:
Parameters supported:
- Use
--connection
to specify source (MySQL) connection name. - Use
--file
to specify output ex.:php artisan db:spanner-dump --file=storage/spanner-ddl.txt
. - Use
--disk
together with--file
to save output in storage defined in/config/filesystems.php
, ex.:php artisan db:spanner-dump --disk=gcs --file=exports/spanner-ddl.txt
. - Use
--ignore-table
to specify tables to ignore during dump, ex:php artisan db:spanner-dump --ignore-table=password_resets
,php artisan db:spanner-dump --ignore-table=tmp_*
,php artisan db:spanner-dump --ignore-table=table1,table2
. - Use
--default-primary-key
to specify default primary key ex.:php artisan db:spanner-dump --default-primary-key=id
. - Use
--only
to specify tables to export ex.:php artisan db:spanner-dump --only=table1,table2
.
MySQL to Spanner migration
You can migrate your MySQL data to Spanner using command:
By default only schema will be migrated, if you would like to migrate schema and data run:
Parameters supported:
- Use
--connection
to specify source (MySQL) connection name. - Use
--spanner-connection
to specify connection name (spanner
by default). - Use
--fresh
to delete database before creating schemas. - Use
--data
to migrate rows. - Use
--chunk-size
to specify chunk size used in data migration. - Use
--schema=false
to skip schema migration. - Use
--ignore-table
to specify tables to ignore during dump, ex:php artisan db:spanner-dump --ignore-table=password_resets
,php artisan db:spanner-dump --ignore-table=tmp_*
,php artisan db:spanner-dump --ignore-table=table1,table2
. - Use
--default-primary-key
to specify default primary key ex.:php artisan db:spanner-dump --default-primary-key=id
. - Use
--only
to specify tables to export ex.:php artisan db:spanner-dump --only=table1,table2
.
Credits
License
The MIT License (MIT). Please see License File for more information.
All versions of mysql-to-spanner with dependencies
PHP Build Version
Package Version
Requires
php Version
^7.2|^8.0
colopl/laravel-spanner Version ^3.9.1
illuminate/contracts Version ^7.0|^8.0
illuminate/support Version ^7.0|^8.0
mgcosta/mysql-to-cloud-spanner Version ^0.4.3
ext-bcmath Version *
colopl/laravel-spanner Version ^3.9.1
illuminate/contracts Version ^7.0|^8.0
illuminate/support Version ^7.0|^8.0
mgcosta/mysql-to-cloud-spanner Version ^0.4.3
ext-bcmath Version *
The package firevel/mysql-to-spanner contains the following files
Loading the files please wait ....