- #DOCKER MYSQL EXPORT DATABASE HOW TO#
- #DOCKER MYSQL EXPORT DATABASE SOFTWARE#
- #DOCKER MYSQL EXPORT DATABASE WINDOWS#
#DOCKER MYSQL EXPORT DATABASE SOFTWARE#
In this case, you have to download software like WAMP, MySQL workbench, and XAMPP to run SQL commands, access your databases and records.
#DOCKER MYSQL EXPORT DATABASE WINDOWS#
For example, let’s say you are working on a Windows environment and running a MySQL database server. You can use several RDBMS to run SQL queries, such as MySQL, PostgreSQL, SQLite, SimpleDB, and Elasticsearch.Īt times, it becomes hectic to set up an SQL server on your local computer. Maybe just ignore people if you don’t like providing support.MySQL is an open-source Relational Database Management System (RDBMS) with a large user base. I’ll accept fox can do what he pleases with his project, but geez. I don’t exactly call that “basic Unix” knowledge.
It didn’t occur to me that it’s all about the env variables. I was crawling around in the php config files to try to mimic that.
#DOCKER MYSQL EXPORT DATABASE HOW TO#
But it seems like this is yet another project where the users are expected to walk on eggshells, since the developer feels he doesn’t owe anyone anything and everyone else is an idiot.įor the record, I’ve been using Linux for 20 years, I have moderate experience developing in C, PHP, Python… It just so happens I don’t know a thing about PDO and how it figures out how to make the DB connection. I’ve been using it since Google Reader went away. I’ve been struggling with exactly this problem for hours - first running into this on a docker instance, then trying to do it in a non docker instance, and now back to docker and finally discovering this article while writing a post. I’ll try it again tomorrow, and if I ever find a working solution, I’m happy to share it with this friendly community. Enable in PLUGINS directive of config.phpĭoes not really work for the docker setup as the entire define is no longer there?.Git clone to /plugins.local/data_migration.
I am sure I just missed another line from the wiki or it is just due to me not knowing any basics, or maybe the documentation for the part where it says The plugin shows up in the list but is not active and -help doesn’t show anything for the data migration so I am stuck. I tried installing it from the plugin installer / cloning the data_migration into plugins.local, made sure the path/permissions are correct and tried 3 different ways to enable it without success (put the define in the config.php directly (which only seems to have ) directly, created a plugins.php in config.d and put the define line in there, then I saw the sticky post for the classes/config and tried updating it in there as well. I found the “hard way” by googling for the errors I faced and ended up in a post somewhere in this board.Īnyway, after adding the -user app to the exec, I was able to get past the error, but the data_migrate plugin doesn’t seem to work for me. That is quite a common use case and there are probably also some other people struggling with this. But maybe, just for the fun of it, try to imagine/googling the right way to migrate the stuff from a user perspective (maybe someone who’s just using docker occasionally). Would you have any suggestions or maybe another way to migrate at least the starred articles? I am using tt-rss basically since it exists and would love to be able to migrate all my data over to the new instance.Įasy to say that as the developer. So it seems to be unable to connect to the database… I have tried it from the updater container as well as from the db container - but it is failing with the same error every time I try it… Is the server running locally and acceptingĬonnections on Unix domain socket "/tmp/.s.PGSQL.5432"?3e3af10b48d3:~$ rwxrwxrwx 1 app app 17280737 Mar 11 11:59 export-.zipģe3af10b48d3:~$ /usr/bin/php8 /var/Exception while creating PDO object:SQLSTATE could not connect to server: No such file or directory I have installed the ttrss-data-migration plugin via web frontend - is that correct?ĭocker exec -it ttrss-docker_app_1 /bin/shĭrwxr-xr-x 2 root root 4096 Mar 11 11:59. I have created my export folder within the tt-rss folder, I can see the file in the docker container when I cd’ into the /var/www/html/tt-rss/exports directory - and when I try to run the import command, it errors out with a database connection error.
The attempt that got me somewhere was the ttrss-data-migration way, I have the export file in my docker container, but I somehow struggle to run the command. So far, everything went well and I have a running instance.īut what I’d like to do is to migrate my starred articles to the new environment, so far, I haven’t really found a way to do that. I am currently in the process of migrating my tinyrss instance from the “old” setup to the new, supported docker setup.
0 kommentar(er)
