Код: Выделить всё
mysql --default-character-set=utf8 -p -D abills < backup.sql
Код: Выделить всё
ERROR 1146 (42S02) at line 38: Table 'abills.abon_tariffs' doesn't exist
Посмотрел, такой таблички действительно , ее надо отдельно создавать?Создаём пользователя и базу.
# mysql --default-character-set=utf8 -u root -p
use mysql;
INSERT INTO user (Host, User, Password)
VALUES ('localhost','abills', password('sqlpassword'));
INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv,
Delete_priv, Create_priv, Drop_priv, Index_priv, Alter_priv,
Lock_tables_priv, Create_tmp_table_priv, Create_view_priv,
Show_view_priv, Execute_priv)
VALUES ('localhost', 'abills', 'abills', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
CREATE DATABASE abills DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
flush privileges;
Подскажите, что исправить?
Tables_in_abills |
+-------------------------------+
| admin_actions |
| admin_permits |
| admin_system_actions |
| admins |
| admins_allow_ips |
| admins_groups |
| bills |
| builds |
| companie_admins |
| companies |
| config |
| districts |
| docs_acts |
| docs_invoice2payments |
| docs_invoice_orders |
| docs_invoices |
| docs_main |
| docs_receipt_orders |
| docs_receipts |
| docs_tax_invoice_orders |
| docs_tax_invoices |
| domains |
| dv_calls |
| dv_log |
| dv_log_intervals |
| dv_main |
| errors_log |
| exchange_rate |
| exchange_rate_log |
| fees |
| fees_types |
| filters |
| groups |
| help |
| holidays |
| intervals |
| ippools |
| mail_access |
| mail_aliases |
| mail_boxes |
| mail_domains |
| msgs_admins |
| msgs_attachments |
| msgs_chapters |
| msgs_dispatch |
| msgs_dispatch_admins |
| msgs_messages |
| msgs_reply |
| msgs_survey_answers |
| msgs_survey_questions |
| msgs_survey_subjects |
| msgs_unreg_requests |
| nas |
| nas_groups |
| nas_ippools |
| netflow_address |
| networks |
| payments |
| reg_wizard |
| s_detail |
| shedule |
| sqlcmd_history |
| streets |
| tarif_plans |
| tp_bonus_rating |
| tp_groups |
| tp_nas |
| traffic_classes |
| trafic_tarifs |
| users |
| users_bruteforce |
| users_nas |
| users_pi |
| voip_calls |
| voip_log |
| voip_main |
| voip_route_extra_tarification |
| voip_route_groups |
| voip_route_prices |
| voip_routes |
| voip_tps |
| voip_trunks |
| web_online |
| web_users_sessions |
+-------------------------------+