Witajcie
Nie wiem jak to przyszlo ale po ktorejs z kolejnych aktualizacji
zostala mi w bazie tabela customermailsview, byc moze wlasnie
przy aktualizacji do 1.11.17.
Przez to nie przechodzi do konca pelny mysqldump bazy,
nie idzie nawet wyswietlic jej zawartosci.
I teraz spogladajac na schemat czystej bazy do wersji 1.11.17
nie widze tam wogole tej tabeli.
Czy w zwiazku z tym moge ja poprostu usunac z bazy? Nie wiem
co tam siedzi i czy napewno jest niepotrzebna wiec prosze o
porade zebym sobie nie strzelil w kolano :)
mysql>SELECT * FROM customermailsview;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> select * from customermailsview' at line 1
mysql>
mysql>REPAIR TABLE customermailsview;
+-----------------------+--------+----------+-------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------------+--------+----------+-------------------------------------------+
| lms.customermailsview | repair | Error | 'lms.customermailsview' is not BASE TABLE |
| lms.customermailsview | repair | error | Corrupt |
+-----------------------+--------+----------+-------------------------------------------+
2 rows in set (0.00 sec)
mysql>
mysql> SHOW TABLES;
+-----------------------+
| Tables_in_lms |
+-----------------------+
| aliasassignments |
| aliases |
| assignments |
| cash |
| cashimport |
| cashreglog |
| cashregs |
| cashrights |
| cashsources |
| contractorview |
| countries |
| customerassignments |
| customercontacts |
| customergroups |
| customermailsview |
| customers |
| customersview |
| daemonconfig |
| daemoninstances |
| dbinfo |
| debitnotecontents |
| divisions |
| docrights |
| documentcontents |
| documents |
| domains |
| eventassignments |
| events |
| ewx_channels |
| ewx_pt_config |
| ewx_stm_channels |
| ewx_stm_nodes |
| excludedgroups |
| hosts |
| imessengers |
| invoicecontents |
| invprojects |
| liabilities |
| location_boroughs |
| location_cities |
| location_districts |
| location_states |
| location_street_types |
| location_streets |
| logmessagedata |
| logmessagekeys |
| logmessages |
| logtransactions |
| macs |
| managementurls |
| messageitems |
| messages |
| nas |
| nastypes |
| netdevicemodels |
| netdeviceproducers |
| netdevices |
| netlinks |
| netnodes |
| netradiosectors |
| networks |
| nodeassignments |
| nodegroupassignments |
| nodegroups |
| nodelocks |
| nodes |
| nodesessions |
| numberplanassignments |
| numberplans |
| passwd |
| payments |
| pna |
| promotionassignments |
| promotions |
| promotionschemas |
| radreply |
| receiptcontents |
| records |
| rtattachments |
| rtcategories |
| rtcategoryusers |
| rtmessages |
| rtnotes |
| rtqueues |
| rtrights |
| rtticketcategories |
| rttickets |
| sessions |
| sourcefiles |
| states |
| stats |
| supermasters |
| tariffs |
| taxes |
| templates |
| teryt_simc |
| teryt_terc |
| teryt_ulic |
| uiconfig |
| up_customers |
| up_help |
| up_info_changes |
| up_rights |
| up_rights_assignments |
| users |
| vmacs |
| vnodes |
| vnodes_mac |
| voipaccounts |
| zipcodes |
+-----------------------+
110 rows in set (0.00 sec)
mysql>
Ponadto mysqlcheck przechodzi przez baze lms bez problemu ale nie wyswietla
wogole tej tabeli:
# mysqlcheck -c lms -u root -p
Enter password:
lms.aliasassignments OK
lms.aliases OK
lms.assignments OK
lms.cash OK
lms.cashimport OK
lms.cashreglog OK
lms.cashregs OK
lms.cashrights OK
lms.cashsources OK
lms.countries OK
lms.customerassignments OK
lms.customercontacts OK
lms.customergroups OK
lms.customers OK
lms.daemonconfig OK
lms.daemoninstances OK
lms.dbinfo OK
lms.debitnotecontents OK
lms.divisions OK
lms.docrights OK
lms.documentcontents OK
lms.documents OK
lms.domains OK
lms.eventassignments OK
lms.events OK
lms.ewx_channels OK
lms.ewx_pt_config OK
lms.ewx_stm_channels OK
lms.ewx_stm_nodes OK
lms.excludedgroups OK
lms.hosts OK
lms.imessengers OK
lms.invoicecontents OK
lms.invprojects OK
lms.liabilities OK
lms.location_boroughs OK
lms.location_cities OK
lms.location_districts OK
lms.location_states OK
lms.location_street_types OK
lms.location_streets OK
lms.logmessagedata OK
lms.logmessagekeys OK
lms.logmessages OK
lms.logtransactions OK
lms.macs OK
lms.managementurls OK
lms.messageitems OK
lms.messages OK
lms.nastypes OK
lms.netdevicemodels OK
lms.netdeviceproducers OK
lms.netdevices OK
lms.netlinks OK
lms.netnodes OK
lms.netradiosectors OK
lms.networks OK
lms.nodeassignments OK
lms.nodegroupassignments OK
lms.nodegroups OK
lms.nodelocks OK
lms.nodes OK
lms.nodesessions OK
lms.numberplanassignments OK
lms.numberplans OK
lms.passwd OK
lms.payments OK
lms.pna OK
lms.promotionassignments OK
lms.promotions OK
lms.promotionschemas OK
lms.radreply OK
lms.receiptcontents OK
lms.records OK
lms.rtattachments OK
lms.rtcategories OK
lms.rtcategoryusers OK
lms.rtmessages OK
lms.rtnotes OK
lms.rtqueues OK
lms.rtrights OK
lms.rtticketcategories OK
lms.rttickets OK
lms.sessions OK
lms.sourcefiles OK
lms.states OK
lms.stats OK
lms.supermasters OK
lms.tariffs OK
lms.taxes OK
lms.templates OK
lms.uiconfig OK
lms.up_customers OK
lms.up_help OK
lms.up_info_changes OK
lms.up_rights OK
lms.up_rights_assignments OK
lms.users OK
lms.voipaccounts OK
lms.zipcodes OK
#
Z gory dziekuje za odpowiedzi i przepraszam za tak dlugie wklejki
pozdrawiam
Tomek