+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Move external database + Docker (/showthread.php?tid=357071)
Move external database + Docker - harry_arg - 2020-09-13
Hi everyone, I'm a little loss here, I already have a external database working with mysql guide here. But now i need to move it and i want to move to a docker. This will be my first docker work so if anyone can point me to the right direction willl be apreciate. My actual database is a ubuntu pc, I want to install openmedia vault in this pc so i need to format it.
In advance thanks.
RE: Move external database + Docker - harry_arg - 2020-09-15
Ok, I start this my self, without luck for now.
I install docker (no problem there), download and run a docker of mariadb following the instruccion of a mediavault forum. I export and import the database to the docker, and the windows client succefully connect to the databse, I belive, this part I'm not sure becase the client show nothing, but it open.
Now I must debug the last part to undestart where is the error. If someone have any clue, they are welcom.
RE: Move external database + Docker - Klojum - 2020-09-15
(2020-09-15, 16:06)harry_arg Wrote: I belive, this part I'm not sure becase the client show nothing, but it open.
If someone have any clue, they are welcom.
Just like you would do without docker: provide a kodi debug log (wiki) so we can see what perhaps goes wrong.
RE: Move external database + Docker - harry_arg - 2020-09-15
Here is my kodi log.
https://paste.kodi.tv/pukazotizu.kodi
But io believe that my problem is in the export of the database or in the import.
So here i leave the command that i use.
mysqldump -u root -p --single-transaction --quick --all-databases > /mnt/docs/kodi
For the import i use:
mysql -u root -p < /config/kodi.sql
When I do this i recibe the following error:
ERROR 1050 (42S01) at line 4969: Table 'user' already exists
I must admit that mysql is not my thing
RE: Move external database + Docker - jmgibson1981 - 2020-09-17
This is the command I use using your variables when I do migrations.
Quote:cat /config/kodi.sql | mysql -u root -p