Skip to content

backup with docker commit #140

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
AdminJack opened this issue Feb 10, 2016 · 1 comment
Closed

backup with docker commit #140

AdminJack opened this issue Feb 10, 2016 · 1 comment

Comments

@AdminJack
Copy link

Hey,

same Issue: #44

I have a Mysql Container and had make Backups commit 9ab983629feb owncloud:7.

Today I have delete my Container with docker rm.

Result: Every time when the new image starts, it will execute /tmp/mysql-first-time.sql and so the data is removed. (#44)

My Log:

$ sudo docker run -it --name owncloud-mysql-test -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_DATABASE=owncloud -e MYSQL_USER=owncloud -e MYSQL_PASSWORD=pass
Running mysql_install_db
2016-02-11 06:32:59 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27) starting as process 16 ...
2016-02-11 06:32:59 16 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-11 06:32:59 16 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-11 06:32:59 16 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-02-11 06:32:59 16 [Note] InnoDB: Memory barrier is not used
2016-02-11 06:32:59 16 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-02-11 06:32:59 16 [Note] InnoDB: Using Linux native AIO
2016-02-11 06:32:59 16 [Note] InnoDB: Using CPU crc32 instructions
2016-02-11 06:32:59 16 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-11 06:32:59 16 [Note] InnoDB: Completed initialization of buffer pool
2016-02-11 06:32:59 16 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2016-02-11 06:32:59 16 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2016-02-11 06:32:59 16 [Note] InnoDB: Database physically writes the file full: wait...
2016-02-11 06:32:59 16 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2016-02-11 06:32:59 16 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2016-02-11 06:33:00 16 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2016-02-11 06:33:00 16 [Warning] InnoDB: New log files created, LSN=45781
2016-02-11 06:33:00 16 [Note] InnoDB: Doublewrite buffer not found: creating new
2016-02-11 06:33:00 16 [Note] InnoDB: Doublewrite buffer created
2016-02-11 06:33:00 16 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-11 06:33:00 16 [Warning] InnoDB: Creating foreign key constraint system tables.
2016-02-11 06:33:00 16 [Note] InnoDB: Foreign key constraint system tables created
2016-02-11 06:33:00 16 [Note] InnoDB: Creating tablespace and datafile system tables.
2016-02-11 06:33:00 16 [Note] InnoDB: Tablespace and datafile system tables created.
2016-02-11 06:33:00 16 [Note] InnoDB: Waiting for purge to start
2016-02-11 06:33:00 16 [Note] InnoDB: 5.6.27 started; log sequence number 0
2016-02-11 06:33:00 16 [Note] Binlog end
2016-02-11 06:33:00 16 [Note] InnoDB: FTS optimize thread exiting.
2016-02-11 06:33:00 16 [Note] InnoDB: Starting shutdown...
2016-02-11 06:33:02 16 [Note] InnoDB: Shutdown completed; log sequence number 1625977


2016-02-11 06:33:02 0 [Note] /usr/sbin/mysqld (mysqld 5.6.27) starting as process 39 ...
2016-02-11 06:33:02 39 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-11 06:33:02 39 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-11 06:33:02 39 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-02-11 06:33:02 39 [Note] InnoDB: Memory barrier is not used
2016-02-11 06:33:02 39 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-02-11 06:33:02 39 [Note] InnoDB: Using Linux native AIO
2016-02-11 06:33:02 39 [Note] InnoDB: Using CPU crc32 instructions
2016-02-11 06:33:02 39 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-11 06:33:02 39 [Note] InnoDB: Completed initialization of buffer pool
2016-02-11 06:33:02 39 [Note] InnoDB: Highest supported file format is Barracuda.
2016-02-11 06:33:02 39 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-11 06:33:02 39 [Note] InnoDB: Waiting for purge to start
2016-02-11 06:33:02 39 [Note] InnoDB: 5.6.27 started; log sequence number 1625977
2016-02-11 06:33:02 39 [Note] Binlog end
2016-02-11 06:33:02 39 [Note] InnoDB: FTS optimize thread exiting.
2016-02-11 06:33:02 39 [Note] InnoDB: Starting shutdown...
2016-02-11 06:33:04 39 [Note] InnoDB: Shutdown completed; log sequence number 1625987




PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

  /usr/bin/mysqladmin -u root password 'new-password'
  /usr/bin/mysqladmin -u root -h ae0e4f8022c2 password 'new-password'

Alternatively you can run:

  /usr/bin/mysql_secure_installation

which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.

See the manual for more instructions.

Please report any problems at http://bugs.mysql.com/

The latest information about MySQL is available on the web at

  http://www.mysql.com

Support MySQL by buying support/licenses at http://shop.mysql.com

Note: new default config file not created.
Please make sure your config file is current

WARNING: Default config file /etc/mysql/my.cnf exists on the system
This file will be read by default by the MySQL server
If you do not want to use this, either remove it, or use the
--defaults-file argument to mysqld_safe when starting the server

Finished mysql_install_db
MySQL init process in progress...
2016-02-11 06:33:05 0 [Note] mysqld (mysqld 5.6.27) starting as process 62 ...
2016-02-11 06:33:05 62 [Note] Plugin 'FEDERATED' is disabled.
2016-02-11 06:33:05 62 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-11 06:33:05 62 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-11 06:33:05 62 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-02-11 06:33:05 62 [Note] InnoDB: Memory barrier is not used
2016-02-11 06:33:05 62 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-02-11 06:33:05 62 [Note] InnoDB: Using Linux native AIO
2016-02-11 06:33:05 62 [Note] InnoDB: Using CPU crc32 instructions
2016-02-11 06:33:05 62 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-11 06:33:05 62 [Note] InnoDB: Completed initialization of buffer pool
2016-02-11 06:33:05 62 [Note] InnoDB: Highest supported file format is Barracuda.
MySQL init process in progress...
2016-02-11 06:33:05 62 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-11 06:33:05 62 [Note] InnoDB: Waiting for purge to start
2016-02-11 06:33:05 62 [Note] InnoDB: 5.6.27 started; log sequence number 1625987
2016-02-11 06:33:05 62 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 4ed123d6-d089-11e5-9d5b-0242ac110006.
2016-02-11 06:33:05 62 [Warning] 'user' entry 'root@ae0e4f8022c2' ignored in --skip-name-resolve mode.
2016-02-11 06:33:05 62 [Warning] 'user' entry '@ae0e4f8022c2' ignored in --skip-name-resolve mode.
2016-02-11 06:33:05 62 [Warning] 'proxies_priv' entry '@ root@ae0e4f8022c2' ignored in --skip-name-resolve mode.
2016-02-11 06:33:05 62 [Note] Event Scheduler: Loaded 0 events
2016-02-11 06:33:05 62 [Note] mysqld: ready for connections.
Version: '5.6.27'  socket: '/var/run/mysqld/mysqld.sock'  port: 0  MySQL Community Server (GPL)
Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
2016-02-11 06:33:09 62 [Warning] 'proxies_priv' entry '@ root@ae0e4f8022c2' ignored in --skip-name-resolve mode.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
Warning: Using a password on the command line interface can be insecure.
2016-02-11 06:33:09 62 [Warning] 'proxies_priv' entry '@ root@ae0e4f8022c2' ignored in --skip-name-resolve mode.

/entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

2016-02-11 06:33:09 62 [Note] mysqld: Normal shutdown

2016-02-11 06:33:09 62 [Note] Giving 0 client threads a chance to die gracefully
2016-02-11 06:33:09 62 [Note] Event Scheduler: Purging the queue. 0 events
2016-02-11 06:33:09 62 [Note] Shutting down slave threads
2016-02-11 06:33:09 62 [Note] Forcefully disconnecting 0 remaining clients
2016-02-11 06:33:09 62 [Note] Binlog end
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'partition'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_METRICS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_CMP'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'INNODB_TRX'
2016-02-11 06:33:09 62 [Note] Shutting down plugin 'InnoDB'
2016-02-11 06:33:09 62 [Note] InnoDB: FTS optimize thread exiting.
2016-02-11 06:33:09 62 [Note] InnoDB: Starting shutdown...
2016-02-11 06:33:10 62 [Note] InnoDB: Shutdown completed; log sequence number 1625997
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'ARCHIVE'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'BLACKHOLE'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'CSV'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'MEMORY'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'MyISAM'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'MRG_MYISAM'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'sha256_password'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'mysql_old_password'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'mysql_native_password'
2016-02-11 06:33:10 62 [Note] Shutting down plugin 'binlog'
2016-02-11 06:33:10 62 [Note] mysqld: Shutdown complete


MySQL init process done. Ready for start up.

2016-02-11 06:33:10 0 [Note] mysqld (mysqld 5.6.27) starting as process 1 ...
2016-02-11 06:33:10 1 [Note] Plugin 'FEDERATED' is disabled.
2016-02-11 06:33:10 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-02-11 06:33:10 1 [Note] InnoDB: The InnoDB memory heap is disabled
2016-02-11 06:33:10 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-02-11 06:33:10 1 [Note] InnoDB: Memory barrier is not used
2016-02-11 06:33:10 1 [Note] InnoDB: Compressed tables use zlib 1.2.8
2016-02-11 06:33:10 1 [Note] InnoDB: Using Linux native AIO
2016-02-11 06:33:10 1 [Note] InnoDB: Using CPU crc32 instructions
2016-02-11 06:33:10 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-02-11 06:33:10 1 [Note] InnoDB: Completed initialization of buffer pool
2016-02-11 06:33:10 1 [Note] InnoDB: Highest supported file format is Barracuda.
2016-02-11 06:33:10 1 [Note] InnoDB: 128 rollback segment(s) are active.
2016-02-11 06:33:10 1 [Note] InnoDB: Waiting for purge to start
2016-02-11 06:33:10 1 [Note] InnoDB: 5.6.27 started; log sequence number 1625997
2016-02-11 06:33:10 1 [Note] Server hostname (bind-address): '*'; port: 3306
2016-02-11 06:33:10 1 [Note] IPv6 is available.
2016-02-11 06:33:10 1 [Note]   - '::' resolves to '::';
2016-02-11 06:33:10 1 [Note] Server socket created on IP: '::'.
2016-02-11 06:33:10 1 [Warning] 'proxies_priv' entry '@ root@ae0e4f8022c2' ignored in --skip-name-resolve mode.
2016-02-11 06:33:10 1 [Note] Event Scheduler: Loaded 0 events
2016-02-11 06:33:10 1 [Note] mysqld: ready for connections.
Version: '5.6.27'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)

What can I do?
undocker didn't works.

King regards
@AdminJack AdminJack reopened this Feb 11, 2016
@AdminJack
Copy link
Author

Okay, I have understand: http://stackoverflow.com/a/30745501

My data are gone.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@AdminJack