MySQL Forums - MySQL Workbench - Database Migration

Tips for Optimizing MySQL Performance on a Small Server (no replies)

John Ackerman — Tue, 20 Jan 2026 07:50:10 +0000

Hello,

I’m running MySQL on a small server and looking for general advice on improving performance. The database has moderate traffic, and I’d like to optimize it for efficiency and future growth.

Any recommendations on configuration settings, indexing, or tools for identifying slow queries would be appreciated.

Thanks!

How can I fix Engine errors after migration from 5.7 to 8 (no replies)

Vito Cavallo — Sun, 18 Jan 2026 20:37:25 +0000

I am migrating 6 databases from MySQL 5.7.44 to 8.0.44 and ran into issues with some lacking InnoDB engines.

I used mysqldump command to export databases to an sql file.
I was able restore only with mysql < database-file.sql. Nothing else worked.

Terminal and MySQL workbench worked fine, i can see schemas and tables.
I gracefully shut down the mysql server and rebooted the physical server.

After restarting the mysql server threw errors. Some databases, I believe mysql were MySAM engine. They need to be InnoDB engine.

I am starting the 3 day import again into a clean installation.
I will hold off on the reboot.

Can I alter if running?
How can I alter tables after import?

Is there a better way to backup mysql 5.7 databases for easier 8.0 import?

All the documentation I read recommends mysqldump. Never a mention of converting engines.

Thank YOu.

Problem with MySQL 8.0.x and NetApp snapshot folder (1 reply)

Vito Cavallo — Tue, 10 Jun 2025 13:47:27 +0000

Hello,
I am migrating old CentOS VMs that are hosted on a NetApp.
They are currently MySQL 5.x and I need to migrate to MySQL 8.0.x and Rocky 8 or 9.

I am installing mysql 8.0.x on the CentOS first, so I can verify all database files are updated and working.

Mysql 8 keeps reading the NetApp .snapshot folder as databases and throwing errors and stopping.

For some reason, this was not an issue in Mysql 5.x.
I have exhausted my research on this and cannot find an answer.
MySQL 5 did have a ignore_db_dirs setting but that has been deprecated.

Has anyone had and solved this issue ?

Thank you.

Ignoring Hidden snapshot folder on NetApp in 8.0.x (no replies)

Vito Cavallo — Wed, 07 May 2025 22:46:01 +0000

Hello,

I have the grand task of migrating several old MySQL servers from 5.7 to 8.0.x
The current OS is CentOS 7.9. New OS will be either Rocky Linux 8 or 9, as I taking small steps.

I have searched online for a solution to my issue, I cannot find one.

The databases are several TB in size and reside on a NetApp.
NetApps have a hidden .snapshot folder for hourly backups.

I have removed 5.7 and installed 8.0.11.

The mysqld service goes into the .snapshot folders and throws error messages:
InnoDB: Tablespace ID: 999999999 = ['.snapshot ....]
InnoDB: Plugin initialization aborted with error Failed, retry may succeed.

I did not have this issue with 5.7 and I didn't use the ignore-hidden-folder command either

Does 8.0.x have a solution for keeping out of hidden folders?

Thank you.

Importo da MongoDB (no replies)

Daniele Napoli — Mon, 27 Jan 2025 15:17:11 +0000

Salve a tutti ho esportato un db MongoDB in file json o SQL, ma go un dubbio.
nel database mongoDB sono presenti dei file in PDF cosa succede quando li importo ?
esiste una utility che mi ricrea la struttura ?

Migrating Stored Procedures (no replies)

John Head — Thu, 23 Jan 2025 09:30:52 +0000

Hello Experts,

I am new to MySQL. I have been given a job to migrate the MSSQL database to MySQL. With some difficulty, I have migrated the tables, indexes and constraints using MySQL Workbench and the db loader tool https://www.dbload.com

But now there are nearly a hundred stored procedures that need to be migrated. Can you please help me in the right direction? I have tried some online tools but have not had 100% success. I now think this needs to be done manually.

Thank you in advance

Accidental change of version from 5 to 8 (no replies)

david Ce — Thu, 19 Sep 2024 12:30:18 +0000

Hi,

I had a Docker container running MySQL 5, but I deleted both the container and the image. When I recreated it using the latest image, it installed MySQL 8. After starting it, it didn't work properly, and MySQL deleted the .frm files. Now, I only have the .ibd files left.

I tried recreating the structure to recover the .frm files and then replaced the .ibd files with the old ones, but it didn't work—0 records were recovered.

I’ve now set up a new MySQL 5 container, but unfortunately, I don’t have a backup.

Any suggestions on how to recover the data?

Thanks!

I want to change the path specified in datadir to a network drive (1 reply)

成人飯田 — Fri, 14 Jun 2024 16:24:27 +0000

Currently, I have MySQL (free version) installed on the server.

I am planning to move the data section of MySQL to a network HDD (NAS)
and use the software and data separately.

So, when I move the data using the USB scale, change the datadir in my.ini and start MySQL, it starts up fine, but when I change the datadir to the NAS, MySQL does not start.

Is there any other setting that needs to be done?

I would appreciate any advice.

Migrate Schema Only (no data) 5.7 to 8.0.34 (no replies)

Filipe Santos — Tue, 08 Aug 2023 14:37:49 +0000

Hi, im trying to move my schema without data from rds mysql 5.7 to another rds 8.0.34 using Mysql Workbench.

After migration without error, missing secondary index and stranger keys.

If i did this same process using version 5.7 to 5.7 work correctly.

MySQL Shell for Database Migrations (no replies)

Edwin Desouza — Fri, 21 Jul 2023 00:31:33 +0000

================
from Aurora/MySQL:

— https://blogs.oracle.com/mysql/post/moving-mysql-databases-from-aws-to-oci-using-mysql-shell
— https://lefred.be/content/successful-rds-to-oci-mysql-heatwave-migration-with-replication-channel-filters/
— https://lefred.be/content/migrating-users-from-aurora-to-mds/

================
from MariaDB:

— https://blogs.oracle.com/mysql/post/how-to-migrate-from-mariadb-to-mysql-80
— https://blogs.oracle.com/mysql/post/how-to-migrate-from-mariadb-to-mysql-heatwave
— https://lefred.be/content/migrating-from-mariadb-to-mysql-using-mysql-shell/

================
from PosgreSQL, Aurora/PostgreSQL, RedShift/PostgreSQL:

— https://blogs.oracle.com/mysql/post/how-to-import-data-from-postgresql-to-mysql-heatwave-database-service
— https://blogs.oracle.com/mysql/post/import-data-from-amazon-aurora-postgresql-to-mysql-heatwave-database-service-in-oci
— https://blogs.oracle.com/mysql/post/how-to-import-data-from-amazon-redshift-to-mysql-heatwave-database-service

================
from Microsoft SQLServer:

— https://blogs.oracle.com/mysql/post/how-to-import-data-from-microsoft-sql-server-to-mysql-heatwave-database-service

================

WBCOPYTABLES: --table-range (2 replies)

Scott Carpenter — Fri, 14 Jul 2023 14:22:06 +0000

This feels like it should be a simple question, but I've searched for hours and cannot get it to work. I can't seem to find a real-life example of the --table option.

The CMD file created by the Workbench Migration tool works great for whole tables, but I want to be able to use "--table-range" to update tables and I can't even get a simple "--table" to work.

The contents of text file used by "--table-file" looks like this:

`quantdata` `dates_trading` `quantdata` `dates_trading` `date` `date` `date`, `tradeday_year`, `tradeday_month`, `data`

Output of the CMD file (using --table-file) look like this:

Loading table information from file C:\wb_tables_to_migrate.txt
18:27:24 [INF][ copytable]: --table `quantdata` `dates_trading` `quantdata` `dates_trading` `date` `date`
`date`, `tradeday_year`, `tradeday_month`, `data`
18:27:24 [INF][ copytable]: Connecting to MySQL server at SOURCE:3306 with user root
.......
18:27:25 [DB1][ copytable]: Executing query: SELECT `date`, `tradeday_year`, `tradeday_month`, `data` FROM `dates_trading` ORDER BY `date`

The table has only FOUR columns: date, tradeday_year, tradeday_month, data

If I try to migrate the same table on the command line, I get "Missing value for table copy specification"

C:\Progra~1\MySQL\MYSQLW~1.0CE\wbcopytables.exe ^
--mysql-source="root@SOURCE:3306" ^
--source-rdbms-type=Mysql ^
--target="root@localhost:3306" ^
--source-password="PASSWORD" ^
--target-password="PASSWORD" ^
--thread-count=1 ^
--dont-disable-triggers ^
--truncate-target ^
--log-level=debug3 ^
--table `quantdata` `dates_trading` `quantdata` `dates_trading` `date`, `tradeday_year`, `tradeday_month`, `data`

Question 1: Why are there 2 extra DATE fields in the text file?
Question 2: WHAT AM I DOING WRONG?
Question 3: If I can get --table to work, how do I use --table-range? I want to add "WHERE DATE > xxxx"

The WB manual (https://dev.mysql.com/doc/workbench/en/wbcopytables.html) seems simple enough, but does not include samples.
Thanks very much,

Scott

Migrating from My SQL 5.0 to My SQL 5.7 or newer version (no replies)

Mars Redjo Wiryono — Tue, 11 Jul 2023 02:20:47 +0000

Dear All,
I am Newbie in My SQL.

I have problem, how to migrate database to My SQL version that can be access both from My SQL 5.0 based software and My SQL 5.7 based software.

The case is like this,
I have old software/application that build with My SQL 5.0 Version. Then I want to use another Software/application that build from My SQL 5.7 Version, that can use data base from Older My SQL. The both software has to run simultaneously, running together to access the same database version.

Can anyone help with my Problem?

Thank in advance.

Best Regards,

Mars Redjo Wiryono,
Bekasi - Indonesia

MySQL Workbench Migration Wizard refuses to reverse engineer table and gives no reason why (no replies)

Jay Bienvenu — Fri, 21 Apr 2023 13:01:05 +0000

I'm trying to migrate a database from my development machine to the staging environment using the Migration Wizard in MySQL Workbench on my development machine. The Migration Wizard is refusing to reverse engineer one critical table.

I am not a database admin by trade; I am a developer with one objective, to copy my database from my machine to another. My search on the term mysql workbench migration Table not reverse engineered turned up some SO posts from people migrating between DB platforms and some information about reverse engineering in MySQL but nothing that helped me determine the problem. For griggles, I ran the Reverse Engineering command in Workbench hoping it would fail and give me some useful information. But the Reverse Engineering command ran without a hitch and produced a correct relationship graph.

So I have a migration that's refusing to export a critical table, and no details about what's wrong or how I can fix it. I'm not happy.

What can I do to determine why the Migration Wizard isn't reverse-engineering my table? And exactly how can Migration Wizard fail to reverse-engineer it when the Reverse Engineering command handles it without fail?

This is the log from the Reverse Engineer Source step, snipped for relevance:

```
Starting...
Connect to source DBMS...
- Connecting...
Connecting to Mysql@localhost:3306...
Connected to Mysql@localhost:3306, 8.0.32-0ubuntu0.20.04.2
Connect to source DBMS done
Reverse engineer selected schemas....
Reverse engineering my_database from def
- Preparing...
- Preparing...
Reverse engineering tables from my_database

- Retrieving table my_database.licenses...
- Reverse engineering my_database.licenses...

Reverse engineering triggers from my_database
Reverse engineering stored procedures from my_database
Reverse engineering functions from my_database
- Reverse engineered 25 objects
WARNING: Table licenses was referenced from another table, but was not reverse engineered
Reverse engineer selected schemas finished
Post-processing of reverse engineered schemas...
Post-processing of reverse engineered schemas done
Tasks finished with warnings and/or errors; view the logs for details
Finished performing tasks.
```

Unable to load CSV (2 replies)

Christo van Deventer — Tue, 19 Jul 2022 09:59:25 +0000

I am trying to import CSV 370 columns,
5 columns with variable data and 365 columns for each day of the year.
ERROR: Import data file: ('Row size too large (> 8126). Changing some columns to TEXT or BLOB

Unable to load CSV (3 replies)

Tushar Goel — Tue, 17 May 2022 17:52:06 +0000

Hello Everyone, I am trying to upload a CSV file (present in the S3 AWS cloud) to Aurora MySQL. I have 28 columns present but only having difficulty importing with 2 columns only, I keep getting the following error

SQL Error [1054] [42S22]: Unknown column 'QUESTION' in 'field list'

I see the column present in the table and CSV file. Also data is correct as well. Any help is much appreciated. I am trying following thing:

desc table
QUESTION VARCHAR(128),

LOAD DATA FROM S3 FILE 's3:///xx/data_0_0_0.csv'
IGNORE
INTO TABLE test.tableName
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
IGNORE 1 LINES
(ISCORRECT,QUESTION,xxx);

If I remove 2 problematic columns then it is working fine.

Tushar Goel

Errors with Information_Schema in Create Target Results (38 replies)

Vaughan Wickham — Wed, 23 Feb 2022 17:44:57 +0000

Hello,

Am using WorkBench 6.3 and MySQL 5.7.18

Have reached the Create Target Results step and all the steps relating to the Information_Schema have errors

e.g.
ERROR: Error executing 'DROP SCHEMA IF EXISTS `information_schema` '
Access denied for user 'root'@'localhost' to database 'information_schema'.
SQL Error: 1044

ERROR: Error executing 'CREATE TABLE IF NOT EXISTS `information_schema`.`CHARACTER_SETS` (
`CHARACTER_SET_NAME` VARCHAR(32) NOT NULL DEFAULT '',
`DEFAULT_COLLATE_NAME` VARCHAR(32) NOT NULL DEFAULT '',
`DESCRIPTION` VARCHAR(60) NOT NULL DEFAULT '',
`MAXLEN` BIGINT(3) NOT NULL DEFAULT '0')
ENGINE = MEMORY
DEFAULT CHARACTER SET = utf8'
Access denied for user 'root'@'localhost' to database 'information_schema'.
SQL Error: 1044

Would appreciate advice on how to proceed

Thanks

VW

How to change SSL from Require to Use if available (3 replies)

Vaughan Wickham — Sat, 23 Oct 2021 07:41:10 +0000

Hello,

I want to change the SSL setting in the Migration Wizard from Require to Use if available

Looks like this cannot be done from within the Wizard itself

Thanks

VW

Table DAta Import Wizard only imports 100 rows (no replies)

JK Heydt — Mon, 26 Jul 2021 17:52:45 +0000

Using the Table Data Import Wizard to import a text file but it only returns 100 rows. There are over 600 rows in the table. Why?

Workbench crashes during migration (4 replies)

Saumik Vora — Thu, 12 May 2022 02:26:19 +0000

Hi,

I am trying to migrate just a single table from MS SQL to MYSQL. During Generate SQL Create Statements process, WorkBench crashes. I saw log wb*.txt but does not show any anomaly. Kindly guide how to further proceed.

Please Note: My OS is Windows 2012 Server

Regards,
Saumik Vora

Copy PROD db's to TEST db's (no replies)

Kevin Smee — Tue, 27 Apr 2021 14:31:18 +0000

I have a MySQL PROD db that is replicated (PROD1 and PROD2, respectively) that I would like to copy (overwrite) to my TEST instance db; also replicated (TEST1 and TEST2). I was thinking of using the MySQL Workbench's Migration Wizard for this. The replication piece has me concerned as to the best - and simplest - way to do this. My thought was to stop the MySQL services on TEST and set the Wizard option to truncate the tables in TEST1 and TEST2. Looking for advice. Thanks!

Inconsistencies migrating a database from MySQL Community Edition 5.7.22 (32 Bit) to MySQL Community Edition 5.7.32 (64 Bit) (3 replies)

Christian Schnell — Fri, 23 Oct 2020 08:40:08 +0000

Hi,

for almost three weeks now I have been trying to migrate a MediaWiki (+SemanticMediaWiki) Database from an old Debian 7 (Wheezy) Sytstem to a current Debian 10 (Buster) System and I get inconsistencies within the restored database.

Originally, the Wheezy System had MySQL 5.5.60 (32 Bit) installed (part of the Debian Wheezy standard distribution), and I did two in-place upgrades, first from MySQL 5.5.60 to Community Server 5.6.40, and then to Community Server 5.7.22. I used the DEB-Bundle "mysql-apt-config_0.7.3-1_all.deb" on that old 32 Bit System as it seems to be the last one for Wheezy. These upgrades worked perfectly fine and the database system continued to deliver consistent database query results.

Maybe it is important, the old 32 Bit System had default character set "latin1", I am not sure how much that affects text encoding in the databases.

On the new Debian Buster System, I deinstalled MariaDB 10.3 and downgraded to MySQL 5.7.32 using DEB bundle "mysql-apt-config_0.8.15-1_all.deb". I actually purged MariaDB to make sure the MySQL installation is clean.

I did all the up- and downgrading after noticing that a mysqldump from 5.5 (32 Bit) to MariaDB 10.3 (64 Bit) caused inconsistencies in the restored database. Yet, this problem persisted throughout all my efforts, however I do think migrating from 5.7.x (32) to 5.7.y (64) should have the best preconditions in order to succeed.

I have tried the usual mysldump | mysql , several variations using "--default-character-set=latin1" for the mysqldump command, for the mysql command and also for both. I have also tried a filesystem-based copy of the entire directory "/var/lib/mysql". Again and again, nothing crashes or reports and error, but the restored database has inconsistencies.

Thinking that the inconsistency might stem from the current version of MediaWiki (1.35), I also tried the same with MediaWiki 1.31 (current long-term stable release), but there it is even worse.

The inconsistencies themselves are a bit vague to describe for me, as I am not too deply involved with the relatively complex MediaWiki Software (plus SemanticMediaWiki on top), but in general the restored system delivers wrong content for valid page paths, it is as if pointers (indices, I guess) are pointing into the wrong table.

My question is: How is it even conceivable that "mysqlump | mysql" fails under the circumstances that I have described above? I simply don't understand it. The 32/64 Bit difference should not matter since I am transforming the database in a textual representation (by unsing mysqldump), that would be a bug too worse to imagine. So all that is left is maybe a Latin1/Unicode conflict that messes things up?

Thanks for any help, I'm basically out of ideas. I've tried to search for bug reports similar to what I am experiencing, no luck.

Christian

Migration from ubuntu mysql 5.7 to windows mysql 5.7 (3 replies)

calvin law — Thu, 17 Sep 2020 07:30:17 +0000

Dear all,

I have some issues regrading migration from ubuntu (Server 1) to windows MySQL (Server 2). First of all, I had installed MySQL migration tools on Server 2, and when i try to migrate the data, Server 1 does not migrate the data. Some of the views stated syntax error and unable to create in the migration.

Then when I try to migrate with MySQL from the migration tab, all tables and views and routines were successfully created, but it will generate errors like MySQL server had gone away. So i double check on those tables, on which it is a big tables with carry lot of data inside.

`ntnsap`.`dtrtbl`:Finished copying 55 rows in 0m02s
`ntnsap`.`bgttbl`:Copying 17 columns of 280637 rows from table `ntnsap`.`bgttbl`
ERROR: `ntnsap`.`bgttbl`:Failed copying 30617 rows
ERROR: `ntnsap`.`dptmas`:mysql_query(SELECT count(*) FROM `dptmas`): MySQL server has gone away
`ntnsap`.`dptmas`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`dlrtbl`:mysql_query(SELECT count(*) FROM `dlrtbl`): MySQL server has gone away
`ntnsap`.`dlrtbl`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`tmptrt`:mysql_query(SELECT count(*) FROM `tmptrt`): MySQL server has gone away
`ntnsap`.`tmptrt`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`rbttbl`:mysql_query(SELECT count(*) FROM `rbttbl`): MySQL server has gone away
`ntnsap`.`rbttbl`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`tihfil`:mysql_query(SELECT count(*) FROM `tihfil`): MySQL server has gone away
`ntnsap`.`tihfil`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`lidtbl`:mysql_query(SELECT count(*) FROM `lidtbl`): MySQL server has gone away
`ntnsap`.`lidtbl`:Finished copying 0 rows in 0m00s

So i run some of the scripts like this,

-- SHOW VARIABLES LIKE 'sql_mode'; -- show status on SQL mode

-- set sql_mode=''; -- change the mode to non strict mode as to copy the data without checking the format.

-- select @@sql_mode; -- to show mysql mode status.

-- set global max_allowed_packet=104857600; -- allow maximum packet to 100mb for data transfer.

After applying those scripts, the migration still does not run correctly, it will just lost connection from copying large table to Server 2. I have try to migrate the data from server 1 to my PC and the migration completed without any error.

Server 1 Specification
OS: ubuntu 18.4
MySQL Server Ver: 5.7
Processor: Xeon E3400 Series
RAM: 4GB

Server2 Specification
OS: Windows Server 2012 R2
MySQL Server Ver: 5.7
Processor: Xeon E3400 Series
RAM: 4GB

My PC Specification
OS: Windows 10 Pro 1909
MySQL Server Ver: 5.7
Processor: Corei7 10700 Series
RAM: 16GB

Please Advice.

Thank You

Migration from ubuntu mysql 5.7 to windows mysql 5.7 (no replies)

calvin law — Wed, 16 Sep 2020 00:48:10 +0000

Dear all,

I have some issues regrading migration from ubuntu (Server 1) to windows MySQL (Server 2). First of all, I had installed MySQL migration tools on Server 2, and when i try to migrate the data, Server 1 does not migrate the data. Some of the views stated syntax error and unable to create in the migration.

Then when I try to migrate with MySQL from the migration tab, all tables and views and routines were successfully created, but it will generate errors like MySQL server had gone away. So i double check on those tables, on which it is a big tables with carry lot of data inside.

`ntnsap`.`dtrtbl`:Finished copying 55 rows in 0m02s
`ntnsap`.`bgttbl`:Copying 17 columns of 280637 rows from table `ntnsap`.`bgttbl`
ERROR: `ntnsap`.`bgttbl`:Failed copying 30617 rows
ERROR: `ntnsap`.`dptmas`:mysql_query(SELECT count(*) FROM `dptmas`): MySQL server has gone away
`ntnsap`.`dptmas`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`dlrtbl`:mysql_query(SELECT count(*) FROM `dlrtbl`): MySQL server has gone away
`ntnsap`.`dlrtbl`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`tmptrt`:mysql_query(SELECT count(*) FROM `tmptrt`): MySQL server has gone away
`ntnsap`.`tmptrt`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`rbttbl`:mysql_query(SELECT count(*) FROM `rbttbl`): MySQL server has gone away
`ntnsap`.`rbttbl`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`tihfil`:mysql_query(SELECT count(*) FROM `tihfil`): MySQL server has gone away
`ntnsap`.`tihfil`:Finished copying 0 rows in 0m00s
ERROR: `ntnsap`.`lidtbl`:mysql_query(SELECT count(*) FROM `lidtbl`): MySQL server has gone away
`ntnsap`.`lidtbl`:Finished copying 0 rows in 0m00s

So i run some of the scripts like this,

-- SHOW VARIABLES LIKE 'sql_mode'; -- show status on SQL mode

-- set sql_mode=''; -- can the mode to non strict mode as to copy the data without checking the format.

-- select @@sql_mode; -- to show mysql mode status.

-- set global max_allowed_packet=104857600; -- allow maximum packet to 100mb for data transfer.

After applying those scripts, the migration still does not correctly, it will just lost connection from copying large table to Server 2. I have try to migrate the data from server 1 to my PC and the migration completed without any error.

Server 1 Specification
OS: ubuntu 18.4
MySQL Server Ver: 5.7
Processor: Xeon E3400 Series
RAM: 4GB

Server2 Specification
OS: Windows Server 2012 R2
MySQL Server Ver: 5.7
Processor: Xeon E3400 Series
RAM: 4GB

My PC Specification
OS: Windows 10 Pro 1909
MySQL Server Ver: 5.7
Processor: Corei7 10700 Series
RAM: 16GB

Please Advice.

Thank You

migration from 5.0/5.1 (1 reply)

Mohammad Mohammad — Sat, 06 Jun 2020 18:44:46 +0000

Dear All,

Many of our legacy systems are running in mysql version 5.0 or 5.1, where we we can't meet our requirements of password complexity or audit trail. Hence, we want to migrate our db from this old version to mysql 8 or mariadb 10.4 where issues are solved.

Please suggest which version is appropriate where we don't need to change much from application coding or any thing else. Just migrate mysql version would work.

Thanks in advance

Data migration from Mongodb to MySQL (3 replies)

Sai Krishna — Fri, 03 Apr 2020 07:55:41 +0000

Hi all, I want to migrate all my data from mongodb to MySQL. I have tried exporting json data from mongodb and importing to MySQL. When i am doing this, am able to get all the data expect the image data. How do i get mongodb images to MySQL.
Can anybody please help me. any help would be thankful.

mysql 8 group by error after migration (1 reply)

chase miller — Mon, 20 Jan 2020 04:48:41 +0000

Hello
we have migrated from mysql 5.6 to 5.8, and we have a query that has a group by in it, and it won't run. error message is
[ERROR] [MY-013132] [Server] The table '/var/lib/mysql/tmp/#sql2d349_80_d' is full!

any idea what server variable we need to change; we have changed many of the innodb to no success.

Unable to migrate views, routines and stored procedures from MSSQL (4 replies)

Revanth Suryadevara — Fri, 19 Apr 2019 17:13:04 +0000

I tried migrating the data from MSSQL server database(Windows) to mariadb(Linux) using Mysql Workbench.

Workbench migrated few tables but skipped views, routines and stored procedures.

I even created a mariadb sql file, the schema related to views,routines and stored procedures was not converted to mariadb syntax and was commented.

Mysql workbench documentation did not mention any limitations with respect to views, routines and stored procedures.

Migrate database from MySQL 5.5 to 5.6 (1 reply)

Jeff Golden — Sun, 07 Apr 2019 14:33:59 +0000

Hi everybody.

I have, please, a MySQL database that I need to convert from version 5.5 to 5.6; it's the database of my Wordpress site that I'm transferring from my old hosting provider that have MySQL 5.5 to a new one that requires MySQL 5.6.

So, I downloaded this database on my computer, installed both versions of MySQL server 5.5 and 5.6, and I'm trying to use MySQL Workbench to convert/migrate it.
I tried the "Schema Transfer Wizard" and the "Migration Wizard" but don't know how to use them; sorry I'm very beginner.

For example in the "Schema Transfer Wizard", when I select the source and destination MySQL server and click on Next, I find just a "Test" schema in the "Schema Selection" phase. How can I get my local database showed there to select it?

Could you please help me; I'm really stuck!
Thank you very much.

Unhandled MySQL type 245 for column x (1 reply)

Alexandru Busuioc — Tue, 12 Feb 2019 08:07:55 +0000

I'm using a generated script (by MySQL Workbench) to migrate the data between 2 databases.
At some point I get

> ERROR:`users`.`user_details`:Unhandled MySQL type 245 for column 'address_info'
> ERROR:`users`.`user_details`:Failed copying 154 rows
> /usr/lib/mysql-workbench/wbcopytables: line 16: 23755 Segmentation fault (core dumped) $MWB_BINARIES_DIR/wbcopytables-bin "$@"

That `address_info` column is a JSON type.

Is there something I could do to avoid this error and succeed with the migration? Or `wbcopytables` doesn't support JSON data type just yet?

FTR

> $ wbcopytables --version
> wbcopytables-bin CE (GPL) 8.0.15 CE build 14271522

Thank you,

Alexandru

trouble with Migration Wizard (1 reply)

Josh Moses — Thu, 24 Jan 2019 18:07:03 +0000

Hi, I'm trying to migrate my local MS Access database to MySQL on Amazon Lightsail and the MySQL Workbench Migration Wizard is failing partway through.

"Test Connection" succeeds for both the Source and the Target.
"Fetch Schema List" succeeds for all three tasks: "Connect to source DBMS," "Check target DBMS connection," and "Retrieve schema list from source"

But the next step, "Reverse Engineer Source," fails on its first task, "Connect to source DBMS." It responds:
Error("('HY000', 'The driver did not supply an error!')"): error calling Python module function DbMsAccessRE.connect

I'm stuck there. I searched google, I reinstalled MySQL Workbench, I rebooted my computer, I don't know where to go next.

Any advice please?