1

I'm migrating a 4D database to a MySQL database. I have around 50k - 60k of SQL lines to do this. What is the fastest way to send this to the remote db?

Because it's in development and the export changes frequently I have to run this multiple times a week.

I use START TRANSACTION; COMMIT; and I tried using source, but I'm not really impressed by the speed of the executions.

What is the approach I am looking for?

Tim Penner
  • 3,551
  • 21
  • 36
Billy
  • 1,104
  • 8
  • 22

1 Answers1

0

Export table from database:

mysqldump -u username –-password=password database_name > file.sql

Import table:

mysql -u username –-password=password database_name < file.sql
Pankaj katiyar
  • 464
  • 10
  • 26