Migrating MariaDB data to NS8

Support
, ,
1

I think my question got kind of buried in this thread, so starting a new one…

I have a couple of databases I need to migrate from my NS7 system to NS8. Getting a dump of the database is easy enough with mysqldump, and importing it through phpMyAdmin would be easy enough–if it weren’t too big. The dump file for one of the databases is 1.2 GB, phpMyAdmin times out importing it, and its “resume” feature is kind of broken. So to the CLI I go.

I’m given to understand that trying to copy files directly into a container is a bad practice. So based on this post, here’s what I think I should be doing:

  • Copy the dump file into /home/mariadb1 on NS8
  • runagent -m mariadb1
  • podman cp dumpfile.sql mariadb-app:/
  • podman exec -ti mariadb-app sh
  • mysql databasename < /dumpfile.sql
  • Exit from however many layers of shell I’ve gotten into

Am I missing anything here?

1 Like
2

Hi @danb35

I don’t think so. The logic is correct - I may be overseeing minute typos - it’s nearly midnight hereabouts!

:slight_smile:

Don’t forget to verify the migration worked, and no funky code get’s barfed! :slight_smile:

My 2 cents
Andy

1 Like
3

Tried this procedure this morning, and it did indeed work as expected. Good deal.

2 Likes