#1033 - incorrect information in file account/account frm - nustiu cum se poate rezolva asa ceva..am facut update la mysql si am dat reparare la tabele...

Incorrect information e, de obicei, cand ai alta versiune de mysql fata de cea care trebuie.... Probabil nu ai facut update cum trebuie.

Da-i " mysql --version " si vezi ce versiune ai, s-ar putea sa ai 5.5 si sa trebuiasca sa instalezi 5.6

SkyLine scrie: ↑07 Feb 2022, 12:01 Incorrect information e, de obicei, cand ai alta versiune de mysql fata de cea care trebuie.... Probabil nu ai facut update cum trebuie.

Da-i " mysql --version " si vezi ce versiune ai, s-ar putea sa ai 5.5 si sa trebuiasca sa instalezi 5.6

corect - Ver 14.14 Distrib 5.5.62, cum instalez 5.6 ?

[TC] Neseriosul scrie: ↑07 Feb 2022, 12:03

SkyLine scrie: ↑07 Feb 2022, 12:01 Incorrect information e, de obicei, cand ai alta versiune de mysql fata de cea care trebuie.... Probabil nu ai facut update cum trebuie.

Da-i " mysql --version " si vezi ce versiune ai, s-ar putea sa ai 5.5 si sa trebuiasca sa instalezi 5.6

corect - Ver 14.14 Distrib 5.5.62, cum instalez 5.6 ?

eroare...

- cuvant ascuns - scrie: ↑07 Feb 2022, 12:08 pkg info -r mysql55-client - vezi versiunea de 5.5
pkg delete -f VERSIUNE - schimbi versiunea cu ce ti-a aratat mai sus
pkg install -f mysql56-server - asta iti instaleaza 5.6

pkg: http://pkg.FreeBSD.org/FreeBSD:11:i386/ ... 5.6.48.txz: Not Found - primesc aceasta eroare..

[TC] Neseriosul scrie: ↑07 Feb 2022, 12:10

- cuvant ascuns - scrie: ↑07 Feb 2022, 12:08 pkg info -r mysql55-client - vezi versiunea de 5.5
pkg delete -f VERSIUNE - schimbi versiunea cu ce ti-a aratat mai sus
pkg install -f mysql56-server - asta iti instaleaza 5.6

pkg: http://pkg.FreeBSD.org/FreeBSD:11:i386/ ... 5.6.48.txz: Not Found - primesc aceasta eroare..

220207 12:14:28 InnoDB: The InnoDB memory heap is disabled
220207 12:14:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
220207 12:14:28 InnoDB: Compressed tables use zlib 1.2.11
220207 12:14:28 InnoDB: Initializing buffer pool, size = 128.0M
220207 12:14:28 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
220207 12:14:28 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
220207 12:14:28 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
220207 12:14:28 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
220207 12:14:28 InnoDB: Waiting for the background threads to start
220207 12:14:29 InnoDB: 5.5.62 started; log sequence number 0
220207 12:14:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
220207 12:14:29 [Note] - '0.0.0.0' resolves to '0.0.0.0';
220207 12:14:29 [Note] Server socket created on IP: '0.0.0.0'.
220207 12:14:29 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
220207 12:14:29 [ERROR] Do you already have another mysqld server running on port: 3306 ?
220207 12:14:29 [ERROR] Aborting

220207 12:14:29 InnoDB: Starting shutdown...
220207 12:14:30 InnoDB: Shutdown completed; log sequence number 1595675
220207 12:14:30 [Note] /usr/local/libexec/mysqld: Shutdown complete

[TC] Neseriosul scrie: ↑07 Feb 2022, 12:10

- cuvant ascuns - scrie: ↑07 Feb 2022, 12:08 pkg info -r mysql55-client - vezi versiunea de 5.5
pkg delete -f VERSIUNE - schimbi versiunea cu ce ti-a aratat mai sus
pkg install -f mysql56-server - asta iti instaleaza 5.6

pkg: http://pkg.FreeBSD.org/FreeBSD:11:i386/ ... 5.6.48.txz: Not Found - primesc aceasta eroare..

pkg delete mysql55-server, astepti .. pkg install mysql56-server

SkyLine scrie: ↑07 Feb 2022, 14:33

[TC] Neseriosul scrie: ↑07 Feb 2022, 12:10

- cuvant ascuns - scrie: ↑07 Feb 2022, 12:08 pkg info -r mysql55-client - vezi versiunea de 5.5
pkg delete -f VERSIUNE - schimbi versiunea cu ce ti-a aratat mai sus
pkg install -f mysql56-server - asta iti instaleaza 5.6

pkg: http://pkg.FreeBSD.org/FreeBSD:11:i386/ ... 5.6.48.txz: Not Found - primesc aceasta eroare..

pkg delete mysql55-server, astepti .. pkg install mysql56-server

am rezolvat multumesc mult !

Mutat in Probleme Rezolvate.