Qovery / Replibyte

Seed your development database with real data ⚡️
https://www.replibyte.com
GNU General Public License v3.0
4.16k stars 128 forks source link

MYSQL: Unexpected EOF while in a multi-line comment #284

Open mirkanglanz opened 1 year ago

mirkanglanz commented 1 year ago

Hello there, I have the following problem while trying to create a database dump.

Is there any way to solve this, or doesn't it work with this kind of database I'm trying to use?

Error

replibyte -c .replibyte.yaml dump create
⠤ [00:00:01] [###>---------------------------------------] 8.26MiB/100.00MiB (19s)
failing query: '
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `country_tax_free_insert` BEFORE INSERT ON `country` FOR EACH ROW BEGIN
                IF @TRIGGER_DISABLED IS NULL OR @TRIGGER_DISABLED = 0 THEN
                    IF NEW.tax_free = 1 OR NEW.customer_tax IS NULL THEN
                        SET NEW.customer_tax = JSON_OBJECT("enabled", NEW.tax_free, "currencyId", 'b7d2554b0ce847cd82f3ac9bd1c0dfca', "amount", 0);'
thread 'main' panicked at 'TokenizerError { message: "Unexpected EOF while in a multi-line comment", line: 2, col: 5 }', dump-parser/src/mysql/mod.rs:760:13
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace
Failed to execute command replibyte -c .replibyte.yaml dump create: exit status 101

My config file:

#encryption_key: $MY_PRIVATE_ENC_KEY # optional - encrypt data on datastore
source:
  connection_uri: mysql://x:x@x:3306/x # you can use $DATABASE_URL
datastore:
  local_disk:
    dir: replibyte
destination:
  connection_uri: mysql://x:x@x:3306/x_replibyte # you can use $DATABASE_URL

Best Regards