# Is MyPhpAdmin installed from docker? + import questions
**URL:** https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230
**Category:** Get Help
**Created:** [May 31, 2017, 8:49am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230 "2017-05-31T08:49:33Z")
**Posts on this page:** 18
**Page:** 1
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 8:49am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/1 "2017-05-31T08:49:33Z")
Hi, im new to the docker version of xibo and i have a few questions:
- I need to import my sql database from a previous installation but i cant seem to find a installationguide on myphpadmin for xibo, but in all the backup guides myphpadmin us used? Is it installed from the beginning? If so, how do i access it?
- I have a few html scripts that i have to use, where do i store these? And what is the url to acces them?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 8:58am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/2 "2017-05-31T08:58:24Z")
You can import your database by following the guide on upgrading from an earlier version ([http://xibo.org.uk/manual-tempel/en/upgrade.html#switching\_to\_docker](http://xibo.org.uk/manual-tempel/en/upgrade.html#switching_to_docker)). The container is setup to look for an import.sql file.
If you want to have PHPMyAdmin available to you, you can do so by running it in it’s own container. That’s covered in the following FAQ:
> [@How can I run a SQL command when using a Docker Install?](https://community.xibo.org.uk/t/how-can-i-run-a-sql-command-when-using-a-docker-install/9946):
>
> While troubleshooting an issue you maybe asked to run a SQL statement on your database Docker container, or you may want to run a statement yourself for another purpose. To do either of these things there are two options. Using the command line Using the GUI called PhpMyAdmin Command Line Before you can run a statement inside the docker container you will need to find the container name. This can be done using the docker ps command. The resulting output will show a list of running docker con…
Your custom HTML goes in `shared/cms/userscripts` and is available at `http://server.domain.com/userscripts` where `server.domain.com` is the IP address or DNS name for your server.
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 10:49am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/3 "2017-05-31T10:49:49Z")
Thank You! But i get an error when i try to import it, i put the import.sql in the backup folder and run docker-compose up and get the following:
cms-web\_1 | Attempting to import database
cms-web\_1 | Importing Database
cms-web\_1 | ERROR 1062 (23000) at line 44 in file: ‘/var/www/backup/import.sql’: Duplicate entry ‘1’ for key 'PRIMARY’
cms-web\_1 | Configuring Database Settings
cms-web\_1 | Setting up Maintenance
cms-web\_1 | mv: ‘/var/www/backup/import.sql’ and ‘/var/www/backup/import.sql.done’ are the same file
cms-web\_1 | DBVersion
cms-web\_1 | 132
What does this mean?
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 10:56am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/4 "2017-05-31T10:56:50Z")
Perhaps you already ran `docker-compose up` before that, and have a database already created?
You can only import the first time the containers are run.
If so, do the following. This will remove the existing database and import your old one.
```
docker-compose down
rm -r shared/db
mv shared/backup/import.sql.done shared/backup/import.sql
docker-compose up -d
```
Since you’re importing an existing database, you’ll also need to run a SQL command after the database has been successfully imported. Use the FAQ I linked previously to run the following:
```
UPDATE setting SET value="/var/www/cms/library/", userChange=0, userSee=0 WHERE setting="LIBRARY_LOCATION";
```
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:00am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/5 "2017-05-31T11:00:53Z")
Sorry for the dumb question…
C:\xibo-docker\>rm -r shared/db
’rm’ is not recognized as an internal or external command,
operable program or batch file.
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:04am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/6 "2017-05-31T11:04:04Z")
I assumed a Linux host since you didn’t say what you were running on.
In that case
```
docker-compose down
del /s shared\db
move shared\backup\import.sql.done shared\backup\import.sql
docker-compose up -d
```
Then the SQL per my previous post.
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:13am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/7 "2017-05-31T11:13:59Z")
Thank you for your patience, i now get the following:
ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:14am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/8 "2017-05-31T11:14:22Z")
… at which stage?
The more information you give, the more likely I am to be able to help you.
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:14am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/9 "2017-05-31T11:14:49Z")
C:\xibo-docker\>docker exec -ti xibodocker\_cms-web\_1 bash
root@c41848b28135:/# mysql -u cms -h mysql -p cms
Enter password:
ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:17am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/10 "2017-05-31T11:17:07Z")
Strange. The `mysql` host should be available.
Did the previous step complete without errors? What does `docker-compose logs` show?
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:18am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/11 "2017-05-31T11:18:22Z")
It did seem to work before, the logs says the following:
C:\xibo-docker\>docker-compose logs
Attaching to xibodocker\_cms-web\_1, xibodocker\_cms-db\_1, xibodocker\_cms-xmr\_1
cms-db\_1 | 2017-05-31 11:06:44 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:06:44 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:06:50 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:06:50 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:06:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:06:53 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:06:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:06:56 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:07:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:07:00 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:07:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:07:09 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:07:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:07:14 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:07:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:07:23 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:07:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:07:38 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:08:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:08:06 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:09:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:09:00 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:10:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:10:45 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:14:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:14:12 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-web\_1 | Waiting for MySQL to start - max 300 seconds
cms-web\_1 | MySQL started
cms-web\_1 | Attempting to import database
cms-web\_1 | Importing Database
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | Configuring Database Settings
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | Setting up Maintenance
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | mv: ‘/var/www/backup/import.sql’ and ‘/var/www/backup/import.sql.done’ are the same file
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | New install
cms-web\_1 | Provisioning Database
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | Configuring Database Settings
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | Setting up Maintenance
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | ERROR 2005 (HY000): Unknown MySQL server host ‘mysql’ (0)
cms-web\_1 | Updating settings.php
cms-web\_1 | Configuring Backups
cms-web\_1 | Configuring Maintenance
cms-web\_1 | Running maintenance
cms-web\_1 | Starting cron
cms-web\_1 | Starting webserver
cms-web\_1 | AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.18.0.4. Set the ‘ServerName’ directive globally to suppress this message
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:21am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/12 "2017-05-31T11:21:08Z")
That looks like a bunch of errors to me.
Please can you down the containers (`docker-compose down`), and then ensure that the shared/db folder is completely empty, and that there are no containers running (`docker ps`) and then try again?
I suspect there’s something else going on here causing interference.
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:34am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/13 "2017-05-31T11:34:51Z")
Thank you so much, now the sql works (the db folder wasnt empty for some reason). But i cant access [http://localhost](http://localhost) anymore, i did a docker-compose up -d and waited a few minutes but localhost says “this page cant be displayed”
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:36am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/14 "2017-05-31T11:36:06Z")
What does `docker-compose logs` show?
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:40am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/15 "2017-05-31T11:40:05Z")
C:\xibo-docker\>docker-compose logs
Attaching to xibodocker\_cms-web\_1, xibodocker\_cms-db\_1, xibodocker\_cms-xmr\_1
cms-web\_1 | Waiting for MySQL to start - max 300 seconds
cms-web\_1 | MySQL started
cms-web\_1 | Attempting to import database
cms-web\_1 | Importing Database
cms-web\_1 | Configuring Database Settings
cms-web\_1 | Setting up Maintenance
cms-web\_1 | DBVersion
cms-web\_1 | 94
cms-web\_1 | Updating settings.php
cms-web\_1 | Configuring Backups
cms-web\_1 | Configuring Maintenance
cms-web\_1 | Waiting for MySQL to start - max 300 seconds
cms-web\_1 | MySQL started
cms-web\_1 | DBVersion
cms-web\_1 | 94
cms-web\_1 | Configuring Backups
cms-web\_1 | Configuring Maintenance
cms-web\_1 | Running maintenance
cms-web\_1 | Starting cron
cms-web\_1 | Starting webserver
cms-web\_1 | AH00558: apache2: Could not reliably determine the server’s fully qualified domain name, using 172.18.0.4. Set the ‘ServerName’ directive globally to suppress this message
cms-db\_1 | Initializing database
cms-db\_1 | 2017-05-31 11:25:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:25:34 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db\_1 | 2017-05-31 11:25:34 0 [Note] /usr/sbin/mysqld (mysqld 5.6.36) starting as process 36 …
cms-db\_1 |
cms-db\_1 |
cms-db\_1 | 2017-05-31 11:25:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:25:45 0 [Note] Ignoring --secure-file-priv value as server is running with --bootstrap.
cms-db\_1 | 2017-05-31 11:25:45 0 [Note] /usr/sbin/mysqld (mysqld 5.6.36) starting as process 59 …
cms-db\_1 |
cms-db\_1 |
cms-db\_1 |
cms-db\_1 |
cms-db\_1 | PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
cms-db\_1 | To do so, start the server, then issue the following commands:
cms-db\_1 |
cms-db\_1 | /usr/bin/mysqladmin -u root password 'new-password’
cms-db\_1 | /usr/bin/mysqladmin -u root -h 8132ea3fc6d9 password 'new-password’
cms-db\_1 |
cms-db\_1 | Alternatively you can run:
cms-db\_1 |
cms-db\_1 | /usr/bin/mysql\_secure\_installation
cms-db\_1 |
cms-db\_1 | which will also give you the option of removing the test
cms-db\_1 | databases and anonymous user created by default. This is
cms-db\_1 | strongly recommended for production servers.
cms-db\_1 |
cms-db\_1 | See the manual for more instructions.
cms-db\_1 |
cms-db\_1 | Please report any problems at [http://bugs.mysql.com/](http://bugs.mysql.com/)
cms-db\_1 |
cms-db\_1 | The latest information about MySQL is available on the web at
cms-db\_1 |
cms-db\_1 | [http://www.mysql.com](http://www.mysql.com)
cms-db\_1 |
cms-db\_1 | Support MySQL by buying support/licenses at [http://shop.mysql.com](http://shop.mysql.com)
cms-db\_1 |
cms-db\_1 | Note: new default config file not created.
cms-db\_1 | Please make sure your config file is current
cms-db\_1 |
cms-db\_1 | WARNING: Default config file /etc/mysql/my.cnf exists on the system
cms-db\_1 | This file will be read by default by the MySQL server
cms-db\_1 | If you do not want to use this, either remove it, or use the
cms-db\_1 | --defaults-file argument to mysqld\_safe when starting the server
cms-db\_1 |
cms-db\_1 | Database initialized
cms-db\_1 | MySQL init process in progress…
cms-db\_1 | 2017-05-31 11:25:48 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:25:48 0 [Note] mysqld (mysqld 5.6.36) starting as process 87 …
cms-db\_1 | Warning: Unable to load ‘/usr/share/zoneinfo/iso3166.tab’ as time zone. Skipping it.
cms-db\_1 | Warning: Unable to load ‘/usr/share/zoneinfo/leap-seconds.list’ as time zone. Skipping it.
cms-db\_1 | Warning: Unable to load ‘/usr/share/zoneinfo/zone.tab’ as time zone. Skipping it.
cms-db\_1 | GENERATED ROOT PASSWORD: odaejo0DeeyoPheongechach2ietu7ee
cms-db\_1 | Warning: Using a password on the command line interface can be insecure.
cms-db\_1 | Warning: Using a password on the command line interface can be insecure.
cms-db\_1 | Warning: Using a password on the command line interface can be insecure.
cms-db\_1 | Warning: Using a password on the command line interface can be insecure.
cms-db\_1 |
cms-db\_1 |
cms-db\_1 | MySQL init process done. Ready for start up.
cms-db\_1 |
cms-db\_1 | 2017-05-31 11:25:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:25:53 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
cms-db\_1 | 2017-05-31 11:30:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit\_defaults\_for\_timestamp server option (see documentation for more details).
cms-db\_1 | 2017-05-31 11:30:23 0 [Note] mysqld (mysqld 5.6.36) starting as process 1 …
---
### Author:  [@alex](https://community.xibo.org.uk/u/alex)
#### Post date: [May 31, 2017, 11:41am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/16 "2017-05-31T11:41:57Z")
It all looks like it should be up and running.
What does `docker ps` show?
---
### Author:  [@Wirex](https://community.xibo.org.uk/u/Wirex)
#### Post date: [May 31, 2017, 11:43am UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/17 "2017-05-31T11:43:44Z")
Now it works! I guess it needed more time than i thougth, everything works in the cms too.
Thank you so much for your help.
---
### Author:  [@system](https://community.xibo.org.uk/u/system)
#### Post date: [March 4, 2020, 5:07pm UTC](https://community.xibo.org.uk/t/is-myphpadmin-installed-from-docker-import-questions/10230/18 "2020-03-04T17:07:40Z")