Problema SQL

tonel.mahon · 04 Mai 2020, 10:10

*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

[MoșulWtfYoYo] · 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?

tonel.mahon · 04 Mai 2020, 10:23

lotryy1995 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?

Asta este tot ce am in /var/db Imagine

[MoșulWtfYoYo] · 04 Mai 2020, 10:25

/var/db/mysql

tonel.mahon · 04 Mai 2020, 10:27

lotryy1995 scrie: ↑04 Mai 2020, 10:25 /var/db/mysql

5.5.61 in fisierul mysql_upgrade_info

[MoșulWtfYoYo] · 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.

tonel.mahon · 04 Mai 2020, 10:44

lotryy1995 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.

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 tabelul

[MoșulWtfYoYo] · 04 Mai 2020, 10:46

Deschide te rog fisierul .err din /var/db/mysql si posteazal aici , vreau sa vad ceva

tonel.mahon · 04 Mai 2020, 10:50

lotryy1995 scrie: ↑04 Mai 2020, 10:46 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...
Imagine

tonel.mahon · 04 Mai 2020, 14:51

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

i-am dat de cap pana la urma si am gasit fisierul .err

Problema SQL

Problema adunare yang automat / Problema descriere item

PROBLEMA INVENTAR 3/4 - PROBLEMA SOSETE DE CRACIUN ( AS DORII SA SE STOCHEZE AUT

Problema experienta negativa la Metine + Problema Pet Azrael

Problema bug costum fata,problema pagina bonusuri..

Cine este conectat