F
F
fapchat2019-10-26 11:32:55
MySQL
fapchat, 2019-10-26 11:32:55

How to restore mysql database table from backup?

I try several times to restore the database table, but nothing comes up5db404402d22f662092629.png

[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

Database recovered normally

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Andrey, 2019-10-26
@VladimirAndreev

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.

R
Ruslan Fedoseev, 2019-10-26
@martin74ua

And what's in the file for 800 bytes then?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question