Reload all my MySQL tables
Trying to set up phpMyAdmin I seem to have deleted all tables in my database: allstudentsdb
The database allstudentsdb is still there, but empty.
Good news: the tables were all saved in /var/tmp/phpmyadmin.allstudentsdb.2020-06-26-09.36.mysql.UilgXQ.
After installing I could not get phpMyAdmin to start, so I ran:
sudo dpkg-reconfigure phpmyadmin
I think that wiped out my tables.
How do I get my tables back?
EDIT: I fixed it! I always think these things are too difficult for me, but after searching and reading a MySQL tutorial, I manage to restore the tables as root, then logged in as my mysqluser, and they are all back! I have never done this before, so it's all new.
Sorry to have troubled you!
1 ответ
Чтобы переустановить базу данных mysql:
(сделать это как root)
mysql>source /path/to/backup/mydb.sql
phpMyAdmin действительно сообщил мне о множестве ошибок, которые, как мне кажется, вызваны значениями None в ячейках. Я нажал «Игнорировать все»
Но мои таблицы вернулись с данными!