Answer the question
In order to leave comments, you need to log in
How to restore mysql database table from backup?
I try several times to restore the database table, but nothing comes up
[email protected]:/home/fapchat/Desktop/papka/backups of mysql# mysql -u fapchat -p1111 -D publications < accounts.sql
MariaDB [publications]> describe accounts;
ERROR 1146 (42S02): Table 'publications.accounts' doesn't exist
Answer the question
In order to leave comments, you need to log in
The table already exists.
Rename it and roll the dump.
Think about whether you need data from the old one?
Need - somehow smerzhi data and delete the old one.
No - delete the old one immediately.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question