Hey there, I am new to local hosting and website creating so I’ll need your help…
I created a website on local and had an error message “Container missing”. So I created a new file for my local website (copied and pasted all files) and uploaded it again to local to flywheel. So I can access my website now, but my SQL file is missing so I have lost all my pages and design.
I have the following error message in /mysql - can anyone help me please and tell me what to do to get back my SQL file?
2017-10-16 15:43:51 22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-10-16 15:43:51 22 [Note] Plugin 'FEDERATED' is disabled.
2017-10-16 15:43:51 22 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-10-16 15:43:51 22 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-16 15:43:51 22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-16 15:43:51 22 [Note] InnoDB: Memory barrier is not used
2017-10-16 15:43:51 22 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-16 15:43:51 22 [Note] InnoDB: Using Linux native AIO
2017-10-16 15:43:51 22 [Note] InnoDB: Using CPU crc32 instructions
2017-10-16 15:43:51 22 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-10-16 15:43:51 22 [Note] InnoDB: Completed initialization of buffer pool
2017-10-16 15:43:51 22 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-16 15:43:51 22 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 1625997 in the ib_logfiles!
2017-10-16 15:43:51 22 [Note] InnoDB: Database was not shutdown normally!
2017-10-16 15:43:51 22 [Note] InnoDB: Starting crash recovery.
2017-10-16 15:43:51 22 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-10-16 15:43:51 22 [Note] InnoDB: Restoring possible half-written data pages
2017-10-16 15:43:51 22 [Note] InnoDB: from the doublewrite buffer...
2017-10-16 15:43:52 22 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-16 15:43:52 22 [Note] InnoDB: Waiting for purge to start
2017-10-16 15:43:52 22 [Note] InnoDB: 5.6.36 started; log sequence number 1625997
2017-10-16 15:43:52 22 [Note] Server hostname (bind-address): '*'; port: 3306
2017-10-16 15:43:52 22 [Note] IPv6 is available.
2017-10-16 15:43:52 22 [Note] - '::' resolves to '::';
2017-10-16 15:43:52 22 [Note] Server socket created on IP: '::'.
2017-10-16 15:43:52 22 [ERROR] /usr/sbin/mysqld: Table './mysql/user' is marked as crashed and should be repaired
2017-10-16 15:43:52 22 [Warning] Checking table: './mysql/user'
2017-10-16 15:43:52 22 [ERROR] 1 client is using or hasn't closed the table properly
2017-10-16 15:43:52 22 [Warning] 'user' entry 'root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-16 15:43:52 22 [Warning] 'user' entry '@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-16 15:43:52 22 [Warning] 'proxies_priv' entry '@ root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-16 15:43:52 22 [Note] Event Scheduler: Loaded 0 events
2017-10-16 15:43:52 22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.36' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2017-10-17 07:54:08 22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-10-17 07:54:08 22 [Note] Plugin 'FEDERATED' is disabled.
2017-10-17 07:54:08 22 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-10-17 07:54:08 22 [Note] InnoDB: The InnoDB memory heap is disabled
2017-10-17 07:54:08 22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-10-17 07:54:08 22 [Note] InnoDB: Memory barrier is not used
2017-10-17 07:54:08 22 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-10-17 07:54:08 22 [Note] InnoDB: Using Linux native AIO
2017-10-17 07:54:08 22 [Note] InnoDB: Using CPU crc32 instructions
2017-10-17 07:54:08 22 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-10-17 07:54:08 22 [Note] InnoDB: Completed initialization of buffer pool
2017-10-17 07:54:08 22 [Note] InnoDB: Highest supported file format is Barracuda.
2017-10-17 07:54:08 22 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 2391353 in the ib_logfiles!
2017-10-17 07:54:08 22 [Note] InnoDB: Database was not shutdown normally!
2017-10-17 07:54:08 22 [Note] InnoDB: Starting crash recovery.
2017-10-17 07:54:08 22 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-10-17 07:54:08 22 [Note] InnoDB: Restoring possible half-written data pages
2017-10-17 07:54:08 22 [Note] InnoDB: from the doublewrite buffer...
2017-10-17 07:54:09 22 [Note] InnoDB: 128 rollback segment(s) are active.
2017-10-17 07:54:09 22 [Note] InnoDB: Waiting for purge to start
2017-10-17 07:54:09 22 [Note] InnoDB: 5.6.36 started; log sequence number 2391353
2017-10-17 07:54:09 22 [Note] Server hostname (bind-address): '*'; port: 3306
2017-10-17 07:54:09 22 [Note] IPv6 is available.
2017-10-17 07:54:09 22 [Note] - '::' resolves to '::';
2017-10-17 07:54:09 22 [Note] Server socket created on IP: '::'.
2017-10-17 07:54:09 22 [Warning] 'user' entry 'root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-17 07:54:09 22 [Warning] 'user' entry '@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-17 07:54:09 22 [Warning] 'proxies_priv' entry '@ root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-10-17 07:54:09 22 [Note] Event Scheduler: Loaded 0 events
2017-10-17 07:54:09 22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.36' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2017-11-06 09:43:33 22 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-11-06 09:43:33 22 [Note] Plugin 'FEDERATED' is disabled.
2017-11-06 09:43:33 22 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-11-06 09:43:33 22 [Note] InnoDB: The InnoDB memory heap is disabled
2017-11-06 09:43:33 22 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-06 09:43:33 22 [Note] InnoDB: Memory barrier is not used
2017-11-06 09:43:33 22 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-11-06 09:43:33 22 [Note] InnoDB: Using Linux native AIO
2017-11-06 09:43:33 22 [Note] InnoDB: Using CPU crc32 instructions
2017-11-06 09:43:33 22 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-11-06 09:43:33 22 [Note] InnoDB: Completed initialization of buffer pool
2017-11-06 09:43:33 22 [Note] InnoDB: Highest supported file format is Barracuda.
2017-11-06 09:43:33 22 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 11113541 in the ib_logfiles!
2017-11-06 09:43:33 22 [Note] InnoDB: Database was not shutdown normally!
2017-11-06 09:43:33 22 [Note] InnoDB: Starting crash recovery.
2017-11-06 09:43:33 22 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-11-06 09:43:33 22 [Note] InnoDB: Restoring possible half-written data pages
2017-11-06 09:43:33 22 [Note] InnoDB: from the doublewrite buffer...
2017-11-06 09:43:34 22 [Note] InnoDB: 128 rollback segment(s) are active.
2017-11-06 09:43:34 22 [Note] InnoDB: Waiting for purge to start
2017-11-06 09:43:34 22 [Note] InnoDB: 5.6.36 started; log sequence number 11113541
2017-11-06 09:43:34 22 [Note] Server hostname (bind-address): '*'; port: 3306
2017-11-06 09:43:34 22 [Note] IPv6 is available.
2017-11-06 09:43:34 22 [Note] - '::' resolves to '::';
2017-11-06 09:43:34 22 [Note] Server socket created on IP: '::'.
2017-11-06 09:43:34 22 [Warning] 'user' entry 'root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-06 09:43:34 22 [Warning] 'user' entry '@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-06 09:43:34 22 [Warning] 'proxies_priv' entry '@ root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-06 09:43:34 22 [Note] Event Scheduler: Loaded 0 events
2017-11-06 09:43:34 22 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.36' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2017-11-14 11:36:09 21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-11-14 11:36:09 21 [Note] Plugin 'FEDERATED' is disabled.
2017-11-14 11:36:09 21 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-11-14 11:36:09 21 [Note] InnoDB: The InnoDB memory heap is disabled
2017-11-14 11:36:09 21 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-14 11:36:09 21 [Note] InnoDB: Memory barrier is not used
2017-11-14 11:36:09 21 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-11-14 11:36:09 21 [Note] InnoDB: Using Linux native AIO
2017-11-14 11:36:09 21 [Note] InnoDB: Using CPU crc32 instructions
2017-11-14 11:36:09 21 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-11-14 11:36:09 21 [Note] InnoDB: Completed initialization of buffer pool
2017-11-14 11:36:09 21 [Note] InnoDB: Highest supported file format is Barracuda.
2017-11-14 11:36:09 21 [Note] InnoDB: The log sequence numbers 1625987 and 1625987 in ibdata files do not match the log sequence number 44379204 in the ib_logfiles!
2017-11-14 11:36:09 21 [Note] InnoDB: Database was not shutdown normally!
2017-11-14 11:36:09 21 [Note] InnoDB: Starting crash recovery.
2017-11-14 11:36:09 21 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-11-14 11:36:09 21 [Note] InnoDB: Restoring possible half-written data pages
2017-11-14 11:36:09 21 [Note] InnoDB: from the doublewrite buffer...
2017-11-14 11:36:09 21 [Note] InnoDB: 128 rollback segment(s) are active.
2017-11-14 11:36:09 21 [Note] InnoDB: Waiting for purge to start
2017-11-14 11:36:09 21 [Note] InnoDB: 5.6.36 started; log sequence number 44379204
2017-11-14 11:36:09 21 [Note] Server hostname (bind-address): '*'; port: 3306
2017-11-14 11:36:09 21 [Note] IPv6 is available.
2017-11-14 11:36:09 21 [Note] - '::' resolves to '::';
2017-11-14 11:36:09 21 [Note] Server socket created on IP: '::'.
2017-11-14 11:36:09 21 [Warning] 'user' entry 'root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-14 11:36:09 21 [Warning] 'user' entry '@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-14 11:36:09 21 [Warning] 'proxies_priv' entry '@ root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-14 11:36:09 21 [Note] Event Scheduler: Loaded 0 events
2017-11-14 11:36:09 21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.36' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2017-11-20 10:04:32 21 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
2017-11-20 10:04:32 21 [Note] Plugin 'FEDERATED' is disabled.
2017-11-20 10:04:32 21 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-11-20 10:04:32 21 [Note] InnoDB: The InnoDB memory heap is disabled
2017-11-20 10:04:32 21 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-11-20 10:04:32 21 [Note] InnoDB: Memory barrier is not used
2017-11-20 10:04:32 21 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-11-20 10:04:32 21 [Note] InnoDB: Using Linux native AIO
2017-11-20 10:04:32 21 [Note] InnoDB: Using CPU crc32 instructions
2017-11-20 10:04:32 21 [Note] InnoDB: Initializing buffer pool, size = 8.0M
2017-11-20 10:04:32 21 [Note] InnoDB: Completed initialization of buffer pool
2017-11-20 10:04:32 21 [Note] InnoDB: Highest supported file format is Barracuda.
2017-11-20 10:04:32 21 [Note] InnoDB: 128 rollback segment(s) are active.
2017-11-20 10:04:32 21 [Note] InnoDB: Waiting for purge to start
2017-11-20 10:04:32 21 [Note] InnoDB: 5.6.36 started; log sequence number 2400739
2017-11-20 10:04:32 21 [Note] Server hostname (bind-address): '*'; port: 3306
2017-11-20 10:04:32 21 [Note] IPv6 is available.
2017-11-20 10:04:32 21 [Note] - '::' resolves to '::';
2017-11-20 10:04:32 21 [Note] Server socket created on IP: '::'.
2017-11-20 10:04:32 21 [Warning] 'user' entry 'root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-20 10:04:32 21 [Warning] 'user' entry '@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-20 10:04:32 21 [Warning] 'proxies_priv' entry '@ root@607924cbbc93' ignored in --skip-name-resolve mode.
2017-11-20 10:04:33 21 [Note] Event Scheduler: Loaded 0 events
2017-11-20 10:04:33 21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.36' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)