*Problemă/Întrebare:Cum pot sa adaug un fisier .sql ?
Tipologie server:PVM
*Resursă folosită: ht tps: // just4metin . ro /altele/vip-system-onex-free-t53483 . html
*ServerFiles utilizat: clever1
*Syserr: -
Poză: -
*Detalii suplimentare: Am incercat cu execute, tabelul se sterge dupa reboot, am incercat si \. in putty, la fel. Nu am gasit nimic asemanator pe forum.
Aici aveti fisierul .sql: htt ps: //mega . nz/file/5t5SxSQR#5CwFDEEmsUuwKp3bhuXYrtv0yGFJFgTLUyqkUNaDBFM
Problema SQL
intra in cd /var/db si vezi ce zice fisierul ala .err nu cumva spune ca tu ai mysql56 / 55 si sql ala e facut pe altfel de mysql? si daia nu iti salveaza datele?
Asta este tot ce am in /var/dblotryy1995 scrie: ↑04 Mai 2020, 10:12 intra in cd /var/db si vezi ce zice fisierul ala .err nu cumva spune ca tu ai mysql56 / 55 si sql ala e facut pe altfel de mysql? si daia nu iti salveaza datele?
/var/db/mysql
scrie in putty -> pkg install mysql56-server , apesi pe y pana se instaleaza , dai un reboot dupa incarci dinou fisierul .sql in mysql un reboot iar si vezi ce se intampla.
Am instalat pkg, am dat reboot, am dat execute la .sql, apare totul ok, dau reboot din nou, totul ok, pornesc si start.sh , scriu ceva in tabel, dau reboot si se sterge tot tabelullotryy1995 scrie: ↑04 Mai 2020, 10:30 scrie in putty -> pkg install mysql56-server , apesi pe y pana se instaleaza , dai un reboot dupa incarci dinou fisierul .sql in mysql un reboot iar si vezi ce se intampla.
Deschide te rog fisierul .err din /var/db/mysql si posteazal aici , vreau sa vad ceva
daca as avea vreunul, ti l-as da cu drag...lotryy1995 scrie: ↑04 Mai 2020, 10:46 Deschide te rog fisierul .err din /var/db/mysql si posteazal aici , vreau sa vad ceva
lotryy1995 scrie: ↑04 Mai 2020, 10:46 Deschide te rog fisierul .err din /var/db/mysql si posteazal aici , vreau sa vad ceva
Cod: Selectaţi tot
200504 15:47:59 mysqld_safe Logging to '/var/db/mysql/Clever-Host.ro.err'.
200504 15:47:59 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2020-05-04 15:48:04 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-04 15:48:04 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.41) starting as process 1889 ...
2020-05-04 15:48:04 1889 [Note] Plugin 'FEDERATED' is disabled.
2020-05-04 15:48:05 1889 [Note] InnoDB: Using atomics to ref count buffer pool pages
2020-05-04 15:48:05 1889 [Note] InnoDB: The InnoDB memory heap is disabled
2020-05-04 15:48:05 1889 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-04 15:48:05 1889 [Note] InnoDB: Memory barrier is not used
2020-05-04 15:48:05 1889 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-04 15:48:05 1889 [Note] InnoDB: Using CPU crc32 instructions
2020-05-04 15:48:05 1889 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2020-05-04 15:48:05 1889 [Note] InnoDB: Completed initialization of buffer pool
2020-05-04 15:48:05 1889 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2020-05-04 15:48:05 1889 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2020-05-04 15:48:05 1889 [Note] InnoDB: Database physically writes the file full: wait...
2020-05-04 15:48:05 1889 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2020-05-04 15:48:05 1889 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2020-05-04 15:48:05 1889 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2020-05-04 15:48:05 1889 [Warning] InnoDB: New log files created, LSN=45781
2020-05-04 15:48:05 1889 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-05-04 15:48:05 1889 [Note] InnoDB: Doublewrite buffer created
2020-05-04 15:48:05 1889 [Note] InnoDB: 128 rollback segment(s) are active.
2020-05-04 15:48:05 1889 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-05-04 15:48:05 1889 [Note] InnoDB: Foreign key constraint system tables created
2020-05-04 15:48:05 1889 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-05-04 15:48:05 1889 [Note] InnoDB: Tablespace and datafile system tables created.
2020-05-04 15:48:05 1889 [Note] InnoDB: Waiting for purge to start
2020-05-04 15:48:05 1889 [Note] InnoDB: 5.6.41 started; log sequence number 0
2020-05-04 15:48:06 1889 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2020-05-04 15:48:06 1889 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2020-05-04 15:48:06 1889 [Note] Server hostname (bind-address): '*'; port: 3306
2020-05-04 15:48:06 1889 [Note] IPv6 is available.
2020-05-04 15:48:06 1889 [Note] - '::' resolves to '::';
2020-05-04 15:48:06 1889 [Note] Server socket created on IP: '::'.
2020-05-04 15:48:06 1889 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2020-05-04 15:48:06 1889 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2020-05-04 15:48:06 1889 [ERROR] Aborting
2020-05-04 15:48:06 1889 [Note] Binlog end
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'partition'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_METRICS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_CMP'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'INNODB_TRX'
2020-05-04 15:48:06 1889 [Note] Shutting down plugin 'InnoDB'
2020-05-04 15:48:06 1889 [Note] InnoDB: FTS optimize thread exiting.
2020-05-04 15:48:06 1889 [Note] InnoDB: Starting shutdown...
2020-05-04 15:48:07 1889 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'BLACKHOLE'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'ARCHIVE'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'MRG_MYISAM'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'MyISAM'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'MEMORY'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'CSV'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'sha256_password'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'mysql_old_password'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'mysql_native_password'
2020-05-04 15:48:07 1889 [Note] Shutting down plugin 'binlog'
2020-05-04 15:48:07 1889 [Note] /usr/local/libexec/mysqld: Shutdown complete
200504 15:48:07 mysqld_safe mysqld from pid file /var/db/mysql/Clever-Host.ro.pid ended
Răspunsuri
8 Vizualizări
1332
8 Vizualizări
1332
de
Răspunsuri
3 Vizualizări
431
3 Vizualizări
431
de
Răspunsuri
3 Vizualizări
411
3 Vizualizări
411
de
Răspunsuri
2 Vizualizări
317
2 Vizualizări
317
-
- Informaţie
-
Cine este conectat
Utilizatori ce ce navighează pe acest forum: Bing [Bot] și 12 vizitatori