Hi guys, i have standart WHM backup, that set daily now i need to get/restore a mysql table only, how to do that, or where is the path to get this mysql table in ssh, its ok if i need to download the entire mysql file, not a table only
What you'll want to do is download and extract your backup, ending in .tar.gz if you chose to use compressed backups. Within the backup there will be a directory named mysql, there you should find the entire database backups. Choose the database that has the table you want to restore and copy the sql query that has the table you want to restore. You will want to place this in to another file, I would name table.sql. From command line, you can restore this using: mysql -o database_name < table.sql